Extract specific text from Text file

Help Mobile Automation
,
1

Hi,

I want to extract text info from set of multiple text files containing specific text “Milestone”. Do I need to use Split function or Regex? I have read the pdf files and converted into string of array .

Here I want to capture Milestone 1 and Milestone 2 details from file 1, file 2 and so on.

This image shows a workflow snippet where text is read from a PDF file and then assigned to an array by splitting it based on the environment's newline character. (Captioned by AI)
This image shows a workflow snippet where text is read from a PDF file and then assigned to an array by splitting it based on the environment's newline character. (Captioned by AI)699×257 17.6 KB

The image outlines two project milestones, "Overwatch implementation" and "Unity Catalog," detailing tasks, deliverables, and associated costs for each. (Captioned by AI)
The image outlines two project milestones, "Overwatch implementation" and "Unity Catalog," detailing tasks, deliverables, and associated costs for each. (Captioned by AI)737×648 14.4 KB

The image shows a document listing milestones for a project, including the implementation of Overwatch and Unity Catalog, detailing specific tasks and associated costs for each milestone. (Captioned by AI)
The image shows a document listing milestones for a project, including the implementation of Overwatch and Unity Catalog, detailing specific tasks and associated costs for each milestone. (Captioned by AI)916×693 16.6 KB

This image lists two project milestones for data-related services: "Overwatch implementation" capturing data for up to 3 workspaces and "Unity Catalog" implementing and managing a single workspace, with associated tasks and costs. (Captioned by AI)
This image lists two project milestones for data-related services: "Overwatch implementation" capturing data for up to 3 workspaces and "Unity Catalog" implementing and managing a single workspace, with associated tasks and costs. (Captioned by AI)987×683 16.9 KB

2

Hey @dutta.marina if you are working with modern you can use for each file in a folder then inside this use read pdf text so it will read pdf one by one and store there output as a variable now you can using both methods . string manipulation or regex whichever you want
and if you are still working in classic you can use two assign one is string and 2 is array of string in string you can pass the folder location and in array of string you can use Directory.getfiles(stringvariable) and after that use 1 for each and inside that for each use read pdf and then to extract specific data you can use string manipulation or regex .
cheers Happy Automation

3

Do you want to extract all the text behind each Milestone or only “Milestone 1”?

4

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