Hi Community,
I am trying to parse a column with many words in the following way:
Separate the first 2 words from the rest of of the content
<Input>
<Desired output>
Any advice on how to do do it?
Thank you!
Solved! Go to Solution.
This would be easier with:
formula tool - new field - first two words:
GetWord([field],1)+" "+GetWord(field,2)
formula tool - new field - "remainder"
replace([field1],[first two words]+" ","")
Hi, @selsset97
If your string include more repeat words, maybe you can use the below formula:
1- First 2 words:
REGEX_Replace([Plants], "^([[:alpha:]]+\s[[:alpha:]]+).+$", "$1")
2- Other last words:
Trim(REGEX_Replace([Plants], "^" + [First], ""))