How to configure custom column in generate data table

Learning & Development Programs Automation Starter
, , ,
1

Hello Experts,

How can we solve this issue?
I convert pdf files into text files and then generate data table to get datable. But the generate data table output is not formatted as I want.
This is the generated data using default setting:

image
image1141Ă—725 43.1 KB

And this is the format I want:

image
image1125Ă—867 97.4 KB

I want the second column like the format : AYA/MDY/MCG/22000130 (sample customer code).
whatever there is three or four or five phase, I want to start the second column with the customer code. How can I fix the issue? If there is any solution or work around, please let me know. Thanks.

2

Hi,

If possible, can you share your input text as a file?

Regards,

3

In Generate datatable wizard, for column seperator use Tab, by default it will be space

image

4

Hi bro, please see the text file.
Page6.txt (1.1 KB)

5

the text files formats are the same but sometimes the generate data table activity works as the format I want but sometimes it separates the name into two or three columns.

6

Hi,

How about the following sample?

  • Remove whitespaces at the begining of each line
  • replace 2 or more whitespaces to chr(9) (Tab)
    Then, generate datatable from the above as tsv.

image
image523Ă—756 14.4 KB

Result

image
image1001Ă—247 8.82 KB

Sample20220818-5.zip (2.9 KB)

Regards,

7

The solution works only when there is only one space between the name. If there is two or more spaces in the name, how we can fix this. please share with me. thanks.

8

Hi,

Can you share specific sample data?

Regards,

9

Hi Yoichi,

Please receive the text file.
Page114.txt (5.1 KB)
Thanks for your help. I really appreciate it.

Best Regard,

10

Hi,

I modified the pattern as the following.

image
image1361Ă—614 29.1 KB

And as there is line turn over in some rows, I add some logic for fix it. (outputs result2.xlsx)

Sample20220818-5v2.zip (4.4 KB)

Regards,

1 Like
11

Many thanks for your help. It’s working well and this is the solution I want.

1 Like
12

hello Yoichi,

How can I ignore the first line that is not formated as table format like below:
image
In this screenshot I want to ignore “LIMITED” and want to extract all of the following data. Is this possible to get the data? If there is any solution, please help me. I also uploaded the text file. Best Regard.
Page108.txt (4.9 KB)