Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

dan-ketil
Contributor II

mass replace

Hi, not sure if I post this under the right category, sorry for that


I have a csv files that containes several special characters settings. I.e. %C2 that should be , (comma)

We use datastage to process this file and store it in our database.

I cannot do a replace within the csv file prior to the read operation into Qlivkview, the replace need be done within qikview after read from database.


What I am looking for is a solution to scan thru all fields and do a replace from %C2 -> ,


Any ideas?


BR

Dan

Tags (1)
1 Reply

Re: mass replace

I think you could use a transforming-function for each of your fields, for example:

set e = replace($1, '%C2', ',');


load $(e(F1)) as F1, $(e(F2)) as F2 from Source;

By several replacings would a mapsubstring be more elegant and could be also put in a variable like above which will work like a custom function. For mapsubstring take a look here:

Re: Passing parameter strings that contain special characters

- Marcus