How read only particular value and add data in data table

Hi I need to read particular value the one which is highlighted in attached image and add that in the data table, the value will not be constant it will defer every time

Hi! Where do you usually get the values from?

one of many options could be using regex. Just share with us the text as text file and we can further assist.

We agree also on

as maybe an alternate input can make more simple the extraction

when in relation to your other topic, maybe the CSV string creation is the more direct target goal

Hi @sahfarooq

Check the below workflow:
Sequence41.xaml (12.7 KB)

Output:
image

Hope it helps!!

There is a portal from that we are downloading PDF and we are reading that PDF

If it comes in the format of a PDF, and it has a somewhat standard template, you can read it, save it to a String and parse it by dividing a couple of times between key points in the document so only the region of interest is left.

Another approach would be to use REGEX as @ppr mentioned. The first part would be the same, read the PDF, save it to a string and try to divide after System.Environment.NewLine so you are left with each line as a unique element. After you did this, you can check with REGEX if the current element from the list that you got is what you are looking for or not.

It Worked, Thank you

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