Split Full name into First Middle and Last
Best Answer
-
You can use the SPLIT_PART function primarily to split these all out:
First Name
SPLIT_PART(TRIM(SPLIT_PART(`Name`,',',2)),' ',1)
Last Name
SPLIT_PART(`Name`,',',1)
Middle Name
SPLIT_PART(TRIM(SPLIT_PART(`Name`,',',2)),' ',2)
Based on your examples, this will do the trick.
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Answers
-
Hi @jbandley
@MarkSnodgrass offer's a good solution. I was going to suggest another option utilizing SUBSTRING, INSTR and LENGTH but his is a simpler option.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 39 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 260 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 105 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K ζ₯ζ¬ζ―ι¨
- 4 ιε ΄-ζ₯ζ¬ζ―ι¨γΈγγγγ
- 26 γη₯γγ
- 64 Kowaza
- 299 δ»²ιγ«ηΈθ«
- 653 γ²γγγε ±ζ