Reading the column thru Seq stage

vskr72 · Post by **vskr72** » Tue Dec 20, 2011 9:02 am

I have a comma seperated sequential file. It has a one of a column like this. I am struggling to read this.

"DOS 5, WINDOWS 3.1, MOUSE, 3.5"" DIS",

When I sprcify w/o quotes, then it is placing the values 'DOS 5' and 'WINDOWS 3.1' in seperate columns. But whne I specify quotes, then it is reading "DOS 5, WINDOWS 3.1, MOUSE, 3.5" as one column and DIS into another. Can this be handled anyway thru the format settings of a seq file stage. Pls help.

pandeesh · Post by **pandeesh** » Tue Dec 20, 2011 11:52 am

Specify a whole record from your input file and post how you want that to be splitted.

zulfi123786 · Post by **zulfi123786** » Tue Dec 20, 2011 1:58 pm

how would Datastage understand that

Code: Select all

"DOS 5, WINDOWS 3.1, MOUSE, 3.5"" DIS",

is a single column. It uses delimiter And/Or Quote to split record into columns. If the data listed is a value of single column then you either need to change your delimiter or Quote character to something which has zero probability of being a part of columns value

ray.wurlod · Post by **ray.wurlod** » Tue Dec 20, 2011 2:57 pm

You can use no delimiter and no quote character.