Hi,

There is a field called "Name", type of this field is alphanumeric and it should contain the values between 'a' to 'z' and 'A' to 'Z'. If suppose accidentally some one has inserted other than these values then this value should be printed in the output file.

how could this be done in webfocus?

This message has been edited. Last edited by: Vinay Kumar,

This may help.

http://forums.informationbuild...621050203#8621050203

You will have to hold the column NAME, then use this technique.

If you need to keep track of some sort of key, then that will be more complicated.

CHKFMT function

Suppose your name is 25 characters

CHK_ID/I3 = CHKFMT(25, name, 'AAAAAAAAAAAAAAAAAAAAAAAAA', CHK_ID);

CHK_ID value of 0 means true 1 means false

JG,

if its a numeric field then

CHK_ID/I3 = CHKFMT(5, name, '99999', CHK_ID);

i just gave a try please let me know the correct one

what if we have to check for alphabets and spaces?

If you want to check for a space you need to convert them to a value of a - z or A -Z first.

 
DEFINE FILE CAR
CHK_ID/I3 = CHKFMT(16, CTRAN(16, CAR, 32, 65, 'A16'), 'AAAAAAAAAAAAAAAA', 'I3');
END
TABLE FILE CAR
PRINT CAR
      CHK_ID 
BY COUNTRY
BY CAR
BY MODEL
END 

You might find this Forum post helpful: extracting numbers from alphanumeric field

Dan, It's not about extracting, it's about validating.

quote:

other than these values then this value should be printed in the output file

Its also about extracting.