Scraping Euro amount to airtable truncates the digits after the dot

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


bardeen-airtable2
bardeen-airtable1

Many thank in advance!

Hi @LastSamuraj, Welcome to the Bardeen Community :slight_smile:

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:

I hope this helps!
Thank you,
Jess

1 Like

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?ā‚¬


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?

ok

here is the version with regex: Shared Playbook Template

1 Like

Thank you - Hereā€™s the updated playbook with the things you were missing:

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

1 Like

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.

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:

1 Like

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?

@vin_bardeen, Could you please confirm this has been escalated to the engineers?

I think itā€™s the same issue here possibly - Cannot Scrape Numbers to use for an Airtable number-formatted column + "get function of" errors

Hey Jess, no I didnā€˜t get an respons to my problem.

I see that, thatā€™s why Iā€™ve followed up with Vin again above :+1:

Hi @LastSamuraj and @Jess ,

Thanks for following up on this and for your patience while we resolved this issue. Weā€™ve just released a new version of Bardeen (2.39.0) which is meant to have fixed this issue. Do you mind updating to the latest version and seeing if it persists for you please ?

Hello @vin_bardeen , after bardeen update to 2.39.0 the transfer of fields that are not unique no longer works. This means that all fields that worked yesterday (e.g. 300 HP, 500 km, 180 km/h etc.) are no longer transferred. And the price is not transferred either.

I get the following success message after running my workflow.

Here is an example of the fields I am copying:

Previously, Bardeen always said: ā€œYou are trying to use a different kind of data than the current argument expects. Bardeen will convert it, but the result may be unexpected.ā€

Apparently it doesnā€™t work anymore since the update

Thanks for the update @LastSamuraj

Tagging @bagrat to see if he has any ideas.

Hallo @vin_bardeen I have just seen in this post that my current problem, which I have been despairing about for days, is already six months old. Have you been able to find a solution to the problem? I still have the problem that many fields cannot be assigned " due to schema mismatch.

Regards