Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
tmumaw
Specialist II
Specialist II

Eliminating the double quotes

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

example "3308774875"

1 Solution

Accepted Solutions
stephencredmond
Luminary Alumni
Luminary Alumni

Hi Thom,

You can use the PurgeChar function to remove characters that may or may not be there:

PurgeChar(MyField, Chr(34))

Stephen

View solution in original post

4 Replies
stephencredmond
Luminary Alumni
Luminary Alumni

Hi Thom,

You can use the PurgeChar function to remove characters that may or may not be there:

PurgeChar(MyField, Chr(34))

Stephen

deepakk
Partner - Specialist III
Partner - Specialist III

hi Thom,

try using replace function.

eg:

trim(replace(fieldname, '"',' '))

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 ' '

tmumaw
Specialist II
Specialist II
Author

Thanks Stephen it worked perfect. Have a great day.....I know I will now.

Thom

tmumaw
Specialist II
Specialist II
Author

Thanks...Thom