on 2020 Nov 24 5:40 AM
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
User | Count |
---|---|
103 | |
10 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.