Error message setup

I need to test the inputted data for the following conditions, and then display an error message with the record # of the error. The first column called Ref1 is numeric data formatted as text due to necessary leading zeroes.

error if data in Ref1 column is not numeric characters

error if data in Ref1 column is 00000

error if the 7th character in a field is anything other than a dash

error if the length of a column is other than 11 characters

I have used the Message command previously to display errors for positive tests (e.g. x=0, name = 'George', etc.) But the exclamation-point errors out instead of negating the positive statement.when I use it in the error message tool.

What am I missing here?

Workflow

Accepted answers

binu_acs

@ppatane One way of doing this

Error_message_101023.yxwz

All comments

binu_acs

@ppatane The first condition and the third condition contradict each other. The first error says error out if it is non-numeric and the third says check for the 7th char which is not '-', then error out.

ppatane

@binu_acs My apologies for my poor communication
The first 2 rows refer to one field, the last 2 rows refer to other fields

binu_acs

@ppatane One way of doing this

Error_message_101023.yxwz

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703