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

csv bug due to CRLF


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?