Hi everybody,

Although I'm new to Pipeline Pilot, I already like it very much. I have however encountered an issue regarding the output of my data. Let my explain.

I'm processing data such that they later can be used by the Oracle SQL loader, the input file must be comma-separated and each value is enclosed with double quotes ("). In my pipeline, I have to read the data from an Access DB and then add the quotes to each value. Once done, I export it to a comma-separated file.

The process of appending the quotes to all the values results in the following format: every value is transformed into "value":

1 -> "1"

text -> "text"

However I encoutered an issue when exporting the data to the Delimited Text Writer because that component adds two extra double quotes to each double quote, which leads to an output that looks like:

"""1""", """text""" ...

I really don't understant why this happens because if I set another output component like a "notepad viewer" or an "Excel Viewer", the values are represented as expected. Furthermore I did not find any parameter in the "Delimited Text Writer" that could help me.

Has somebody any hint about this behaviour ? Does this "Delimited Text writer" behaves correctly, and why ?

Many thanks in advance for any suggestion

Luc