How extract a substring?
Posted on 2001-07-03
Basics: VB6 sp5 on NT4.0
Question: How can I extract a sub string from between two particular ASCII characters (value marks)?
The input is a long string that has many sub strings in it. Each sub string is separated by a 'value mark'. For example, I might want to extract the 2nd sub string (that sub string between the 1st value mark and the 2nd value mark. There is no leading value mark.) Or I might want to pull the 23rd sub string (that sub string between the 22nd value mark and the 23rd value mark.)
As there will be over 100,000 long strings (records) that I will have to process, I want something that is quick as opposed to counting where each value mark is in the long string and then using the MID function based on the count. I will need to extract about 24 sub strings from each long string. Also, each sub string can vary in length.
Thanks for the help.