on 06-28-2013 4:13 PM
Hi Experts
I am reading a csv file using opencsv.
The csv files is seprated by comma (,) and enclosed in double quotes.
Test.csv file:
ID, Country, ShortName, Quantity
"1", "UK", "Nice\Good", "120"
The problem occurs when reading the values of a column ShortName that has the special character backslash (\), this is stripped out of the value.
The value of ShortName becomes: NiceGood.
How does opencsv (CSVReader) can be able to read the '\' special character?
Your help would be appreciated.
This issue is resolved by using java module.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Dai,
What is the File encoding you have used in you sender channel?
try UTF-16 if still it is not working mark it to "TEXT" instead of "Binary" and try ISSO8859 encoding.
Thanks and Rgegards,
Naveen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ally,
Are you trying to use FCC in sender file channel?
I think if the requirement is to read complex csv file with special character, then you may have to use Java mapping to read the file and convert to xml file before feeding to PI.
try this link for more action on opencsv reader.
http://wiki.sdn.sap.com/wiki/display/NWTech/Java+Mapping+to+Read+Complex+CSV+File
Thanks!
Praveen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.