投稿済み Mon, 21 Jan 2019 14:41:04 GMT 、投稿者 Phi Quan - left 09.2021 IT Manager

Hi all,

 

after studiyng the documantation regarding filedmasks, I am stuck and would like to ask the forum.

I would like to create a fieldmask for invoicenumbers. The mask should only accept numbers and alphanumeric AND only - (Character minus) as separators, no space, no underscore or other characters. The entry could be something between 1 and 100 characters. Minus is allowed no time, one time or multiple times. Any ideas?

 

e.g.

These should be valid data:

RE-1234-56-789-0

123-AB-12-INV

123456789

ABCDE

2019-01-19-ABCD

投稿済み Mon, 21 Jan 2019 14:51:00 GMT 、投稿者 Gerardo Lisanti Team Leader Product Management

Hi Phi,

should look like this:
^[a-zA-Z\d-]{1,100}

Giv it a try here: https://regex101.com/r/hvTzI7/1

 

Viele Grüße / With best regards,

Gerardo Lisanti
Manager Product

投稿済み Mon, 21 Jan 2019 15:09:38 GMT 、投稿者 Joe Kaufman Bell Laboratories Inc No longer there

Phi,

I got this to work, similar to what Gerardo lists (but does not allow lowercase letters):

^[A-Z0-9\-]{1,100}$

 

Thanks,

Joe Kaufman

 

投稿済み Fri, 25 Jan 2019 08:11:14 GMT 、投稿者 Phi Quan - left 09.2021 IT Manager

Thanks guys for your great help, appreciate this.

I will try to implement this and will report. Cheers!

投稿済み Sat, 26 Jan 2019 08:42:23 GMT 、投稿者 Phi Quan - left 09.2021 IT Manager

Hi Gerardo, 

thank you for the link, I think this might help for other fieldmasks we are still working on. Great tool!

Joe, thank you very much for you contribution aswell.

Works for us

フォーラムに投稿するためにはログインが必要です。