Need help with Regular expression

(5) Share

Report

Posted on by subodhkant

I need assistance with regular expression. I am using this regular expression "^[a-zA-Z0-9]+-\\d" on field using X++ where I want to accept only alphanumeric characters. But only exception that last two characters are - and a number. @Martin Dráb Thank you.

Categories:

Dynamics 365 Supply Chain Management

I have the same question (0)

All responses (8)

Answers (2)

Verified answer

Martin Dráb 237,795 Most Valuable Professional on at

Like (2)

Report

Assuming that you're using System.Text.RegularExpressions.Regex, your regex looks good to me, with one exception. You only check that the string begins with this pattern; any characters are allowed to follow. For example, aB1-8*^* is valid, because aB1-8 matches the pattern and the pattern says nothing about subsequent characters.

If you want want a pattern where the number is the last character, add $ at the end. Therefore the pattern can be written as '^[a-zA-Z0-9]+-\\d$' or @'^[a-zA-Z0-9]+-\d$'.

Was this reply helpful? Yes No
subodhkant 37 on at

Like (0)

Report

Thanks for the quick response. @Martin Drab

But it is not accepting the input "VQVI005293-1". Also, it is accepting all special characters second last position rather it should accept only dash.

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (1)

Report

Hi Subodhkant,

Martin is correct with his suggestion. The example you provided is working for me. You can learn more about regular expressions and perform tests using this site: RegExr: Learn, Build, & Test RegEx

In addition, you can use Copilot chat and ask for a regular expression which has in my experience amazing results.

Was this reply helpful? Yes No
subodhkant 37 on at

Like (1)

Report

Hi Andre,

form field is not accepting it.

RegEx is accepting it though

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,795 Most Valuable Professional on at

Like (1)

Report

The problem is that you show an error and return false if the check succeeds and IsMatch() returns true. You seem to mean if (!regex.IsMatch(value)).

2 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

subodhkant 37 on at

Like (1)

Report

Thanks Martin and Andre. It worked for me.

Was this reply helpful? Yes No
Martin Dráb 237,795 Most Valuable Professional on at

Like (1)

Report

Just note that your pattern doesn't ensure that the string ends with a dash and a number. For example, banana matches your pattern.

By the way, there are online tools such as Regex Tester that you can use to quickly validate your regular expressions.

1 people found this reply helpful.

Was this reply helpful? Yes No
subodhkant 37 on at

Like (2)

Report

Sorry Martin, Maybe I did not put the requirement correctly.

String is acceptable as alphanumeric only; only exception is last two characters can or can-not be dash and a number.

My apologies for the confusion. Thank you for your valuable inputs and time.

Was this reply helpful? Yes No