2 Replies Latest reply on Feb 2, 2012 8:18 AM by Penky

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

      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.