Good Day All
We are assisting a client to build a business adapter to bring in information from Oracle EBS. They have created a CSV file for us to use (see attached), however we have a question on that:
A quick check, when opening the attached file in Excel because one of the fields in the extracted file contains a comma, it breaks and we end up with two columns instead of one when opening CSV in Excel.
So when doing a text-to-column operation to view the dataset in their respective column format it does not work well.
Apparently it will only happens with Excel.
Can you confirm we won’t have this issue with business adapter and lose some data during processing, the separator character is obviously not the comma but the pipe (|) ?
Your assistance in this matter is much appreciated.
regards
Manish
‎Sep 02, 2019 07:10 AM
Hi Manish,
It should work with the pipe symbol. But I guess you'll have to use a schema.ini file to declare the delimiter and set the delimiter inside the BAS to "None".
Best regards,
Markward
‎Sep 02, 2019 07:15 AM