Hello,
my incoming .csv file has embedded line breaks surrounded by double quotes. It looks like:
Account|User ID|Notes
1234567|123456|"This is a test note on account 1234567."
2345678|123456|"Hello, this is Toly from ABC company.
I am calling to let you know that we have registered the disputes for you
on the following invoices:
Invoice Date Invoice # Open Amount Due Date
Do you have any further information that might help us with these disputes?
Thank you
Toly"
I cannot read this file when the notes have line breaks and go to the next line. Is there any way to read it?
Your help is greatly appreciated.
Toly
incoming .csv file with embedded line breaks
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 246
- Joined: Mon Jun 30, 2008 3:22 am
- Location: New York
- Contact:
I assume that your file will have a " and Line termonator at end of each record. If so, Say if your file has DOS terminator, try to read the whole file using a folder stage, pass it to a transformer, replace all the " and DOS line terminator to " and UNIX line terminator and pass it to another transfomer where you can replace all other DOS terminators to a space/comma/pipe or whatever and write to a file. Now read the file as defining it to have UNIX line terminator. This should give all your records in a single line.
Let me know if I did not understand your requirement properly.
Let me know if I did not understand your requirement properly.
Arun
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: