Hello,
I have a dataset where some names have a random letter in front of them and others do not. For example:
A Michael Scott
L Dwight Schrute
Pam Beasley
S Jim Halpert
How do I remove only the leading single letters from Michael, Dwight and Jim without removing the first letter in Pam's name.
Thank you!
Solved! Go to Solution.
And I loved te reference!!!
Dwight loves regex (i think)
Hi @tycarbone
Character name from The Office one of my favorite show.
You can trim the start by using this formula
IF FindString([Field1], " ")=1 THEN
Right([Field1], Length([Field1])-2)
ELSE [Field1] ENDIF
It checks whether the 2nd char is space if yes then remove first 2 chars.
Workflow:
Hope this helps 🙂
@dougperez wrote:And I loved te reference!!!
Dwight loves regex (i think)
Or we can trick him into using RegEx 😜😜😂😂
This worked like a charm! I agree, Dwight would love Regex!