How to split First Name and Last Name in saved search

I have a custom name field on a custom record that contains the person first and last name. I am wanting to split this into two separate columns (or more importantly just extract the first name) – any ideas on what formula I could use to do this?

Beginner Asked on August 9, 2021 in Saved Searches.
Add Comment
2 Answer(s)

 

Hi Margie,

 

Try out the below Formula; I am assuming that the custom field name as FullName.

Formula:

Full_name à “John Lucky”

Take First Name: SUBSTR({full_name}, 1, INSTR({full_name} , ‘ ‘ , 1 , 1))   à John

Task Second Name: SUBSTR({full_name}, INSTR({full_name} , ‘ ‘ , 1 , 1)+1 )      à Lucky

 

I hope it will help and clear the issue, For More NetSuite Support Services 

Rookie Answered on August 10, 2021.

Thankyou however this is not working for me, it is just saying ERROR: Invalid Expression

on August 10, 2021.

Ok have got this to work with slight amend to you formula

First Name: SUBSTR({full_name}, 1, INSTR({full_name},’ ‘)-1)

Last Name: SUBSTR({full_name},INSTR({full_name},’ ‘)+1)

 

Thanks for point me in the right direction

on August 10, 2021.
Add Comment

Hi @mohankaladi,

 

What about a similar situation where it contains more than just First and Last name?  For eg:

SUBSTR(‘First-Second-Third-Forth’, INSTR(‘First-Second-Third-Forth’, ‘-‘) +1)

 

Segment#1 = “First”

Segment#2 = “Second-Third-Forth”

Using the formula given by you, I only manage to get 2 segments, now I need to split them into 4 different segment/fields like below:

Segment#1 = “First”

Segment#2 = “Second”

Segment#3 = “Third”

Segment#4 = “Forth”

 

Rookie Answered on April 15, 2023.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor