Dear community members,
I hope that you'll help me with what I'm trying to accomplish.
There is string in my worksheet cells which is comprised of English letters,numbers and greek (mostly the Phi) letters and most of these strings in cells are in same format. I want to parse out that string to special characters so I can find what is before,after and between these special characters.
For exmaple
The search string e.g. name = "15(Phi)12/15 L=315" ' Need to find the position of (Phi) and "slash" so I can retrieve the "12"
To find that I'm using the folowing code
While debugging I get "pos" assigned to 2 and "pos_slash" to 6 and phi variable assigned to "5F12/1", position of pos_slash is correct in that case but "pos =2" is not. I think that the problem with this string is mixed with unicode and ANSI characters, but still don't know how to figure it out?Please Login or Register to view this content.
Help in advance will be appreciated.
Regards,
Bookmarks