yomango

Parsing CSV documents

Discussion created by yomango on Nov 17, 2015
Latest reply on Nov 20, 2015 by yomango

Hello, community fellows. I get EDI - CSV documents reports with no carriage returns on them. I want to parse each line. I can have the calculation go to the line I want but I can measure the length of the line because there's not a carriage return (¶), not a tilde (~) or an ending asterisk (*) I do not have a way to position that last character to get the length of the string line (the sample below shows 12  asterisk (*) for the B3 string line but some reports have 13). Neither I can reference the next line down since the reports vary from one to another (see the B3 string line):

ISA*00*          *00*          *02*FXFE           *ZZ*VSIA5032960454 *150924*0253*U*00401*000000815*0*P*:

GS*IM*FXFE*VSIA5032960454*20150924*0253*815*X*004010

ST*210*8150001

B3**2241308812**PP**20150921*23784**20150923*035*FXFE

G62*86*20150921

N1*SH*VETERINARY SERVICE INC

 

ISA*00*          *00*          *02*FXFE           *ZZ*VSIA5032960454 *151002*0313*U*00401*000000821*0*P*:

GS*IM*FXFE*VSIA5032960454*20151002*0313*821*X*004010

ST*210*8210001

B3**2241308860*SO5580918*PP**20150924*10859**20150928*035*FXFE

N9*BM*SO5580918

G62*86*20150924


I will be greatly thankful for your help

Outcomes