This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a huge quantity of location ID codes that I am trying to turn into a usable format. My fields are consistently formatted as either:
I need to extract ONLY the state abbreviation. I think the best solution is to remove the "ST-" from the beginning of any relevant row. Then, remove everything after the "-" for all fields formatted as "STATE ABBREVIATION-CITY".
What is the best way to remove the "ST-" and also the "-CITY"? I am newer to Alteryx, but the tools I am trying give me poor results or affect things that I do not want them to affect.