Scraping Euro amount to airtable truncates the digits after the dot

[LastSamuraj]

Hello Community,

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

DIV.list-item:first-of-type > DIV.data-wrapper:first-of-type > DIV.align-center.pricing:last-of-type > SPAN.price_buy:first-of-type > SPAN.price:first-of-type

BODY#evdb HEADER#header + MAIN DIV.jplist.content DIV.list DIV.list-item DIV.data-wrapper DIV.pricing.align-center SPAN.price_buy SPAN.price

*#evdb > * > *.content.jplist > *.list > *.list-item > *.data-wrapper > *.align-center.pricing > *.price_buy > *.price

BODY#evdb > MAIN > DIV.jplist > DIV.list > DIV.list-item > DIV.data-wrapper > DIV.pricing > SPAN.price_buy > SPAN.price

DIV:first-of-type > DIV:first-of-type > DIV:last-of-type > SPAN:first-of-type > SPAN:first-of-type

Many thank in advance!

[Jess]

Hi @LastSamuraj, Welcome to the Bardeen Community

Good news, you don’t need to update the selectors for this use case to separate the € sign from the amount.

Try this:

1. “Split String” action to separate the Euro Sign from the price amount:
   
   
2. “Get rows of a table” to insert into a table for the Conditional statement next to read.
3. “Conditional Statement” to only pull the rows where the Price column is not empty.
4. Get rows of a table for only the rows that actually have the Price amount you’d like to input into Airtable.

Here’s the built playbook for your reference:

{{playbook_title}}

I hope this helps!
Thank you,
Jess

[LastSamuraj]

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.

I tried the following regex commands:

[.€]
[.]|€
.\s?€

[Jess]

Hi @LastSamuraj

I forgot that Regex would work too. Let’s use just Regex for this use case as it’ll be less actions, making it simpler.

I need to actually open the builder to troubleshoot further - could you please share your automation?

How to Share an Auto/Playbook

When asking questions or reporting a bug, it’s best to share your Auto/Playbook. The more details you give, the better we’ll be able to assist you. Thank you! Here’s how you can share it: [Bardeen - Share Playbook] Please Note if you’ve made a change/update to your auto/playbook since you’ve shared it, in order to share the most updated version of your auto/playbook you’ll need to generate a new link by following the below steps: Unshare the book Share it again [image]

[LastSamuraj]

ok

here is the version with regex: Shared Playbook Template

[Jess]

Thank you - Here’s the updated playbook with the things you were missing:

{{playbook_title}}

A few things you were missing:

• Your regex is working as expected

1. We needed to add another action after the Regular Expression actions to put all the information into a table. Use “Get table sorted by”

2. Because of this added step, we also needed to update your mapping in the “Add data to Airtable” action:
   

   

• These mappings need to come from the “Get table sorted by” previous action.
• Please double check these on your end as it was a lot and I might’ve missed some.

I hope this helps!
Thank you,
Jess

[LastSamuraj]

thank you for your effort!

Two things I have now: the problem with the numbers. I get still only the two digits 99 and not the whole number (price) 99841 in Airtable.

And the other thing is, that my scraping flow creates now two rows with the same data in my airtable.

[Jess]

I’m thinking we might’ve uncovered a couple of bugs here, but tagging @vin_bardeen, @ivan to take a second look as I’m not super familiar with Airtable. Thank you!

---

FWIW - I’m encountering the same behavior on my end of testing that @LastSamuraj mentions:

@LastSamuraj

I get still only the two digits 99 and not the whole number (price) 99841 in Airtable.

@LastSamuraj

my scraping flow creates now two rows with the same data in my airtable.

[LastSamuraj]

Hello @vin_bardeen,

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.

What is the best way to solve this problem?