convert text to money in load script

[die77]

Hi expert, 

i am having trouble managing a format conversion

I have a field like this

€ 11.100,32

qlik import as text, and i can't use it to sum 😕

How I import in load script as money ( euro) or num in order to use it to sum? 

Thanks in advance

D.

[Anil_Babu_Samineni]

@die77 you can use format around like Money - script and chart function | QlikView Help

[marcus_sommer]

Just keeping the relevant information might be done per:

keepchar(MyField, '0123456789,') as MyField

[MayilVahanan · Accepted solution]

Hi

Try like below

Money(Money#(Replace('€ 11.100,32','€ ',''), '##.###,##',',','.'))