Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Sorry for my poor english but i'm french.
I'd like to know how replace a quote character <'> in a field.
I tried to use the function <replace> using <"'"> in option :
replace(<field>, "'",'') but it doesn't work !
Can someone help me please !
Hi Romain,
Check the attached application.
In my application, i have replaced <,> in to space < >.
Check the attachment , you`ll get a idea.
Cheers
- Sridhar
Hi Romain,
Check the attached application.
In my application, i have replaced <,> in to space < >.
Check the attachment , you`ll get a idea.
Cheers
- Sridhar
thank you Merci Merci beaucoup 🙂
it's works perfectly !
thank you very much !
Ha...! all credits goes to MR. Rob Wunderlich , because i have read this one in his bolg.
cheers
- Sridhar
Okay, MapSubstring( ) is one way, it's also easy (and more flexible) with the replace function:
replace(<field>, chr(39), ' ')
Ralf
..this app was with comma not w/ qoute.
Hi,
It will work but you need to take all info to excel as i did.
check the attachment
- Sridhar
..with double quotes use chr(34), just as simple as this:
Load *,
replace(Product, chr(34), ' ') as Product_Replace;
LOAD Product
FROM
Ralf
How can I use replace(or any other string function) to put double quotes in the start and end of the path? Because New Folder contains space in between.
"C:\Documents and Settings\MYUSER\Desktop\New Folder"
Just add the double qoutes:
'"' & path & '"' // single double single quote & ..
- Ralf