Getting values from a string...

[desquite]

I'm getting some data returned to me that looks like this:

F:c:\myfile.ext M:300 T:654654065 120 TEST Y:EXT


Each uppercase letter combined with a ':' represents a different field. Is there an easy way to extract these field values and put them in a format like this:

Filename: c:\myfile.ext
Number: 300
Value: 654654065 120 TEST
etc...


There must be an easy way to get those values but I don't know how. Thanks for your help!

[Mark Sreeves]

here's one method:


mystring = "F:c:\myfile.ext M:300 T:654654065 120 TEST Y:EXT"
Filename = Trim(Mid(mystring, 2, InStr(mystring, "M:") - 2))
mystring = Mid(mystring, Len(Filename))

Number = Trim(Mid(mystring, 2, InStr(mystring, "T:") - 2))
mystring = Mid(mystring, Len(Number))
Value: = Trim (Mid(mystring, 2, InStr(mystring, "Y:") - 2))

etc....
this may need tweeking a bit


------------------
Mark Sreeves
Analyst Programmer

Mark.Sreeves@Softlab.co.uk
A BMW Group Company