2 Replies Latest reply on Jun 22, 2018 4:45 PM by Jonathan Painter

    How do I join / append using contains or regex?

    Jonathan Painter

      Essentially what I'm attempting to do is a poor mans full text geo-reference for a single city.One excel sheet contains full text of news articles containing neighborhood names while the second sheet contains a column of just neighborhood names with the corresponding lat and long. The idea is to append the lat and long data to the full text news article based on the corresponding neighborhood. Any assistance would be much appreciated.