topic Eliminating the double quotes in QlikView https://community.qlik.com/t5/QlikView/Eliminating-the-double-quotes/m-p/188056#M51481 <HTML><HEAD></HEAD><BODY><P>hi Thom,</P><P>try using replace function.</P><P>eg:</P><P>trim(replace(fieldname, '"',' '))</P><P>first parameter takes the fieldname , second parameter the character to be replace ,it should be between single quotes ' " '. third parameter is the new character, here it will be blank or space like ' '</P></BODY></HTML> Tue, 29 Mar 2011 16:01:28 GMT deepakk 2011-03-29T16:01:28Z Eliminating the double quotes https://community.qlik.com/t5/QlikView/Eliminating-the-double-quotes/m-p/188054#M51479 <HTML><HEAD></HEAD><BODY><P>Is there a way to eliminate the double quotes? It appears some of the fields stored in our sql db are defined a text. Thanks</P><P>example "3308774875"</P></BODY></HTML> Tue, 29 Mar 2011 15:55:52 GMT https://community.qlik.com/t5/QlikView/Eliminating-the-double-quotes/m-p/188054#M51479 tmumaw 2011-03-29T15:55:52Z Eliminating the double quotes https://community.qlik.com/t5/QlikView/Eliminating-the-double-quotes/m-p/188055#M51480 <HTML><HEAD></HEAD><BODY><P>Hi Thom,</P><P>You can use the PurgeChar function to remove characters that may or may not be there:</P><P><STRONG>PurgeChar(MyField, Chr(34))</STRONG></P><P></P><P></P><P>Stephen</P><P></P></BODY></HTML> Tue, 29 Mar 2011 16:00:04 GMT https://community.qlik.com/t5/QlikView/Eliminating-the-double-quotes/m-p/188055#M51480 stephencredmond 2011-03-29T16:00:04Z Eliminating the double quotes https://community.qlik.com/t5/QlikView/Eliminating-the-double-quotes/m-p/188056#M51481 <HTML><HEAD></HEAD><BODY><P>hi Thom,</P><P>try using replace function.</P><P>eg:</P><P>trim(replace(fieldname, '"',' '))</P><P>first parameter takes the fieldname , second parameter the character to be replace ,it should be between single quotes ' " '. third parameter is the new character, here it will be blank or space like ' '</P></BODY></HTML> Tue, 29 Mar 2011 16:01:28 GMT https://community.qlik.com/t5/QlikView/Eliminating-the-double-quotes/m-p/188056#M51481 deepakk 2011-03-29T16:01:28Z Eliminating the double quotes https://community.qlik.com/t5/QlikView/Eliminating-the-double-quotes/m-p/188057#M51482 <HTML><HEAD></HEAD><BODY><P>Thanks Stephen it worked perfect. Have a great day.....I know I will now.</P><P>Thom</P></BODY></HTML> Tue, 29 Mar 2011 16:37:55 GMT https://community.qlik.com/t5/QlikView/Eliminating-the-double-quotes/m-p/188057#M51482 tmumaw 2011-03-29T16:37:55Z Eliminating the double quotes https://community.qlik.com/t5/QlikView/Eliminating-the-double-quotes/m-p/188058#M51483 <HTML><HEAD></HEAD><BODY><P>Thanks...Thom</P></BODY></HTML> Tue, 29 Mar 2011 16:42:24 GMT https://community.qlik.com/t5/QlikView/Eliminating-the-double-quotes/m-p/188058#M51483 tmumaw 2011-03-29T16:42:24Z