Regular expressions in field input masks

What regex format did you try? Some formats start with different indicators (I think).

Something very simple like [\w\\-]*.  I understand there are different versions supported by different tools and languages, but this is pretty basic.  I can’t find any guidelines, or examples used in the framework either.  That’s why I’m asking for a working example - any example.

I can’t find any either, but it seems like the expression would need to start with ^. Did you try that?

Reading through that article again, I’m not sure the Regular Expressions section has any logical connection to the Input Mask section, except that they are both forms of input validation.

Hi ​@Tony Lanzer were you able to find a solution? Thank you!

Acumatica does not go out of its way to document the regular expression engine. Acumatica is built on a .NET framework so looking at .NET regular expression standards appears to be a naturally good starting point, https://learn.microsoft.com/en-us/dotnet/standard/base-types/regular-expressions. 

Hi ​@Tony Lanzer 

The two articles you linked are documenting separate features that just sit near each other. The Input Mask reference is placeholder-character based only (0/9/# digit, L/? letter, A/a letter-or-digit, C/& any char, > / < case) - there’s no regex engine behind InputMask, so [\w\-]* is taken literally and echoes back into the field. The “Examples of Masks and Regular Expressions” page lists masks and regex together, but as two independent validation tools, not regex-as-a-mask.

For regex validation, use it where that page actually applies it: the Reg. Exp. field on an Attribute / input validation setup - and those are JS-style, slash-delimited (e.g. /^\d{5}([-]\d\d)?$/;), not .NET. If you’d rather keep it in code, do it in FieldVerifying and throw a PXSetPropertyException on no match - that path is standard C# .NET regex.