Record getting rejected due to additional delimiter

bhargav_dd · Post by **bhargav_dd** » Thu Apr 14, 2011 5:13 am

Hi all,

I have a record getting rejected due to additional delimiter found in name
field.

I have a record:

"100774066","M "TORREZ, MRS"","21.82","7186551241 ","TORREZ, MRS","BD",/
/,"5576"

The field "M "TORREZ, MRS"" is one field. but since file is comma delimited
record getting rejected. how to read these field as one field?
And same thing with "TORREZ, MRS" also.

Please give me some advise

Thanks.

GJ_Stage · Post by **GJ_Stage** » Thu Apr 14, 2011 9:59 am

Hi ,

From my research there is no solution , may be someone can help this.
I also faced same situation and I asked Business to change the delimiter instead of comma ask them to send ~ (tilde). Becasuse this ~ symbol won't come in name.

chulett · Post by **chulett** » Thu Apr 14, 2011 10:10 am

An option is to use a Server job, the Sequential File stage there is more accomdating of issues like this for some reason.

ray.wurlod · Post by **ray.wurlod** » Thu Apr 14, 2011 4:40 pm

Or you can use a server Sequential File stage in a server Shared Container in your parallel job.

chulett · Post by **chulett** » Thu Apr 14, 2011 9:52 pm

Or that.