4 Replies Latest reply: Apr 19, 2016 12:51 PM by Roberto guerra RSS

    Assign label to link if it contains certain text

    Roberto guerra

      Dear Community! First of all thank you so much for being so helpful so fast when me and other users have needed help

       

      I have a specific question... So I have a list of links, but I need to be able to add value and separate them from their content.

      Lets say I have this:

      www.hello.cl

      www.thanks.co

      www.hi.ar

      www.yes.com

       

      I'd like to be able to build something that lets me say that:

      IF URL CONTAINS

      .CL, IT IS A WEBSITE FROM CHILE

      .AR = ARGENTINA

      .COM = INTERNATIONAL

       

      Can anybody help me figure this one out?? Do I have to put this in the Load Script? Or can I just add a graph with a long expression?

      If it helps, in Excel i solved showing the final bit of the link with this:

      =RIGHT(A1,LEN(A1)-FIND(".",A1))

       

      Thanks!