compare strings numbers

[krispiekream]

hi,

can someone show me how to compare strings like this?

if TEXT/STRING is

TestSystem100000-001

TestSystem100000-002

TestSystem100000-003

TestSystem200000-001

TestSystem200000-002

TestSystem200000-003

If its TestSystem100000-001 then its Model1 OLD

If its TestSystem100000-002 or 100000-003 or 100000-004 or 100000-005, etc = Model 1 NEW

if its TestSystem200000-001 =Model 2 Old

If its TestSystem200000-002 or 200000-003 or 200000-004 or 200000-005, etc = Model 2 NEW

Its easy for me to compare between two intergers or numbers,

I just don't have any clue on comparing strings that are like numbers.

can someone please help.

thank you in advance.

[Andy_C. · Accepted solution]

Hey Krispiekream,

Would this work??