Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to tackle CSV file with comma in data fields in ODI Datastore

3123015May 9 2016 — edited May 9 2016

My Source file is in CSV format and few of the datafiles contains , as 100 or 1000 separator(Ex - 1000,112.00,4444,333 etc). This is messing up the whole data after reverse engineering.

How to handle this situation in datastore ?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 6 2016
Added on May 9 2016
7 comments
2,098 views