Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
marksmunich
Contributor III

Data cleansing

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"

1 Solution

Accepted Solutions
marcus_malinow
Valued Contributor III

Re: Data cleansing

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)

 

2 Replies
marcus_malinow
Valued Contributor III

Re: Data cleansing

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
Contributor III

Re: Data cleansing

I appreciate it. Thanks.

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

 

Thanks