I'm trying to remove all characters that happen after initial whitespace. Should be a pretty simple split, but I can't figure it out. Example below:
PM AWI -> PM
123 GAM -> 123
1nas89 aee aer -> 1nas89
Thanks!
Matt
Solved! Go to Solution.
You could use the formula tool to grab the string up to where the space occurs.
Left([InputField], FindString([InputField],' '))
You can also try regex.
REGEX_Replace([Field1], "(.+?)\s.*", "$1")
or REGEX_Replace([Field1], "(\S+)\s.*", "$1")
Cheers,
All of these methods actually work, so thanks! I prefer the LEFT formula tool or REGEX over the Text to Columns tool due to the creation of an additional column.