How to scrape table from text

Help Activities
1

Hello, I would like to scrape the article code column data and Start Date from a text file that the robot receives

The table will always look like this but the number of rows may differ

Article Code Article Designation Article Typology UP Manager Market Group Commercial Use Commercial Use Commercial Line Commercial Line Activity Hierarchy Activity Hierarchy Novelty Presentation Presentation Analysis Class Analysis Class Start Date
G062124 POT 80ML O U35 610000000 100 Catalog Sales S54 Food Product F31265183 Snacks & Chips 3 3 POT Food Product Food Product 01.07.2024
G062125 POT 80ML O U35 610000000 100 Catalog Sales S54 Food Product F31265183 Snacks & Chips 3 3 POT Food Product Food Product 01.07.2024

How can I achieve this ? I need the list of article codes and only the first date

Thank you

2

Hi @adext

We get the Input as datatable in excel or text data in text document file. Could you be more specific and it’s better to provide the required output image also.

Hope you understand!!

3

@adext

ideally you can read the text file as string and then use generate datatable activity and select the row and column separators and convert it to datatable

better provide the actual file if you need more info…else try to follow the above way and you would be able to get it as datatable and from there any column or any value can be extracted

cheers