Click to See Complete Forum and Search --> : Wildcards in Text files


Kathy DuBach
April 26th, 2001, 04:43 AM
Hello again,

Have another question. Does anyone know how to identify a normally wildcard character as "*" as part of a text line?

For Example:
Mid(strInput, 4, 5) <> "*" And ......

When I really mean "*" and not just any character.


Kathy DuBach at dubachk@hotmail.com

Cakkie
April 26th, 2001, 06:14 AM
Just use the instr function

if instr(mystring,"*") > 0 then
' the * is in the string
else
' no * in the string
end if




Tom Cannaerts
slisse@planetinternet.be

Programming today is a race between software engineers striving to build bigger and better idot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning -- Rich Cook

Kathy DuBach
May 1st, 2001, 04:22 AM
It worked! Thanks.
If Mid(strInput, 1, 1) <> Chr(12) And _
Mid(strInput, 1, 1) <> "" And _
InStr(strInput, "*") = 0 And _
Mid(strInput, 1, 6) <> "REPORT" And _

I also found out by trial and error I could use
Mid(strInput, 1, 1) <> ["*"] And _



Kathy DuBach at dubachk@hotmail.com