AnsweredAssumed Answered

Remove extra commas at the end of CSV record

Question asked by venkatesh.rupanagudi080702 on Feb 9, 2017
Latest reply on Feb 10, 2017 by 51662476

Hi,

 

I want to remove the commas at the end of the record as shown below for SHP and DET records. These are not required for customer receiving the file.

 

ASN,1021,P,4500001344,09Feb2017
SHP,,,,,,4500001344,OTHR,,,31Jan20170001,,,,,,,,,,
DET,,ACK122211,1100.000,4500001344,,,,,,,,,,,,,,,,,,EA,00010,,,,,,,,,,,,,
DET,,ACK122212,2100.000,4500001344,,,,,,,,,,,,,,,,,,EA,00020,,,,,,,,,,,,,
DET,,ACK122213,2100.000,4500001344,,,,,,,,,,,,,,,,,,EA,00030,,,,,,,,,,,,,
DET,,ACK42213,1570.000,4500001344,,,,,,,,,,,,,,,,,,EA,00040,,,,,,,,,,,,,
DET,,DTH-1320-UK,144.000,4500001344,,,,,,,,,,,,,,,,,,EA,00050,,,,,,,,,,,,,
DET,,DTH-1320-EU,288.000,4500001344,,,,,,,,,,,,,,,,,,EA,00060,,,,,,,,,,,,,

 

Thanks

Venky

Outcomes