Replace multiple fields data

[mohan2391]

Hi,

How to replace , with . in multiple fields ?

Ex: I have 30 fields, in which I have to replace ,(comma) with .(dot) -- in Qlikview script itself

    I know that, replace function can be used for this purpose but I need to write it for every field.

    So is there any possibility to replace all the 30 fields data at a time ?

Regards

mohan

[Anil_Babu_Samineni]

Does 30 fields are in same table?

[stabben23]

change here maybe?

[mohan2391]

YES

[mohan2391]

If  I use this, it will effect in all fields, right.

but i want to change in those 30 only there are lot more fields in that table available.

[stabben23]

Havent test but if you change back after this table, for ex

SET DecimalSep='.';
LOAD
;
from your table;

SET DecimalSep=',';

[sudhirpkuwar]

Hi

Better is to write replace() for every field individually 

[stabben23]

or this maybe

SET DecimalSep='.';
//first 30 field with .
LOAD
ItemId,
Field1,
Field2

FROM
[create.xlsx]
(ooxml, embedded labels, table is Blad1);

SET DecimalSep=',';

//join other field with ,
join LOAD
ItemId, 
Field3,
Field4
FROM
[create.xlsx]
(ooxml, embedded labels, table is Blad1);