way to split column name into first and last

Reply
Highlighted
Yellow Belt

way to split column name into first and last

Hello,

 

Is there a way to split a field if I have into 2? I have a field name, for example Bob Smith, can I split this into 2 so having 'Bob' and 'Smith' for first name and last name


Accepted Solutions
Black Belt

Re: way to split column name into first and last

Here you go:

 

First Name:

LEFT(`name`, (INSTR(`name`, ' ')-1))

Last Name:

RIGHT(`name`, LENGTH(`name`)-INSTR(`name`, ' '))

Hope that helps,
Valiant

 

**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.

Yellow Belt

Re: way to split column name into first and last

Hi,

 

In Magic ETL, in the Edit Columns group of actions, you'll find 'Split Column' you can use this action to take a full name, and split it into a first and last name.  (See image)

 

Hope that helps!

 

Name Split.jpg

Tags (1)

All Replies
Black Belt

Re: way to split column name into first and last

Here you go:

 

First Name:

LEFT(`name`, (INSTR(`name`, ' ')-1))

Last Name:

RIGHT(`name`, LENGTH(`name`)-INSTR(`name`, ' '))

Hope that helps,
Valiant

 

**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.

Yellow Belt

Re: way to split column name into first and last

Hi,

 

In Magic ETL, in the Edit Columns group of actions, you'll find 'Split Column' you can use this action to take a full name, and split it into a first and last name.  (See image)

 

Hope that helps!

 

Name Split.jpg

Tags (1)
Yellow Belt

Re: way to split column name into first and last

that worked, thank you

Visitor

Re: way to split column name into first and last

yes , it worked

Visitor

Re: way to split column name into first and last

Hi Nick, I'm trying to split my column similarly however the data in the original column is formatted as, "Stretch Wrap & Strapping - Copy". I want to split this column such that the "Stretch Wrap & Strapping" is in one column and the other column reads, "Copy". I tried making my custom deliminator, " - " however the split column isnt working... any ideas on how to trouble shoot? Thanks!

Announcements
Looking for the latest Community solutions? Please visit our accepted solutions board here!