Regex 999,99 XY

Help Studio
, ,
1

Hi,

I need Regex for following expression: 999,99 XY.

Explanation:

  • there can be up to 3 digits before comma
  • there can be 1 or 2 digits after comma
  • there can be 1 or more spaces betwen last number and “XY”
  • “XY” are two fixed characters.

Can someone help me, please?
Thx and KR, Vanja

2

@VanjaV
Try with this regex:
^\d{1,3},\d{1,2}\s+XY$

1 Like
3

Hi @VanjaV

You can try below regular expression:
[0-9]+[,]?[0-9]+\s*[A-Z]{2}

The image displays a regular expression test matching the pattern of numbers optionally followed by a comma or digits, and ending with two uppercase letters, successfully matching the text "999,99 XY.". (Captioned by AI)
The image displays a regular expression test matching the pattern of numbers optionally followed by a comma or digits, and ending with two uppercase letters, successfully matching the text "999,99 XY.". (Captioned by AI)1427×443 14.8 KB

Hope it helps!!

1 Like
4

Hey @VanjaV can you try with this syntax

System.Text.RegularExpressions.Regex.Match( STRINPUT,“^\d{1,3},\d{1,2}\s+XY$”).ToString

cheers

1 Like
5

Hi @VanjaV

You can use the below regular expression to achieve every point you mentioned,

\d{1,3}\,\d{1,2}\s*XY

A regular expression pattern is defined and tested on the string "999,99 XY", highlighting the matched components. (Captioned by AI)
A regular expression pattern is defined and tested on the string "999,99 XY", highlighting the matched components. (Captioned by AI)435×308 8.16 KB

→ \d{1,3} - It will extract one to three digits before comma
→ , - Extracts comma
→ \d{1,2} - It will extract one or two digits after comma
→ \s* - It will extract the spaces between digits and XY (Space will be one or more)
→ XY - It will extract XY (It is static everytime)

Hope it helps!!

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.