Details of the Issue:
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?
With Claygent Neon, you can split your extracted Reddit URLs across multiple columns instead of having them in a single text cell.Here's how to process the URLs: 1. First, use the "Extract URLs and Emails from Text" action to identify and isolate all URLs from your text. 2. Then, use the "Normalize and Deduplicate a List" action to clean up the extracted URLs and ensure each unique URL appears only once.This will help you better structure the data and set up downstream workflows like outbound messaging. Sources: Introducing Claygent Neon Extract URLs and Emails from Text with Clay Normalize and Deduplicate a List with Clay
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
Hi, thank you for reaching out. Since you have multiple URLs in a single cell and the number of URLs can vary from row to row, you'll need to organize the URLs as a comma-separated list within each cell. For example, if a row contains three URLs, each separated by commas, you will need to create separate formula columns for each one. Each formula should be designed to extract the specific URL that comes after a particular comma. For instance, if cell A1 contains the following list of URLs: https://example1.com, https://example2.com, https://example3.com, the first formula would extract https://example1.com, the second formula would extract https://example2.com, and the third formula would extract https://example3.com. T his way, each formula is instructed to pull the URL after the corresponding comma, allowing you to capture all the URLs in the list.
Here is how you crate a free formula column. In order to add a formula column, select "Add Column" and then from the drop-down menu select formulas, as shown below: https://downloads.intercomcdn.com/i/o/w28k1kwz/1249219467/179194ede91a0e4d5fc123ac37ba/CleanShot%2B2024-11-12%2Bat%2B13_01_31-402x.png?expires=1734379200&signature=8c1da479cf1260ba3aaaadb02c64f9e798356885d83ddb235b25a185a21c3bb8&req=dSIjH8t%2FlIVZXvMW1HO4zR633nl0TmRjKxJs7vPnJUHAeQ%3D%3D%0A After selecting this, you'll be able to either use an AI prompt in the first box or JavaScript to instruct Clay on how to process the results from a column. An example of what this looks like is shown below: https://downloads.intercomcdn.com/i/o/w28k1kwz/1249219465/319e91ab6426605ec60e0373327f/CleanShot%2B2024-11-12%2Bat%2B13_02_13-402x.png?expires=1734379200&signature=9bd98b5dd1ed2b40c87664d83e3b8bd9338d84f7012ad7e053eb5a6ce06af887&req=dSIjH8t%2FlIVZXPMW1HO4zSmebk57D6EDi3xWrBnA6I%2Bq7Q%3D%3D%0A In this case, I recommend using the first box to specify what you want Clay to do. For example, for the first column you could tell to retrieve everything before the first comma. For the second column, tell it to retrieve everything after the first comma and before the second. Then, click on "Generate Formula," which will create a JavaScript formula for you and show the results that would be generated if the formula were applied. If you're satisfied with the results, simply click "Output Is Correct, Save Formula." The button is shown below: https://downloads.intercomcdn.com/i/o/w28k1kwz/1249226258/4291d1f1d1f7d8c27f2785ecb8ef/CleanShot%2B2024-11-12%2Bat%2B13_06_48-402x.png?expires=1734379200&signature=c3fcc7fdd330dc2d14bdf57cef65720475b0af76169963454394517054f6a439&req=dSIjH8t8m4NaUfMW1HO4zXQjz7BDrskI2M5%2FySCWtP5QWA%3D%3D%0A For more information on how AI formulas work, I recommend you take a look at this Clay University video, which explains everything in more detail! Please let me know if this helps!
