Extract details of Multiple user details

Help Studio
, , , , ,
1

Hi Forum,

I am trying to extract details from PDF which i am reading as text file and extracting , where there are some general details and some specific user details which are dynamic(1 file may have , other may have more depending on file)

So I am able to extract general details and specific user details for the first occurrence.
Which is the best approach to extract the 2nd or 3rd occurrence of user details. We will have an information of who many occurrences are expected in file .

for example this is what my file would look like :

Number of Investors : 3

name : XYZcompany
some random text and words
Corperate ID : 123XCBQaxe
Corperate Name : Reliance india pvt ltd
Investement : 1020003
some random text and words
some random text and words some random text and words
some random text and words
name : ABCcompany2
some random text and words
Corperate ID : 1243twbvhjz
Corperate Name : Tata india pvt ltd
Investement : 5649803
some random text and words
some random text and words
some random text and words
name : EFGCompant
some random text and words
Corperate ID : 56987sjgdf
Corperate Name : Adani india pvt ltd
Investement : 325412

Expected Output per occurrence
Name :
Corperate ID :
Corperate name :
Investment :

Please do let me know if you need more details

2

Could you provide 2 or 3 more samples?

3

Hello @benjamin.9052 ,

I think you can use the combination of Regex and string manipulation(split) to achieve this.

Even though if there are multiple data also you can use these method to achieve the requirement.

Kt would be better if you can share some sample files.

4

@Wong_Chee_Mun

Yes, I am using a combination of string manipulation and Regex to extract the details .

I am able to extract the general details and the details of the 1st iteration of specific user details .
I am trying to find a best approach to dynamically extract the details for multiple files with varying occurrences. I will not be able to attach the original files but this is how it would look.

File 1.txt (425 Bytes)
File 2.txt (651 Bytes)
File 3.txt (784 Bytes)

5

Hi @benjamin.9052,
You can refer to my attached solution. Let me know if this is what you trying to do.
P/S: Remember to fill in the FilePath variable first.

Extract_MultipleUserDetails.xaml (19.4 KB)