Forum Discussion

wnicholl's avatar
wnicholl
Icon for Resolver II rankResolver II
7 years ago
Solved

Split Different Names with Special Characters

I have mutiple name listings that I'd like to only identify First and Last name.  The table is attached.    Split Names FIRSTNAME LASTNAME FIRSTNAME LASTNAME 18 FIRSTNAME MIDDLENAME LAS...
  • wnicholl's avatar
    wnicholl
    7 years ago

    I was able to come up with this workable solution. 

     

    Staff 2 = LOOKUPVALUE('Table1'[Staff],'Table1'[ACTEXC],'Lawyers (Curr MTD Data) AWKQRP'[ACTEXC])
wnicholl's avatar
wnicholl
Icon for Resolver II rankResolver II
7 years ago

I was able to come up with this workable solution. 

 

Staff 2 = LOOKUPVALUE('Table1'[Staff],'Table1'[ACTEXC],'Lawyers (Curr MTD Data) AWKQRP'[ACTEXC])