delimiter reading

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
parvathi
Participant
Posts: 103
Joined: Wed Jul 05, 2006 4:48 am
Contact:

delimiter reading

Post by parvathi »

Hi all

I have a problem while reading with delimiters... in the sequential stage

the record is as below

QuoteChar "\""

In this case i have the delimiter as "

so first column value is QuoteChar
second column value is \
third column value is null

but i want to have second column value as \"


How can I do that...?? Do i need to set anything
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

You cannot solve your problem with the quote character defined as a ".
This is because the line is not well-formed due to unbalanced quotes. You will need to specify another quote character or delimiter to avoid this.
Post Reply