Delimiter in the Source Data

[Former Member]

Hi All,

We are using BODS 3.2 on linux.

How should we handle when a delimiter is present in the source data.

For example:

We have CSV file as the source, The file has comma ',' as part of the data in one of the columns. When we execute the job it throws an error :

"A row delimiter was seen for row number <1> while processing column number <n> in file"

How do we handle these ( if a column delimiter is present in data)?????

[paul_kessler]

You did not say if you change the source file's field delimiter or added field framing characters. If you changed the delimiter in the source file, did you also change the delimiter setting in the File Format object?

[Former Member]

Hi Paul Kessler,

We have added field framing characters.

Regards,

Santosh

[warwick_tagg]

If you haven't done so already, you need to specify the text delimiter in the File Format. This will bypass any commas present within a field that are not actual field delimiters.

[Former Member]

Under Delimiters/Text within the file format type in ". The error should go away. The Delimiters section should look this:

Column - Comma

Row - {new line}

Text - "