Extract substring from string

I need to extract data from title to height from below string.
Can someone explaing the string manupulation logic behind it?

"<iframe id=“inlineFrameExample”
title=“Inline Frame Example”
width=“300”
height=“200”

"

@rkrahul5565

For this you can use Regex as below

Use a Assign activity
Title = System.Text.RegularExpressions.Regex.Match(Variable,"(?<=title=“).*?(?=\”))").ToString

Hope this helps you

Thanks

2 Likes

@ksrinu070184 Thanks

Asn if i need to fetch data under only responsibilities from excel in the below image,how will you write it ?

Is your Data available in pdf file or tell me source of data .

Source requires login credentials.
But information is as below:

Responsibilities:
text1
text2
text3

Experience:
text4
text5
text6

I need to extract only text1,text2,text3 from excel and add in datatable

Hi,
You can get particular cell value by using Read Cell or Get Row item,store it in a string variable and then simply write cell it other excel file.