I need to use values extracted from a xml file to filter a datatable, this datatable is created in a read csv file activity.
in the csv file, the values does not ends with 0. For example: price $ 120,50 in the csv file will be 125,5. price $ 120,00 in the csv file will be 120.
in the xml file the values end with 0, sometimes there are more 0 that we need (Example: $ 90.00000000)
The problem is: when i extract the value from the xml it has all the 0 but if i use this value to filter the datatable it will not return anything because in dt the values does not ends with 0
I can’t use length-2(or length-3 because of the “,”) because of values like 120,43
Below is an example of the xml and csv file
the tag qCom is the column “Quantidade”
vUnCom is “Valor_unitario”
vProd is “Valor_Total”
I’m tying to use this informations to return the value in “Item” column, because this values (qCom, vUnCom, Vprod) are the only thing in the xml that is equal in the csv file, and i need this “Item” to continue with a biggier automation project.