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)?????

[warwick_tagg]

Do you have any scope to change how the source file is produced?

Can you get the file produced with a different delimiter?

If not, could you use a text delimiter (") to indicate the start and end of a column, which is then comma delimited? (i.e. "Column 1 text","Details of column, and other information","Column 3")

[Former Member]

Thanks Warwick Tagg,

We are getting the source data just the way u have mentioned, but still facing the error.

Regards,

Santosh