Validation to remove a Comma

[MikeRoberts]

Just thought I would share a discovery which took a while for me to sort out. (About time I repaid the favour to you all)

If you want to VALIDATE a field by an exclusion i.e. "must not contain a comma"

here is how it's done.

"In the calculation Validation section - Use this function"

If (Filter (fieldname; ",") ≠ ""; 0; 1)

Happys days

Bye for now.

Mike Roberts

www.getonit.co.uk

[MikeRoberts]

The HTLM has converted some of the code

the part which says &#8800

should be a =/ a not equal sign in filemaker (hope this makes sense)

[BobWeaver]

What if the field contains two commas?

[-Queue-]

I am not sure what it is not supposed to equal, but I would use

IsEmpty(Filter( fieldname; "," ))

This will return 1 when the field does not contain a comma and 0 if it does.