Regex Expression to extract usage % from an input text

Help Activities
, ,
1

Need help in finding usage % for a particular object PQR_STU from the given input text and expected output is 94.88

Input Text:
Object Description From Number To Number Usage % Numbers Remaining
ABC_DEF APO CIF Initial Load 0001 009999 96.949390 305
PQR_STU Documents 1 4999999 94.888018 255599
MNOP Document 1 999999999 85.317826 146821743

Output Text:
94.88

2

Hi @anjasing

Could you try “(?<=PQR_STU)(\s\S+){4}” and extract Group 1

A regular expression tool finds a match in a test string, highlighting the relevant text following the "PQR_STU" identifier within a specific pattern. (Captioned by AI)
A regular expression tool finds a match in a test string, highlighting the relevant text following the "PQR_STU" identifier within a specific pattern. (Captioned by AI)1080Ă—895 123 KB

This image displays the match and group information for a regular expression search on a test string. (Captioned by AI)
This image displays the match and group information for a regular expression search on a test string. (Captioned by AI)1080Ă—683 109 KB

3

I already have a code deployed and don’t want to change code. only want to change the config from config file and this isn’t working. Thank you

4

@anjasing

Try to update in config:

PQR_STU\s+\d+\s+\d+\s+(\d+.\d{2})

5

What is the code used??
Matches? Match? Groups?

6

find matching patterns - first match

1 Like
8

Hi @anjasing

To be more precise and as seen in the input text format you could use the expression

(?<=PQR_STU.*?\s)\d{2}\.\d{2}

A screenshot of the regex101 interface showing a regular expression that matches a specific pattern in the given test string, with one match highlighted. (Captioned by AI)
A screenshot of the regex101 interface showing a regular expression that matches a specific pattern in the given test string, with one match highlighted. (Captioned by AI)1080Ă—980 110 KB

If this works, please do mark as a solution

Thank you

1 Like