How to extract string after specific string

Help StudioX
1

I have a text file with so many lines. From the entire text file I need to extract all the repeated strings in the file after specific string. Let’s say Input is a text file with so much content

Animal.Name=“Forest Elephant_1” <Has it’s own power.>

Output should be:
Tiger
Forest Elephant
African Bush Elephant

Need help in doing this. Thanks in advance.

2

Hi ,

Please attach some sample input txt file.

Happy Automation :slight_smile:

Thanks ,
Priyanka.

3

sampleText.txt (862 Bytes)

Attaching image too.Again it is a sample file with few lines.

Screenshot (71)
Screenshot (71)1338×381 31 KB

4

Hi @Kavya_Mamidishetti2

Check with this regex

Regards
Gokul

1 Like
5

@Gokul001 Thanks.Will look into it.

6

@Kavya_Mamidishetti2

It is working for you
If not, let me know

Regards
Gokul

7

pls check
Split String.zip (41.6 KB)

8

@Gokul001 It is throwing an error saying “End of Expression Expected”. I passed the expression into pattern property “Matches activity”. Provided input variable and output variable. I am very new to regular expressions concept. Correct me if I did wrong.

Regards
Kavya

9

@Mr.H Thank you will check it.

10

Hi @Kavya_Mamidishetti2

  • Use Assign Activity

Create Variable Rg1 = System.Text.RegularExpression.Regex.Matches(“Input_Variable”, “(?<=Animal.Name=”)(\S.+)(?=_)").Tostring

Can you please share the screenshot of workflow?

Regards
Gokul

11

@Gokul001

There is small mistakes in your method of writing that code, actually Matches returns collection not a single value, so code to be used is

data = System.Text.RegularExpressions.Regex.Matches(input_string,“(?<=Animal.Name=.).*(?=_\d+)”).Cast(Of Match).Select(Function(m) m.Value.ToString).ToArray()

@Kavya_Mamidishetti2 check this

here data is collection of values from regex pattern [DataType : String], input_string is the input text from which u need to extract the data

Hope this helps you

Regards,
Nived N

1 Like
12

here it is Rg1 is of string type.

Screenshot (72)_LI
Screenshot (72)_LI1046×584 59.8 KB

13

@Kavya_Mamidishetti2 - Is this your expected result?

image
image869×636 21.9 KB

  1. Read Text file and save the output has StrInput

  2. Matches activity…

image
image931×457 9.92 KB

Regex pattern …Since there is already a double quote in the string…i have escaped with another so it wont error…

 "(?<=Animal.Name="").+(?=_)"

If want to store the results in an Array…then use the below code…

ArrItems = IEnRegEx.Select(function(x) x.ToString).toarray

Hope this helps…

14

@NIVED_NAMBIAR Hey it worked. Thanks a lot but I didn’t understand the functionality behind the code. The code seems to be a bit advanced to me. Can you suggest any links to understand how functions work?

Regards
Kavya

15

@Mr.H Yeah. It worked. Thank you so much for the file.

Regards,
Kavya

16

@prasath17 Yes prasanth. That’s the expected result. It is working. Thanks a lot.

Regards
Kavya

1 Like
17

Hi @Kavya_Mamidishetti2

You can imagine that code functionality to the Matches activity in uipath,

check here

Regards,
Nived N

1 Like
18

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