String Issue

[Lobmeister]

I have a collection of string values which contain any or all of the values "1st", "2nd".....up to "8th" OR "n/a"

What i need to do is first discard those with value "n/a" then order the remaining strings, "1st" to "x th"

..any help gratefully appreciated

Elliot

 

[PCLewis]

What code have you managed to put together so far?

 

[Lobmeister]

..none of any use - im new to this !! - i looked at collections - but can't find a way of ordering the strings

 

[Dryseals]

I'm not sure what you are trying to accomplish, but maybe I can help.

Looking for a string within a string can be accomplished fairly easy with a For/Next

get the string Txt

do a length

LN = len(Txt)

For I = 1 to LN
"" look for the text here"""
Next I

then you can look for the string by doing a comparison.

Look at the Mid and InStr functions

Hope that helps to get you started.