I am trying to pull out a piece of a string to no avail.
string = 90-8566-Doe-20140317_122627T-2_Update.pdf
I want to pull out the "Doe portion"
I have been using a Mid function with a Len function component and it just isn't coming out right.
I am trying to pull out a piece of a string to no avail.
string = 90-8566-Doe-20140317_122627T-2_Update.pdf
I want to pull out the "Doe portion"
I have been using a Mid function with a Len function component and it just isn't coming out right.
Assuming first 8 characters are always the same:
Or in VBA: