Building your first bot

Hi @LincolnGuerra ,

1. Select the cell or column that contains the text you want to split.

2. Select Data > Text to Columns.

3. In the Convert Text to Columns Wizard, select Delimited > Next.

4. Select the Delimiters for your data. For example, Comma and Space. You can see a preview of your data in the Data preview window.

5. Select Next.

6. Select the Destination in your worksheet which is where you want the split data to appear.

7. Select Finish.

To extract the table from the web page. you can use the Web Recorder or the Universal Recorder commands. Here are some steps you can follow:

• If you are using the Web Recorder command, you need to enter the URL of the web page that contains the table you want to extract, and click Start. Then, you need to click the Extract Table button on the Web Recorder toolbar, and select the table you want to capture. You can also specify if the table spans across multiple pages, and how to save the extracted data as a CSV file. For more details, you can refer to this guide1.
• If you are using the Universal Recorder command, you need to launch the Recorder action, and select a Table type element from the source web page or application. You can then perform various actions on the table, such as getting its data, row count, column count, cell value, etc. You can also use the Data Table command to manipulate and write the extracted data to a file. For more details, you can refer to this guide or this forum post.