topic Data cleansing in App Development

Data cleansing

marksmunich — Sat, 16 Nov 2024 21:02:26 GMT

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.

"Coutnry"

"USA"

"JAPAN"

"GERMANY"

"Revenue"

"200000"

"600000"

"800000"

Re: Data cleansing

marcus_malinow — Tue, 16 Apr 2019 08:50:53 GMT

You could use the purgechar function in your load script:

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

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

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

Re: Data cleansing

marksmunich — Tue, 16 Apr 2019 09:50:04 GMT

I appreciate it. Thanks.

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

Thanks