Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

csv file read failing in OIC when value contains escape characters quote( ") and comma( ,)

in Integration 1 comment

Summary: csv file read failing in OIC when value contains escape characters quote( ") and comma( ,)


Content (please ensure you mask any confidential information):

I have records in csv which contain Quote (") itself as the data value, which I can handle by using element with quotedBy=< so translator can ignore Quotes(").

Now, the problem with this is…if I have value for same column with a Comma(,) it splits the data to be considered as separate columns…

Anyone has any suggestion how to deal with it?

PFA sample csv file in zip.

"Trans Type","Guid","Supplier Item Guid","Supplier Item Supplier Name","Supplier Item Number"

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!