Skip to Content
-1
Nov 24, 2020 at 05:40 AM

csv bug due to CRLF

35 Views

Hi Team,

We have an issue with csv file processing. We have a requirement to process the time stamps in the deliveries from an incoming csv file. We are using the fm tseg_write_update to update the delivery time stamps. But we have issues when there is crlf coming in the file without ;

For eg in a line if there is a time stamp entry "status unloading departure;2020.11.12 06:29:2020.11.17 13:25:03;CETCRLF"

then if we execute the program the program is resulting in a dump. In the debug mode we could find the CRLF is being interpreted as # character. Then we tried to process it by adding a ‹‹ ; ›› (manually)and found we were able to process.

The question is, is there anyway to add ‹‹ ; >> in the background before CRLF while processing the file or just remove CRLF from the file using coding?

Please let me know if any of you have encountered the same issue?

Regards

AW