4 answers
If you create a SQL database with your strings, you will perform queries on it and SQL will give you the results without fail.
Otherwise, you filter your string to extract the first character and you test its type (or its value) if the value of the first 8 or 4 (depending on the program) is counted between 0 and 9, it's a digit which is also their ASCII code I believe, so there is no possible confusion.
Otherwise, you filter your string to extract the first character and you test its type (or its value) if the value of the first 8 or 4 (depending on the program) is counted between 0 and 9, it's a digit which is also their ASCII code I believe, so there is no possible confusion.
Go here
http://www.vbasic.org and you can find a code that unlocks you
A hand ties a package and two several.
Where do you ask Mboo if you dance?
http://www.vbasic.org and you can find a code that unlocks you
A hand ties a package and two several.
Where do you ask Mboo if you dance?
An user enters a word that can contain but not start with a digit.
I have to do:
variable = left(variable,1) ' to isolate the first character
If Val(variable) ... and a test to know if it's a number (still to be defined how, but I will figure it out).
Ok, but I have a vague memory of
If left(variable,1) is numeric ...
of course, that doesn't work. I asked the question hoping for a response like this.
Thank you for your contribution.
Eric