Magic ETL

Magic ETL

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

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In

Best Answers

  • Domo Employee
    Answer ✓

    Here you go:

     

    First Name:

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

    Last Name:

    1. 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.

  • Member
    Answer ✓

    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

Answers

  • Domo Employee
    Answer ✓

    Here you go:

     

    First Name:

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

    Last Name:

    1. 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.

  • Member
    Answer ✓

    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

  • that worked, thank you

  • yes , it worked

  • 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!

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In