Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am pulling from an excel file and for the Identity column I only need the name out of the data for each record
Example:
Server/Accounts/Users/John Doe\1645587952551528449 |
All I need is the John Doe. All entries are the same except the name and quid at the end are different for each user.
subfield(subfield(MyFieldHere,'/',4),'\',1)
subfield(subfield(MyFieldHere,'/',4),'\',1)
Hi,
If name position is fixed then use =mid(ColA, 23, len(ColA) - 42)
Thanks & Regards