4 Replies Latest reply: May 15, 2014 10:02 AM by ccribbs _ RSS

    New User, simple problem

    ccribbs _

      I am a new monarch user and I can't wait to really get into all uses of this amazing software, however I can see I have a long way to go.  I don't have all of the jargin down yet so I hope I am clear.  I'm trying to trap all data in a CSV file so I have used a floating trap with the commas to differentiate the fields.  My problem occurs when there is a blank field ie 12345,,54321,678  where the ,, isn't consistent throughout the file.  Any help is greatly appreciated.

       

      ACCT,REFER,POST.AMT.EXT,CNTL.LJUST,POST.DESC,NAME,LGN.ID,DESC,SRC.JRNL.ID,C

      4000111,H0730,-94412.89,8654,SELL PRICE,,CA719-A,SLS M-B CLS550,101,,SANDIE

      4000411,90004,-41000,8464,SELL PRICE,,CA719-A,SLS M-B C300W,101,,SANDIEGO,1

      4000411,90004,1000,90004,OVERALLOWANCE,,CA719-A,SLS M-B C300W,101,,OA,10/31

      4000411,90033,-32650,8482,SELL PRICE,,CA719-A,SLS M-B C300W,101,,SANDIEGO,1

      4000411,90033,-2000,90033,UNDERALLOWANC,,CA719-A,SLS M-B C300W,101,,UA,11/3

      /CODE