An error when trying to use matches

Help Studio
, ,
1

Hello,
Am scraping specific data from pdf to text file, then am using regex to get the specific data and write it in an excel file eg the data are names,dates(starting and ending dates), Reference number and amount.
So i have used 3 matches activity in a for each loop to get the data. However when the excel populates, it only contains the dates, no reference number and amount.
Kindly help with ideas how to resove this.

2

Hi,

Can you elaborate with specific sample?

Regards,

3

The pdf has 3 fields, Transaction dates,Post Transaction dates and Reference Number for different people, each person has several of the above fields. I have used regex to get the contents with match activity but now i want to populate them in an excel. Am having challenge with adding the reference to the excel file, the output in studio seems okay, but the excel isn’t

Is that clear ?

4

I can’t share the sample because it contains confidential information

5

@phionamartinez Kindly Share the duplicate sample data same as orginal data that you need
For example you need Username: abcd, Password: 1234
create duplicate as UserID:mnbv, Password: 78458

and required output from duplicate data, Need Number “78458”
this will helps us to provide Solution accuracy

6

So i extracted the content of pdf to a text file, i can’t upload since since am a new user but here is a sample dup of how it :

For Sarah Gozalez
Transaction Date Post Transaction Date Reference No Amount
1/02/2022 1/02/2022 123abcd456 2000

For Luiz Swarez
Transaction Date Post Transaction Date Reference No Amount
2/02/2022 2/02/2022 456xyz534 100
3/02/2022 4/02/2022 655vwz789 50
4/02/2022 4/02/2022 112btw678 535
6/02/2022 7/02/2022 385byt345 250

For Ramos Antonio
Transaction Date Post Transaction Date Reference No Amount
8/02/2022 9/02/2022 200yxp334 100
7/02/2022 8/02/2022 655vwz789 500
7/02/2022 7/02/2022 112btw678 535
5/02/2022 7/02/2022 385byt345 250

So am trying to get this records for each person( Transaction Date, Post Transaction Date,Reference No and Amount)and write to an excel
So far i have used regex with match activity but having challenges writing it to xcel

8

Here is a better view of the content, there is some space between Reference nos and Amount

For Sarah Gozalez
Transaction Date Post Transaction Date Reference No Amount
1/02/2022 1/02/2022 123abcd456 $2000

For Luiz Swarez
Transaction Date Post Transaction Date Reference No Amount
2/02/2022 2/02/2022 456xyz534 $ 100
3/02/2022 4/02/2022 655vwz789 $ 50
4/02/2022 4/02/2022 112btw678 $ 535
6/02/2022 7/02/2022 385byt345 $ 250

For Ramos Antonio
Transaction Date Post Transaction Date Reference No Amount
8/02/2022 9/02/2022 200yxp334 $ 100
7/02/2022 8/02/2022 655vwz789 $ 500
7/02/2022 7/02/2022 112btw678 $ 535
5/02/2022 7/02/2022 385byt345 $ 250

9

Hey @phionamartinez,

Use generate datatable activity to generate the datatable from the raw data with the attached properties and then continue with your condition.
image

Thanks,
Sanjit

10

It is not working, the pdf also contains data that is unnecessary
So far I have used a for each loop, to loop through items for each person, then from there used regex in for each loop again to get each record
So am not sure where to build/generate datatable from that will store this records and write them in the excel file