Wildcards in Text files

[Kathy DuBach]

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 [email protected]

[Cakkie]

Just use the instr function

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




Tom Cannaerts
[email protected]

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]

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 [email protected]