I am trying to transfer a euro amount e.g. 99.800€ into a number field in Airtable.
The good news is that Bardeen only transfers the numbers, although the € sign is marked. The bad news is that Bardeen only transfers the numbers before the dot. However, the dot is only a thousands separator.
So the question is: How do I get the complete price of 99800 into a number field after Airtaible?
Maybe I need to prepaire the marked selectors? But I do not really understand how
Many thanks for your help at this late stage. I have copied your suggestion in my environment. Unfortunately, it did not help. Only the number 99 of the amount is saved in my Airtable cell. I am attaching two screenshots here. Maybe you can see if I have made a mistake?
In the meantime I have learnt to work with regex formulas and to use them. I thought maybe I would try to remove the dot and the Euro character using the regex command. But that didn’t work either.
could you please take a look on my problem?
I’m still not able to scrape a simple euro amount into an airtable digit field. As I already told above, every time I scrape e.g. this amount 90.900 €, I only get the 90 as digit in my airtable field.
I think maybe the problem is the dot inside the amount. For this reason, I tried to remove the dot using a regex. But no matter which RegEx formula I tried, it didn’t work. Each time only the number 90 was transferred to Airtable.