How to convert String to Number from Excel with Currency Symbol
Problem Statement:
We are getting this value from a sheet - R$ 890,00, and we want to use it as a Number to group, sum and etc. But we can’t read it from excel as a number, is there a way to use Format options to identify this as a number and use this for further processing?
Solution:
- Use Modified JavaScript to remove ‘R$’ then convert into number format using the Rename field. Also removed dots and comma.
- After that, use a Java command to help:
var Value = parseFloat (Value)
- After this, you will able to change it to a number using RenameFields and its Formats and you can perform Number to the group, sum, and more operations