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

Splitting a field from the right

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

Hello,

I have a field that doesn’t present very clear data that I need to SPLIT.
It’s a field that shows a form conversion by aggregating Page Name: Form Name.
Ideally I would just be able to split on the “:” - however in my case sometimes the page names also contains “:”, so I have two. I’ve been looking at RIGHT formulas but they’re not doing what I want them to

When I use: LEFT(Name,FIND(": ",Name))
I indeed get the text split on the first “:” found starting from the left

However when I use RIGHT(Name,FIND(": ",Name))
the result comes out super weird, I can’t actually identify the logic of what it’s doing…

Thanks!

1 Reply 1

RegEx to the rescue. It’s an ugly but very powerful science.