How to remove double quotes ( " )

suresh.narasimha · Post by **suresh.narasimha** » Tue Dec 20, 2005 11:52 pm

Hi
I have Source Sequential File , in one of the field while processing after 11,000 rows it encounters a double quote and throws an error

read_delimited() - invalid quotes, column STEXT = "Introduction to Enterprise Architecture| |TC |"

I need to remove the double quote in the transformer and pass the data.

i have searched in dsxchange regarding this ... but i could not make out.

any suggestion might be a great help .

Thanks in Advance

kcshankar · Post by **kcshankar** » Wed Dec 21, 2005 12:05 am

Hi suresh,
If u want to remove double quote in the Transformer and pass the data,use Ereplace function in the Transformer.

Ereplace (string, substring, replacement [ ,number [ ,begin] ] )

Regards
kcs

Bala R · Post by **Bala R** » Wed Dec 21, 2005 12:08 am

In the sequential file stage you have option to define your quotes. If you have given single quotes change it to double quotes and request whoever that provides you the files to maintain consistent quote character. I suppose the quotes were provided in the file because of the embedded piping symbol in the string.
HTH.

loveojha2 · Post by **loveojha2** » Wed Dec 21, 2005 12:16 am

kcshankar wrote:Hi suresh,
If u want to remove double quote in the Transformer and pass the data,use Ereplace function in the Transformer.

Ereplace (string, substring, replacement [ ,number [ ,begin] ] )

Regards
kcs

What you can do is read a single line of sequential file as one column
in the transformer use Ereplace as

Code: Select all

Ereplace(DSLinkname.columnname,'"',"")

write this to an intermediate Hashed file, from there write it to the original sequential file.

suresh.narasimha · Post by **suresh.narasimha** » Wed Dec 21, 2005 1:26 am

Hi guys

Thanks for ur suggestions .
But Ereplace i have tried but that was not accepting.

Experts please spend your valuable time

Thanks in advance

ray.wurlod · Post by **ray.wurlod** » Wed Dec 21, 2005 1:37 am

Please post the message that leads you to your assertion that "it was not accepting". Ereplace is an intrinsic function - it must be accepted by the Expression Editor. Perhaps someone has edited your DSParams file, but let's not leap to conclusions without your next post.

The best solution is to have the originators of the file to do quotes properly.

The next best solution is to change the quote character on your Sequential File stage's format tab. Then process the quotes yourself.

suresh.narasimha · Post by **suresh.narasimha** » Wed Dec 21, 2005 5:51 am

Hey

i tried like this in the derivation part of transformer

Ereplace(Fieldname,""","")

The above derivation is not accepted

Provide me the solution please .....

ravij · Post by **ravij** » Wed Dec 21, 2005 6:12 am

Hi Suresh,

Use this EReplace function.

EReplace(Iconv(Linkname.fieldname,"MCP"),'"', "")

RK

kcshankar · Post by **kcshankar** » Wed Dec 21, 2005 6:17 am

Hi suresh,

Use double quote within single quote(' ')
Ereplace(source.Field001,'"','')

regards
kcs

kduke · Post by **kduke** » Wed Dec 21, 2005 8:33 am

Use convert() it is faster than ereplace(). It does not do as much but is very good for this type of thing.