This discussion is archived
2 Replies Latest reply: Feb 2, 2012 12:18 AM by Penky RSS

Clib.fputs call passing "if" statement with commas to CSV file, help!

914388 Newbie
Currently Being Moderated
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.

Thanks for any help.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points