Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 18, 2023 01:30 PM - edited Jun 18, 2023 02:18 PM
Hello you!
I'm looking to remove 2 characters of fields, from the right of the cell. I have a list of prices, like that, no currency :
15701
9740
1549
I'm looking to get this :
157 Є
97 Є
15 Є
The deleted numbers are the cents 🙂
Cheers!
Solved! Go to Solution.
Jun 18, 2023 04:25 PM
Hi @Julien_Etoke,
Please give this a try:
LEFT({your_field}, LEN({your_field}) - 2)
https://support.airtable.com/docs/extracting-text-from-a-field
-Stephen
Jun 18, 2023 04:25 PM
Hi @Julien_Etoke,
Please give this a try:
LEFT({your_field}, LEN({your_field}) - 2)
https://support.airtable.com/docs/extracting-text-from-a-field
-Stephen
Jun 18, 2023 04:31 PM - edited Jun 18, 2023 05:00 PM
Hello, Julien
There are two ways to do this.
Either as a String or Numeric.
In case of a number (choose the correct amount)
FLOOR({Cent Euro}/100,1)
ROUND({Cent Euro}/100,1)
ROUNDUP({Cent Euro}/100,1)
ROUNDDOWN({Cent Euro}/100,1)
In case of a string
VALUE(LEFT(CONCATENATE({Cent Euro}),LEN(CONCATENATE({Cent Euro}))-2))
Jun 19, 2023 12:01 AM
Hello! It works, thanks a lot 🙂
Jun 19, 2023 12:01 AM
Hello Sho!
Thank you for this very complete answer 🙂