to include double quote in front and rear of row of data

[agathaeleanor]

Hi All expert,

Need your advice on how do i achieve on below scenario.

Due to some constraint, sequential file is given in a format of (separate by delimiter --> ","

001","CEREL","29","1-yearly","1990

However in DS, I am require to include a double quote(front and rear) for each row of data as

"001","CEREL","29","1-yearly","1990"

May I know how can I achieve this in DS?
Thanks in advance for your help.

[BI-RMA]

Hi agathaeleanor,

To read the file, set the option "delimiter string" of the Sequential-File-Stage to <<",">> and the Option Quote Character to <<none>>. That's it.

If your target is another sequential file, set the format-option for Quote Character of the output-file to double quotes and the option delimiter to <<,>>. Again: That's it. Is there any other scenario where you would want quotes in your output?

[ray.wurlod]

Read the entire line as a single VarChar field, then concatenate quote characters in a Transformer stage before parsing into separate fields.