cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
guyinazo
Level 8

Use Mid() or Split() to get First Name

I thought I would be able to reference the resulting table from a Split, but perhaps not.  I have a data field that comes in as FullName and is presented in a drop down.  These names are in the format of Last, First, Title.  I am using Left()-1 to successfully get the last name and store it in a variable, but what would the simplist way be to get the First name?

 

Thanks for the information

 

Brad

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft Employee

Re: Use Mid() or Split() to get First Name

Hello @guyinazo,

Does this help?Capture.PNG

 

 

 

2 REPLIES 2
Microsoft Employee

Re: Use Mid() or Split() to get First Name

Hello @guyinazo,

Does this help?Capture.PNG

 

 

 

guyinazo
Level 8

Re: Use Mid() or Split() to get First Name

Thanks!  This did work just fine as I needed