Replace ' character in fileds

[#1]

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 !

[#2 · Accepted solution]

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

[#3]

thank you Merci Merci beaucoup 🙂

it's works perfectly !

thank you very much !

[#4]

Ha...! all credits goes to MR. Rob Wunderlich , because i have read this one in his bolg.

cheers

- Sridhar

[rbecher]

Okay, MapSubstring( ) is one way, it's also easy (and more flexible) with the replace function:

replace(<field>, chr(39), ' ')

Ralf

[rbecher]

..this app was with comma not w/ qoute.

[#7]

Hi,

It will work but you need to take all info to excel as i did.

check the attachment

- Sridhar

[rbecher]

..with double quotes use chr(34), just as simple as this:

Load *,
replace(Product, chr(34), ' ') as Product_Replace;
LOAD Product
FROM (biff, embedded labels, table is Sheet1$);

Ralf

[qlikviewforum]

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"

[rbecher]

Just add the double qoutes:

'"' & path & '"'  // single double single quote & ..

- Ralf