topic Re: replacf function in QlikView

replacf function

adiarnon — Thu, 10 Mar 2016 15:17:39 GMT

hi,

i have string and i need to delete the ' and the "

exemple:

'aklasdfj'dasdf ->aklasdfjdasdf

(without ')

"a"das"df ->adasdf

(without ")

how can i do it?

Re: replacf function

its_anandrjs — Thu, 10 Mar 2016 15:22:10 GMT

Try This ways

LOAD *,KeepChar(StringChar,'abcdefghijklmnopqrstuvwxyz') as NewChar;

LOAD * Inline

[

StringChar

'aklasdfj'dasdf

"a"das"df

];

Regards

Anand

Re: replacf function

Gysbert_Wassenaar — Thu, 10 Mar 2016 15:22:20 GMT

Purgechar(MyString, '''"')

That's an opening single quote, then two single quotes so the first escapes the second, then a double quote and finally a closing single quote.

Re: replacf function

sunny_talwar — Thu, 10 Mar 2016 15:22:58 GMT

Or this:

PurgeChar(Fieldname, Chr(39)) as NewFieldName

UPDATE:

for both single and double quotes, you can try this:

PurgeChar(Fieldname, Chr(34)&Chr(39)) as NewFieldName

Re: replacf function

maxgro — Thu, 10 Mar 2016 15:28:03 GMT

load

field,

PurgeChar(field, chr(39)&chr(34)) as newfield

inline [

field

'aklasdfj'dasdf

(without ')

"a"das"df

];

Re: replacf function

Gysbert_Wassenaar — Thu, 10 Mar 2016 15:28:06 GMT

That's probably a better solution. Easier to read and understand than all those quotes.

Re: replacf function

Anonymous — Thu, 10 Mar 2016 15:33:02 GMT

Hi Adi,

I will use PurgeChar() function.

PurgeChar(YourString, YourCharToRemove)

Quote and Double Quote = chr(39) and chr(34)

See complete Ascii table: http://www.asciitable.com/

Best

Maurice