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
Remove from position
+5Best answer by Stephen_Orr1
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
+18Hi @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
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))
+5Hi @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
Hello! It works, thanks a lot 🙂
+5Hello, 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))
Hello Sho!
Thank you for this very complete answer 🙂
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.