hexagon logo
Register Sign in
  • Replies 5 replies
  • Subscribers 223 subscribers
  • Views 63 views
  • Users 0 members are here
Options
Related

Testing commend input for numbers

ncsteinb
Hello, I'm rather new to using logical operations in PCDMIS, so please bear with me.

I have a dialog box pop up when starting my program to ask the operator what fixture number the part came from. This can be 1 - 48. I am passing this number through a Tracefield to Excel output to WinSPC. I cannot handle this Fixture_Number variable in anything else but a strict numerical input like "23" when WinSPC is processing this data. How can I test if this input is strictly a number between 1 & 48, with no other characters? I think I'd be ok if it was just a number test, but would be nice if it also caught numbers that are more than 2 digits. Any ideas?

Snippet:


Thanks
Parents
  • Here is a quick bit of code that will do that. If the input is not between 1 and 48 an operator message will pop up. If the operator clicks 'OK' the program will jump back to the input comment and allow them to input a correct value. If the operator clicks 'CANCEL' the measuring routine stops. Either way it keeps bad data out of your database.

    C1 =COMMENT/INPUT,YES,FULL SCREEN=NO,
    FIXTURE NUMBER
    ASSIGN/FIXTURE_NUMBER=INT(C1.INPUT)
    IF/FIXTURE_NUMBER<1 OR FIXTURE_NUMBER>48

    [INDENT=2] COMMENT/OPER,NO,FULL SCREEN=NO,AUTO-CONTINUE=NO,
    PLEASE ENTER A NUMBER BETWEEN 1 AND 48
    GOTO/C1    [/INDENT]
    END_IF/
    TRACEFIELD/DISPLAY=NO,REPORT=NO,....



    The purpose of using the INT function on line 3 is to remove any letters, decimal values, or special characters. It makes it so the FIXTURE_NUMBER variable will always be a whole number. Anything that is not a number will return a zero. The odd case where it wouldn't work quite right is if someone enters an alphanumeric code starting with a number. Something like "22B1123" will return 22 (the first number before a non-numeric character is found).
Reply
  • Here is a quick bit of code that will do that. If the input is not between 1 and 48 an operator message will pop up. If the operator clicks 'OK' the program will jump back to the input comment and allow them to input a correct value. If the operator clicks 'CANCEL' the measuring routine stops. Either way it keeps bad data out of your database.

    C1 =COMMENT/INPUT,YES,FULL SCREEN=NO,
    FIXTURE NUMBER
    ASSIGN/FIXTURE_NUMBER=INT(C1.INPUT)
    IF/FIXTURE_NUMBER<1 OR FIXTURE_NUMBER>48

    [INDENT=2] COMMENT/OPER,NO,FULL SCREEN=NO,AUTO-CONTINUE=NO,
    PLEASE ENTER A NUMBER BETWEEN 1 AND 48
    GOTO/C1    [/INDENT]
    END_IF/
    TRACEFIELD/DISPLAY=NO,REPORT=NO,....



    The purpose of using the INT function on line 3 is to remove any letters, decimal values, or special characters. It makes it so the FIXTURE_NUMBER variable will always be a whole number. Anything that is not a number will return a zero. The odd case where it wouldn't work quite right is if someone enters an alphanumeric code starting with a number. Something like "22B1123" will return 22 (the first number before a non-numeric character is found).
Children
No Data
© 2024 Hexagon AB and/or its subsidiaries. Privacy Policy | Cloud Services Agreement