Get particular Value from Text File

Hello All,

I have one text file and I need to get the value my pool size and pool value.

I have attached thehtml.txt (2.4 KB) sample text file. any help.

1 Like

Hi
Did we try with REGEX Method
Like this with expression in MATCHES activity
“(?<=poolSize=).(\d)+”
Cheers @yogavalli

You have single instances or Multiple instances?

I have multiple instances

Hello @Palaniyappan,

Thank you for your immediate response.

I have used matched activity like before attachment.

I have two different types of pool name. Like poolname and pool_name.

I want to get it both name but unable to get it.

Could you please help me on this.

2 Likes

Try to split the texts wrt to PoolSize or poolHits and store it.

loop it , manipulate and get the value which is very easy.

hello @karthick,

Could you please elaborate the steps. It would be more helpful.

Thank you.

split the text in to multiple strings and store it in list

loop the list and use the attached xaml to get the exact word between two text GetText.xaml (8.3 KB)

if we pass two words , it will give you the word between those two strings.

Here you go with an xaml
hope this would help you
BlankProcess12.zip (10.3 KB)

Cheers @yogavalli

This is an another approach to make your things work