DSXchange

Hi,

I have text file which has multiple seperators in the data. (i.e the data consists of comma separator, space seprator in the same file)
I want to read this file using sequential file stage.
Can you guys help me how can i proceed.

Thanks

Can you post some examples of records from that file?

You'll probably need to read the record as a single long varchar field and then parse it "manually" but examples would help provide better direction.

Consider using Field Delimiter String property.

OR another option is to use tr or sed as unix command in a pre-job subroutine to replace one of the separators by the other allowing a read using a single separator value

Hi Chulett,

The file is like

111, "Mallika", India
121 "Chaithu" US
123, "Krishna", China

in the above file i have comma separated data in row-1 and space separated data in row-2.
So this file i want to read.

Hi,

Read ur file with a delimiter that u think will not come in ur file as a delimiter,this will read record in ur file as a single column.

If you want to create the different files of same delimiter we can do that also using a transformer and count function in the constraint.

Regards
Sachin Gupta

Of course, another option is to get whomever or whatever is producing that file to build a valid csv file rather than junk like that.

sachinag wrote:Hi,

Read ur file with a delimiter that u think will not come in ur file as a delimiter,this will read record in ur file as a single column.

If you want to create the different files of same delimiter we can do that also using a transformer and count function in the constraint.

Regards
Sachin Gupta

The second person personal pronoun is spelled "you" in English, or "your" in possessive case.

Please eschew SMS-style abbreviations and prefer professional written English on DSXchange.