Replace loaded data separator from"," with "."

[markthepig]

Hello There

Ive been looking for a solution to this problem.

Let's say i load data from qvd files that have the following field

QTY

12,3

14,7

15,8

1,5

I want to make sure i load the date as

QTY

12.3

14.7

15.8

1.5

I know this probably is a stupid question since im a beginner with qlikview. Thank you very much for reading this.

Yours

Mark

[Siva_Sankar · Accepted solution]

Mark,  You can use MapSubString for this. Find the qv file attached. I think this will solve your problem.  Regards. Siva

[markthepig]

thank you for pointing me to the correct sollutiuon.

Really . really appreciated..

Yours

Mark