String to Number from Excel with Currency Symbol

I get this value from a sheet - R$ 890,00, and I need to use as a Number to group, sum and etc.

But I can’t read it from excel as a number, is there a way to use Format options to identify this as a number and enable this?

Ps: The R$ are the currency symbol for Brazil.

Use Modified JavaScript to remove ‘R$’ then convert into number format using rename field. After this you can perform Number to group , sum and more operations

1 Like

Did that and also removed dots and comma. after that I used a Java command to help:

var Valor = parseFloat (Valor)

then I was able to change it to number using RenameFields and its Formats.

1 Like