How to Extract Text from a Column: Loom Video Request | Clay

How to Extract Text from a Column: Loom Video Request

Does anyone has a loom video on how to extract text from a column Example: Extracting Region only from a column that has all location

14 comments

Channeled
APP
·
·
👋 Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!
Bruno R.
·
·
Hi Youssef, thanks for reaching out. Taking a look here.
Bruno R.
·
·
Here's a video where I explain how to parse out data from enrichment columns: https://www.loom.com/share/e1234a4ece824e8687fc21ef55f9fce3?sid=19f9cdaf-dd86-4ae9-b1a0-b77802f66112 I hope this was helpful. If there's anything else I can assist you with, please let me know!
Youssef S.
·
·
Thank you so much G ♥️
Youssef S.
·
·
Sorry if I didn't explain it well, the column is in this format
Youssef S.
·
·
Aint there is any other function as "Normalizing Company Names"
Bruno R.
·
·
You can achieve this by setting up an AI formula that identifies the specific separator in your list, which in this case appears to be a comma. You can use the comma as a delimiter for your data transformation logic. For example, you can configure the formula to return only the portion of the data that appears before the first comma in {{column_name}}. I've recorded a video to demonstrate how you can set this up.
Youssef S.
·
·
Man you are a life saver ❤️
Youssef S.
·
·
Thanks a bunch
Bruno R.
·
·
Happy to help here Youssef! is there anything else I can help you with?
❤️1
Youssef S.
·
·
Will let you know if I need, thanks ❤️
Channeled
APP
·
·
Hi Youssef S.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Channeled
APP
·
·
Thank you so much for sharing your feedback Youssef S.!
Channeled
APP
·
·
Thank you so much for sharing your feedback Youssef S.!