I am working in tools and have a call to make to a CSV file. The problem is that the first parameter I am using has many commas in it because it's a forumla. I want to be able to use this formula and ignore the 3 commas. I have tried everything but can't seem to get it to work.
Anyone have any ideas?
var formtest = "=IF(BD2<>"",1*LEFT(BD2,1),0)"; Clib.fputs(formtest, ToNumber(psFormulaRec.GetProperty("outFilePtr")));
I need to ignore the 3 commas in the formtest variable.