Extracting Reddit URLs into Separate Columns Using Clayagent

Objective:

I am working on extracting Reddit URLs from a column containing mixed text (including multiple URLs and other miscellaneous text). I want:

To extract all Reddit URLs from each row.

To output each URL into a separate column in the same row.

Progress So Far:

Using Clayagent, I successfully extracted Reddit URLs from the text in the original column. However, when a row contains multiple URLs, they are all grouped together in a single cell or column, separated by commas or spaces.

Issue Faced:

Despite efforts to modify the prompts and configurations for Clayagent, I cannot split the multiple URLs into separate columns (e.g., Reddit Link 1, Reddit Link 2, etc.). Each URL should occupy its own dedicated column.

Steps Already Tried:

I have:

Included instructions in the Clayagent prompt to split the extracted URLs into separate columns.

Created additional blank columns in the table, intending for the extracted URLs to fill them.

Tested variations in prompts and configurations but without success.

Desired Outcome:

Each row in the Clay table should display extracted URLs from the text, with one URL per column.

Specific Questions:

How can I configure Clayagent to split multiple extracted URLs into separate columns?

Is there a specific prompt or approach I should use to achieve this functionality?