Generate data table related then for each raw

Help Robot
, , , , ,
1

Hello…I have one text file whose name is 1.txt
Firstly I used the Read text file activity and the used generate a data table that variable name is dt_dataTable.
and in that data table only 1 column and that name is Column1.

I need to capture specific text like My name is XXX. then I need only XXX. and that XXX is put in a new .txt file so, can you suggest to me what I can do? ya please provide a solution with a picture for better understanding.

2

HI @Ravi_Dholariya

Can you share the sample text file with us?

Regards
Gokul

3

My Name is XXX=1
First Name Patel
last name Ram

My Name is XXXx=0
First ami Patel
last name Ram

My Name is XX=1
First N Patel
last name Ram

so i need =1 all font and also second and third line.

4

This is the input string and expected output for this string ? @Ravi_Dholariya

5

i need as a output all the =1 font like you can see first 3 and last 3 raw

6

Can’t able to understand. Just type output here. @Ravi_Dholariya

Are you need to extract all the 9 lines?

7

My Name is XXX=1
First Name Patel
last name Ram
My Name is XX=1
First N Patel
last name Ram

This is output

8

HI @Ravi_Dholariya

How about this expression?

System.Text.RegularExpressions.Regex.Matches(YourString,"\S.*(?<=1)|(?<=1\n\S.*\n)\S.*|(?<=1\n)\S.*")

Check out this XAML file

TextFile - Regex.xaml (6.5 KB)

image

image
image783×411 15.3 KB

Regards
Gokul

9

in for each which activity i can used for write that data in .txt file

10

HI @Ravi_Dholariya

You can try with Write text file and Append Line activity

Regards
Gokul

11

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