I want to put some of the text data of the recurring rule in columns 1 and 2 of the data table

Help Activities
, ,
1

Hello.
During the process of moving a text file to a data table

I’d like to fill in columns 1 and 2 with some of the repeating rules, is there a way?

Attach a text file.
PDF.TXT (20.7 KB)

The form I want is as shown in the Excel example below.
TEST.xlsx (11.8 KB)

How do I do it in the same way as the example?

2

Hi @sssim4567

You can get the same as excel file before moving the files

Steps :

  1. By using the regex we can get the values what you want or else you can use the matches activity to get the values
  2. Write the values to excel by using write range workbook activity

This are the steps…

Hope it may help you

3

Hi @sssim4567

You can achieve by writing Regex expressions for the text and write it back to the excel using Write Cell activity by running a For Each loop for Find Matching Patterns output.

Regards

4

Is the text file is of multiple pdfs or one pdf?

5

@sssim4567

can you check the below code
do it as mentioned in the code

addvalues to columns.zip (16.4 KB)

Hope this helps

6

image
An error occurs.

7

@sssim4567

The excel rows are 78 and the values you extract through Txt file are 39 values

i have ensured the same issue

if you want to excute that

use assign activity

image
image950×379 16.2 KB

use the above assign activity your error will get resolved