cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate V
Advocate V

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
Highlighted
Microsoft
Microsoft

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

Hello @guyinazo,

Does this help?Capture.PNG

 

 

 

View solution in original post

2 REPLIES 2
Highlighted
Microsoft
Microsoft

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

Hello @guyinazo,

Does this help?Capture.PNG

 

 

 

View solution in original post

Highlighted
Advocate V
Advocate V

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

Thanks!  This did work just fine as I needed

Helpful resources

Announcements
Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (4,283)