Character test 1

[lashwarj]

How would I go about running a character test.

Ex. The user enters in a number in an item field, all items have a code and the code is associated by the item number (ex. sport items have a 5 digit number, clothing has a 6)

How can I run a character test that will do something like below.

IF This.value = ****
Thisform.Department = "Sport"
ENDIF

The code I can do I just dont know how to run the character test in foxpro. Thank you guys

 

[monkey666]

afternoon

not sure if i get you correctly but ..

nMylength=len(alltrim(thisform.textbox1.value))

will give you the number of characters in a string.

monkey

 

[monkey666]

sorry forgot to add the bit about after that.

do case

case nMylength=5
Thisform.Department = "Sport"

case nMylength=8
Thisform.Department = "haberdashery"

endcase

etc

monkey

 

[lashwarj]

I tried the LENC since the item number sometimes has alpha numeric contents, it returns the same number no matter what.

 

[lashwarj]

Ahhhhhhhhhhh the alltrim was what I didnt have. It works perfectly, thank you.

 

[monkey666]

wow a star

thanks a lot

but i'm not sure alltrim() deserves a star

thanks though

monkey