DSXchange

Posted: **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.

Posted: **Tue Dec 20, 2011 11:52 am**

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

Posted: **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

Posted: **Tue Dec 20, 2011 2:57 pm**

You can use no delimiter and no quote character.

DSXchange

Reading the column thru Seq stage

Reading the column thru Seq stage