RE: 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?
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
Thankyou however this is not working for me, it is just saying ERROR: Invalid Expression
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
