Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this ways use chr(39)
LOAD *,PurgeChar(StringChar,chr(39)) as AftPurge;
LOAD * Inline [
StringChar
sdadad'dasda
sa'dfsd
uouo'gggggg ];
Regards,
Anand
I'm loading from an excel so I dont have the quoting option.
What difficulty you are facing.
Regards
Anand
Try this ways use chr(39)
LOAD *,PurgeChar(StringChar,chr(39)) as AftPurge;
LOAD * Inline [
StringChar
sdadad'dasda
sa'dfsd
uouo'gggggg ];
Regards,
Anand
Messed up the chr number somewhere