Hello,
I need some help here immediately. I am loading some flat file through ODI with field separator as pipe ( | ) but now some data value is having pipe inside it.
so I gave the secondary delimiter as /
which is not working. I tried with secondary delimiter double quotes " which is working and loading my data.
but that is also coming as the data value.
e.g. the data is ab|cd where | is part of the data. so in that column I want to store ab|cd where as my field separator is |
when I used " as secondary delimiter ODI is loading the data as ab"|"cd but I want the data to be loaded as ab|cd.
Delimiter (primary) is pipe ( | )
sample value
column 1 Column 2 Column 3
Kolkata | India | kulberia --> it is loading properly
Chennai | India | Madras | old --> here madras|old is the value of that column. If i give " as secondary delimiter then
Chennai | India | Madras"|"old --> this is how data is getting loaded, I don't want that " to come.
Can anybody help?
Regards,
Niladri