Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How do I access specific character locations within strings? I know in C++
you can access them using brackets (i.e. string[1]), but I can't figure it out for VB. To illustrate, for the example string "...Clamp 0.2", I am trying to find the position of the last period in a series of periods. I tried using "InStrRev," but that gave me a false positive by reporting the period in "0.2". The series of periods designates a level within a tree structure, so its position is very important. Is there any way I can use "InStr" or "StrComp" or something with this. I need it to be very fast as there are 35,000 lines to process. Thanks, Pflugs |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Search group of cells for several sets of character strings | Excel Discussion (Misc queries) | |||
Date Formating and building character strings | Excel Discussion (Misc queries) | |||
testing for character strings within a cell | Excel Worksheet Functions | |||
Finding 13 character codes in text strings | Excel Worksheet Functions | |||
VB 255 character limit for strings | Excel Programming |