Find a certain word from Text File

[shahidh.aqeel.shahul]

Hello,

I have a text file where the content will look like the pattern as shown in the image.

All the rows will have the same value in ColA

I wanted to find the value of ColA. Finding in any one row is fine.

(i.e.) As per the below image, I should get the output as “123”

Requesting for help on this.

[Shiva_Nikhil]

@shahidh.aqeel.shahul

or use read text file and see the output of the read text file as outputstr

use below

outputstr.Split({environment.newline},StringSplitOptions.RemoveEmptyEntries)(1).Split(" "c).First

hi you can use generate datatable activity

and the output is datatable

you can call the value as

output=datableoutput.rows(0)(0) gives you as the “123”

[Usha_Jyothi]

You can try with the regex also as shown in the below image

Hope it helps
Usha

[shahidh.aqeel.shahul]

Thank you @Shiva_Nikhil