Skip to main content
Solved

Alpha Numeric Masking


nathantrauscht
Semi-Pro II
Forum|alt.badge.img

Does anyone know if you use alpha numeric masking?

I am trying to add a text attribute masking to restrict the number of character, but it needs to allow alpha numeric entry.

 

Is there a guide somewhere that explains how the masking expressions work?

Best answer by nathantrauscht

I found the guide: https://help-2022r2.acumatica.com/(W(2))/Help?ScreenId=ShowWiki&pageid=9bec9bb3-3363-4649-948f-7a55e9c048a1

 

View original
Did this topic help you find an answer to your question?

4 replies

nathantrauscht
Semi-Pro II
Forum|alt.badge.img
  • Author
  • Semi-Pro II
  • 174 replies
  • Answer
  • April 13, 2023

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2749 replies
  • April 13, 2023

Thank you for sharing where you found the information @nathantrauscht !


anahizentella94
Jr Varsity III
Forum|alt.badge.img

It is possible to specify the regular expression in the input mask value in PXUIField Attribute?


nathantrauscht
Semi-Pro II
Forum|alt.badge.img

@anahizentella94 not sure about PXUIField Attribute.

I am referring to CSAttribute - Configuration > Common Settings > Attributes

 

For CSAttribute of Text type you can assign an Entry Mask and Reg. Exp. (Regular Expression)

For my use case, I am using an input validation for an attribute we created for VIN (Vehicle Identification Number).

VINs are 17 characters long alpha numeric, all upper case. Thus, I did the following:

Entry Mask: >CCCCCCCCCCCCCCCCC

From what I understand, the entry mask is just that, it creates a mask. This expression creates a mask that allows any character (C) auto corrects to upper case (>) and allows up to 17 characters.

Reg. Exp.: >CCCCCCCCCCCCCCCCC{17,17}

This expression validates if the input was 17 characters long {17,17}, is uppercase and is any character.

 

I have never used Regular Expression before so this took some tinkering for me to figure out the correct syntax. https://learn.microsoft.com/en-us/previous-versions/visualstudio/visual-studio-2010/ae5bf541(v=vs.100)?redirectedfrom=MSDN


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings