EDUCATED MONKEY
Board Regular
- Joined
- Jul 17, 2011
- Messages
- 218
I have a workbook with a number of strings, in these strings are numbers, also of unknown value, and not always in the same place so no ease way to get at them as far as I can see spent most of the morning trying to using lots of different way but to no avail, the numbers being markers for genres so once I have the location and value I could retrieve the required data <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
<o> </o>
My original idea using VBA, I would scan the string using the mid function and test the string letter by letter till I got a match with the numbers 0 through 9 then I would know where it was and its value.<o></o>
<o> </o>
The aim then would be to change it for the @ symbol so next time the string is check by another process I could simply look for the @ symbol and do a mid to retrieve the data there after <o></o>
<o> </o>
So if you can help I would be most grateful<o></o>
<o> </o>
fficeffice" /><o></o><o
> </o>My original idea using VBA, I would scan the string using the mid function and test the string letter by letter till I got a match with the numbers 0 through 9 then I would know where it was and its value.<o
></o><o
> </o>The aim then would be to change it for the @ symbol so next time the string is check by another process I could simply look for the @ symbol and do a mid to retrieve the data there after <o
></o><o
> </o>So if you can help I would be most grateful<o
></o><o
> </o>
