Sever Job: Not able to read (') in data

[harshada]

Hi,

I have a server job

Seq file read -> transformer-> o/p seq file.


Data contains ... "HE GARDENER'S COTTAGE"

Server job aborts saying


STG_INP_01.INP_01: nls_read_delimited() - invalid quotes, column ADDRESS2 = "HE GARDENER'S COTTAGE","


Is this to be specially handelled?


Thanks

[chulett]

So do you have a single or double quote inside your quoted string? Guessing the latter even though your example shows the former.