Splitting a field from the right

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!

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

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.