Regex Help Needed

Help
1

Hi Team,

I just need to extract just the storenames just after the string “Add new store” from the below lines. My expected result is ABC,XYZ

Add new store ABC
Add new store XYZ
Change store FSFJ to FSFSFSFS
Change store rtrtrt to svdfdf

I tried with below regex and it gives me entire text
“(?<=Add new store)(.*)”
ABC,XYZ,Change store FSFJ to FSFSFSFS
Change store rtrtrt to svdfdf

2

@Teenu

Try this:

yourStr = “Add new store ABC
Add new store XYZ
Change store FSFJ to FSFSFSFS
Change store rtrtrt to svdfdf”

requiredString1 = yourStr.substring(yourStr.IndexOf("Add new store ")+"Add new store ".Length).Split(Environment.NewLine.TocharArray)(0)

requiredString2 = yourStr.substring(yourStr.IndexOf("Add new store ")+"Add new store ".Length).Split(Environment.NewLine.TocharArray)(1)

3

I do not see any issue with the expression that you gave.
I had tested the regular expression and getting the expected results.

image
image1202×656 50.3 KB

image
image1202×450 40.6 KB

4

Yes, it works fine with regex editor. Except that it takes/m/g characters in regex editor

5

Not sure why it doesn’t in code when it works in regex editor

6

Let me check in code and let you know the details.

7

Thank you so much

1 Like
8

Here is with code. The following regex expression worked.

(?<=\bAdd new store\s)(\w*)

image
image1202×916 103 KB

1 Like
9

Hi Karthik,

I have used the pattern in the Matches activity as
“(?<=\bAdd new store\s)(\w*)” and input is my entire string:
“Add new store ABC
Add new store XYZ
Change store FSFJ to FSFSFSFS
Change store rtrtrt to svdfdf”

But I get only one store ie,ABC and not reading next line

10

Can you try in the following way.

Can you replace all new lines in your string into Space.
And then use the given regex pattern.

I guess it is failing to get from the new lines. Just a thought.

11

No luck:(