CODEWITHSUNDEEP
csvescapingquotesbusiness-objects
Ben Ostrowsky
Ben Ostrowsky

Reputation: 111

How can I read a CSV with quoted commas as a flat file in BusinessObjects Data Services Designer?

I'm trying to get SAP BusinessObjects Data Services Designer 12.2.3.1 to read a CSV file that contains rows like:

"00501","P",0,0,"Nassau-Suffolk, NY","SUFFOLK"

The results I'm getting with column delimiter set to Comma, however, read that line as seven columns rather than six:

"00501"    "P"       0        0       "Nassau-Suffolk        NY"      "SUFFOLK"

What additional options do I need in order to read the file as-is, without external preprocessing? (If this isn't possible, please say so and I'll stop getting grey matter all over this nice brick wall. Thanks!)

Upvotes: 1

Views: 4080

Answers (2)

Mahantesh Hiremath
Mahantesh Hiremath

Reputation: 1

Solution to load data with double quote:

screenshot of settings

Upvotes: 1

Ben Ostrowsky
Ben Ostrowsky

Reputation: 111

The solution was to set the Text delimiter to ".

Text: Denotes the start and end of a text string. All characters (including those specified as column delimiters) between the first and second occurrence of this character is a single text string. The treatment of the row characters is defined by the "Row within text string" setting.

Upvotes: 0

Related Questions