Parse XLS column from Excel file (Qlik Sense)

[b_kotur]

Hello,

I'm Loading an Excel table that has one column of XML type. How can I parse this column in the script to have just the desired value from it?

The column that would need parsing looks something like this: 

 <amount>0.035</amount>

The expected output is to have just 0.035 as the column value.

Many thanks for considering my request.

[marcus_sommer · Accepted solution]

Maybe just: keepchar(Field, '0123456789.') as Field

- Marcus

[b_kotur]

Thank you, Marcus, that worked great!