topic Re: Replace string with a quote inside string in QlikView

Replace string with a quote inside string

Wed, 16 Apr 2014 08:53:02 GMT

Hi,

i want to repalce

the string >} inside the string tbl_Diagram_frm1_2 with a string wich contains some quotes -->

', DateYYYY_kum= {'>=$(Datumfilter1)'}, DateYYYY_kum= {'<= $(Datumfilter2)'} >}')

i tried -->

replace ( tbl_Diagram_frm1_2, ' >}', ', DateYYYY_kum= {'>=$(Datumfilter1)'}, DateYYYY_kum= {'<=

$(Datumfilter2)'} >}')

but it dosnt work - i think because of the quotes - i need some input about that

thanks in advance

regards

Georg

alexandros17 — Wed, 16 Apr 2014 08:55:12 GMT

For special characters use CHR() instruction to replace or combine strings

anbu1984 — Wed, 16 Apr 2014 09:07:56 GMT

Change quote in your replacement string to Chr(39)

Wed, 16 Apr 2014 09:14:52 GMT

perfect! thanks a lot!

Wed, 16 Apr 2014 09:15:10 GMT

great help! thanks!