Clay Icon

How to Separate Scraped Telephone Numbers into Different Rows or Columns

ยท
ยท

Hi, I created a row with a website name, I clicked on enrich data, scraped a website in order to obtain all the telephone numbers contained in the page. I created a new column with a formula and selected list all items (telephone numbers) scraped and I get all the telephone numbers in one cell. I want each telephone number added to a different row (create a new row for each telephone number). If that's not possible at least a phone number for each column (then I will transpose to rows as I want to enrich them further). Not able to do that. Can someone help?

  • Avatar of Clay Team
    Clay Team
    APP
    ยท
    ยท

    Hey there Valentino sorry for the delay. Let me take a look.

  • Avatar of Clay Team
    Clay Team
    APP
    ยท
    ยท

    So if you click on the cell, were you scraped the website for phone number a pop up menu will show. If you hover over the box that says "Phone Numbers" a new option that says "Take Actions on List" will appear to the right. Click on this option and then select "Write each item to New Row in other table".

  • Avatar of Clay Team
    Clay Team
    APP
    ยท
    ยท

    ยญ

    0581ebcf-6cb2-4328-8a61-b6770b0440a7.png(8 kB)
  • Avatar of Valentino C.
    Valentino C.
    ยท
    ยท

    it worked, thank you!