AnsweredAssumed Answered

Remove a record in csv file

Question asked by venkatesh.rupanagudi080702 on Jun 8, 2017
Latest reply on Jun 12, 2017 by venkatesh.rupanagudi080702

Hi,

 

Below is CSV file. I need to remove 1 extra NOT record  and always maintain 3 NOT records max. 

 

 

ASN,1011,P,4500001768,07JUN2017
SHP,,,,,,4500001768,OTHR,,,06JUN20170900
NOT,0,OC 1700001368
NOT,0,OCEAN to Memphis
NOT,0,ETD 5/6
NOT,0,ETA 5/6
DET,,ACK42215,5760.000,4500001768,,,,,,,,,,,,,,,,,,EA,00010

 

Thanks,

Venkatesh

Outcomes