Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

MID() Formula Not Displaying Anything

Topic Labels: Formulas
974 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi there,

I am trying to extract a string from a field using the MID() Formula. It should be pretty straightforward, but the output is blank for every single record. I have tested this by using several differently formatted fields (i.e. Text, Single-Choice, Multi-Choice), and have not been able to output a result in any of my tests.

For example, I want to remove the emoji at the beginning of the string “ :hammer_and_wrench: Service” in the field {Department}. My formula is:

MID({Department},2,0)

The result is always blank. Is this something I’m doing wrong, or an actual bug?

1 Reply 1

Hi

It returns nothing because you have specified a 0 as the length of the value returned. Try this:

RIGHT(Original,LEN(Original)-1)

This will remove the first character from the string.

Hope this helps.