How to extract matched data from any text?

[Suggala_Tejaswi]

Hi Everyone,
I have to extract titles like “MR, MRS, DR, MS…etc” from text like “MARIAMRS , ROBERTANDREWMR , ELENAMS”.
Please give any suggestions.

Thanks in advance

[Youssef_Ouajdi]

1.split your text by space
2.for each item in collection
3.if item contain MR or MRS or DR or etc
5. get the value of the item

[supermanPunch (Arpan)]

@Suggala_Tejaswi

“MR, MRS, DR, MS…etc” from text like “MARIAMRS , ROBERTANDREWMR , ELENAMS”.

Hi @Suggala_Tejaswi ,

Could you provide us the input data in the form of a Text file ? Also provide us the Expected Output after the operation is performed on the data.

This way we can make the logic concrete and suggest you with an appropriate solution.

[Suggala_Tejaswi]

Hi @Youssef_Ouajdi
There is no space in text

[Youssef_Ouajdi]

can you provide me an exemple?

[Suggala_Tejaswi]

Hi @supermanPunch

I’m attaching text file here
chauffeurAek041201AUG221231Jul22212429.XML (29.2 KB)

My inputs are like MR or MRS or MISS or MS…etc

I have to split the FST tag value highlighted in attached image and my output should be DEJANMA stored in one variable and MRS should be stored in another variable

[Yoichi]

Hi,

Hope the following sample helps you.

m = System.Text.RegularExpressions.Regex.Match(currentItem.Value,"(?<FIRSTNAME>.*)(?<TITLE>MR|MS|MRS|MISS)$")

Sample20221016-1.zip (6.3 KB)

If you need to add other title, add it to regex pattern with | . For example, in case to add DR is as follows:

m = System.Text.RegularExpressions.Regex.Match(currentItem.Value,"(?<FIRSTNAME>.*)(?<TITLE>MR|MS|MRS|MISS|DR)$")

Regards,

[Youssef_Ouajdi]

Hi,

Hope the following sample helps you.

you only need to create two variable to get the data

Séquence.xaml (8.0 KB)

Regards

[Suggala_Tejaswi]

I’m unable to opening the xaml file

[Suggala_Tejaswi]

Hi @Yoichi
Thank you for your solution,i have one more query how we can pass variable in regex in the place of MR ,MRS…etc?

[Yoichi]

Hi,

m = System.Text.RegularExpressions.Regex.Match(currentItem.Value,"(?<FIRSTNAME>.*)(?<TITLE>MR|MS|MRS|MISS)$")

Then

varFirstName = m.Groups("FIRSTNAME").Value
varTitle = m.Groups("TITLE").Value

Regards,

[Yoichi]

Hi,

Sorry for multiple replies.

If you need to pass variable as part of regex pattern, the following will help you, for example.

arrtitle = {"MR","MS","MRS","MISS"}

Then

m = System.Text.RegularExpressions.Regex.Match(currentItem.Value,"(?<FIRSTNAME>.*)(?<TITLE>"+String.Join("|",arrTitle)+")$")

Note: this assumes there is no special character in arrTitle.

Regards,