2 Replies Latest reply: May 15, 2014 10:11 AM by Amadeus23 _ RSS

    Removing ","

    Amadeus23 _

      I need to pull the last number in this row (bottom)but am having trouble with the commas.  (Comma deliminated file pulled into Monarch 10).  I thought I could try somethng like 

       

      RSplit(Main,5,"Chr(34),Chr(34)",5)

       

      to remove the "," and then whatever commas that are left over are those inside a number, but doesn't seem to be working.  Any ideas?  Thanks

       

       

      "Totals:","($259,205.77)","$0.00","$0.00","$0.00","($259,205.77)"