Data cleansing

[marksmunich]

I have a funny situation where data is stored with " ". Double quotes for all the values. I am wondering if there is a way to get rid of it easily. the problem is it exists for all the columns and rows of data.

like 

"Coutnry"

"USA"

"JAPAN"

"GERMANY"

"Revenue"

"200000"

"600000"

"800000"

[marcus_malinow · Accepted solution]

You could use the purgechar function in your load script:

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/StringFunctions/PurgeC...

For example purgechar([Your Field], chr(34))

(n.b. chr(34) is a double quote character)

[marksmunich]

I appreciate it. Thanks.

is it possible to do all tables, coulumns in one go ?

Thanks