regexmaster-data-servicesmds

How to use Regex to match a specific character pattern or format?

I am trying to create a Regex pattern that forces a string to match this format: A99.9. (Alpha, Numeric, Numeric, Period, Numeric). I am trying to build this into a business rule in Master Data Services. Anyone have any thoughts?

Solution

  • https://regex101.com/

    Copy + Paste /[A-Z][0-9]+\.[0-9]+/ make sure insensitive is selected; (so /[A-Z][0-9]+.[0-9]+/) how ever do you have any other formats you want to try? Is it really just A99.9, B88.8, C77.7 and so forth?