I am using Visual Fox Pro 6.0. I have a form where have 4 text fields.
1) IML No.
2) New Part No.
3) Original Part No.
4) Employee ID
(note: new part no.=original part no.)
IML No.:15600001000 (scan barcode)
New Part No.:fpt15600001000a3841750030 (scan barcode)
Original Part No.:fpt15600001000a3841750030 (scan barcode)
So, the system will compare the iml no.,new part no. and original part no. When the employee scan their employee id, pop up message either "Pass"(if iml no.=new part no.=original part no.) or "Fail'.
The problem is the iml no. can't compare with the new part no. and original part no. The message always show "Fail". So what I want is when it compare the iml no., the first 3 digits and last 11 digits from the new part no. and original part no. are ignore.
If there are solution to help me to solve this problem. Please help me.
Returns a Variant (String) containing a specified number of characters from a string.
Mid(string, start[, length])
The Mid function syntax has thesenamed arguments:
string Required.String expression from which characters are returned. If string containsNull, Null is returned.
start Required;Long. Character position in string at which the part to be taken begins. If start is greater than the number of characters in string, Mid returns a zero-length string ("").
length Optional; Variant (Long). Number of characters to return. If omitted or if there are fewer than length characters in the text (including the character at start), all characters from the start position to the end of the string are returned.
To determine the number of characters in string, use the Len function.
Note Use the MidB function with byte data contained in a string, as in double-byte character set languages. Instead of specifying the number of characters, thearguments specify numbers of bytes. For sample code that uses MidB, see the second example in the example topic.