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?

Rookie Asked on August 9, 2021 in Saved Searches.
Add Comment
1 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

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   Limebox   Become a Sponsor