Extract a chain of character

Help Studio
1

Hi everybody,

I need to extract a chain of character of a string.

For example this one : “LA SUPPLEMENTAIRE )LM RS RENTE PF161256980000-1589656-MARIE MADELEINE 20220401 LA MON”

I need to extract only the word which begin by “PF” + 8 digits.
In this case the output string must be “PF16125698”

Any idea please ?
Thank you

2

Hi @guillaume.cabanes2 ,

Could you try using the below Expression :

System.Text.RegularExpressions.Regex.Match(yourInputVar,"PF\d{8}").Value
3

Hey @guillaume.cabanes2 ,

You can use the below code

System.Text.RegularExpressions.Regex.Match(“LA SUPPLEMENTAIRE )LM RS RENTE PF161256980000-1589656-MARIE MADELEINE 20220401 LA MON”,“PF\d{8}”).Value

Thanks,
Sanjit

1 Like
4

Hi @guillaume.cabanes2

What about the following?
image

Regex.Match(strValue, "PF\d{8}").Value

image

Regards

5

Thank you so much both of them works well :slight_smile:

6

Do you have an idea of how can i make sure that the 8 following characters (After “PF”) are digits please ?

Thank you

7

The “\d{8}” part of the Regex Provided before, is making sure that the pattern only returns something, if there are exactly 8 digits. If there are more, you can enhance it with \b at the end:

Regex.Match(strValue, “PF\d{8}\b”).Value

Exactly 8 digits:
image

Not matching if +8 digits (or -)
image

if instead of \d, you had \w, then you could have letters on it.

1 Like
8

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