Hi All,
I have a VBA string variable (working_data) that contains a mixture of characters and numbers logically split into different "fields" by a "@" character.
My question is, is there a way for VBA to do the hard work of finding the character position of the last "@" in working_data rather than me having to loop backwards until I find "@"
Apologies if this is a simple feature that is beyond my current knowledge level
Jmac
Use the InStrRev function to find the position of the last occurrence. It searches from right to left, but the position it returns is still numbered from the left.
LastAtPos = InStrRev(working_data, "@")
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
exactly what I needed, many thanks
Jmac
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks