Changing the order of a name - from surname, first name to first name, surname - can it be done?
Hi,
I've got a dataset that has the first name and surname comma separated but with surname first ie:
Lewis, Danny
Whereas I ideally want
Danny Lewis
Is this possible in Beast Mode? If not how would I transform at ETL level?
Many thanks in advance!
D
0
Comments
-
Hi @DannyLewis
If the format is the same with LAST NAME, FIRST NAME then yes, you can utilize a beast mode to reorganize your names.
Here's some examples using TRIM (trim / remove spaces from the start and beginning of a string), INSTR (find the location of a string inside another string) and SUBSTR (take a part of a string) functions.
First Name
TRIM(SUBSTRING(`Name`, INSTR(`Name`, ',') + 1, LENGTH(`Name`) - INSTR(`Name`, ','))) -- + 1 to ignore comma
Last Name
TRIM(SUBSTRING(`Name`, 1, INSTR(`Name`, ',') - 1)) -- -1 to ignore the comma
Combining them both together using CONCAT
CONCAT( TRIM(SUBSTRING(`Name`, INSTR(`Name`, ',') + 1, LENGTH(`Name`) - INSTR(`Name`, ','))) -- + 1 to ignore comma , ' ' , TRIM(SUBSTRING(`Name`, 1, INSTR(`Name`, ',') - 1)) -- -1 to ignore the comma )
**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 ひらめき共有