3 Replies Latest reply on Apr 15, 2019 11:46 AM by Nick Parsons

    How to create URL actions for individual URLs when there are multiple URLs in one record?

    n s

      I am looking to create a URL action for individuals URLs that are in the same field but on different lines. Currently the URL actions only work on the first URL in the field or not at all. I would like to be able to make each URL work individually. Below is an example of what the URL field looks like. I've also attached a workbook. Please help!

       

       

       

      Website
      URL
      Googlehttps://www.google.com/
      https://www.google.com/maps?hl=en&tab=wl
      https://translate.google.com/?hl=en&tab=wT
      Yahoohttps://www.yahoo.com/
      https://finance.yahoo.com/
      https://sports.yahoo.com/
      MSN
      https://www.msn.com/en-us
      https://www.msn.com/en-us/sports
      https://www.msn.com/en-us/health

       

      ***Caveats:

      - My real data is sourced from a database, so I cannot alter original data source, but I can alter the sql

      - URLs need to be in one field (separating the URLs into multiple rows would create issues in my counts for other important fields)