Oracle SOA Suite (MOSC)

MOSC Banner

Ftp adapter is not able to read properly a CSV file where the separator is | (pipe) for a case

edited Jan 12, 2022 7:54PM in Oracle SOA Suite (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center