How to purge the ' character from the values of a field?

[cheburashka]

Hello,

How can I purge the ' character from the values of a field?

I tried

purgechar(''')

and

purgechar(chr(13))

and

purgechar('chr(13)')

Any other ideas?

,Kr Koen

[cheburashka]

I'm loading from an excel so I dont have the quoting option.

[its_anandrjs]

What difficulty you are facing.

Regards

Anand

[its_anandrjs · Accepted solution]

Try this ways use chr(39)

LOAD *,PurgeChar(StringChar,chr(39)) as AftPurge;

LOAD * Inline [

StringChar

sdadad'dasda

sa'dfsd

uouo'gggggg ];

Regards,

Anand

[cheburashka]

Messed up the chr number somewhere