Hello,
I have built my first app with the receipt processor. Some values are not correctly recognized, for example I get
1,169 EUR /1
and I want only the value
1,169
How could I convert this to a proper value?
thanks für your suggestions
Polo
Perfect, thanks a lot !
Hi @polo1604 ,
Please try this formula instead:
Match("1,1.69 EUR /1","[0-9,\.]*").FullMatch
Best Regards,
Bof
thanks for your reply. Instead of "1,169 EUR /1" I have to take the result from the receipt processor, right?
Sometimes I get items with comma, sometimes with dots, depending on the country of the merchant. For example "3.123 EUR /1" or "3,123 EUR /1" has to be converted in 3,123. With your Match function, I only get 3 as a result.
best regards
Polo