Ftp adapter is not able to read properly a CSV file where the separator is | (pipe) for a case
I am reading a CSV file through FTP adapter where the separator is pipe (|). It is working fine but whenever there is a particular record has a | (pipe) in it then the my FTP adapter is considering it as record separator and messing the whole data. For example :
This is working fine :
record1 | record2 | record3 | record4
But this is not :
record1 | "record2|abcd" | record3 | record4
it is considring the record2 and abcd as two seprate records. How to handle it ? Btw, we are using Oracle SOA 12.1.2.3
Thanks,
Debdeep