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.
@gabrielvilella this is very helpful, but wondering if you could expand this a bit. The attached file has multiple columns, but I am only concerned with Primary Address. The goal is to find the state abbreviation and pull it out/place it in a separate column. At first, I thought I could use the formula tool and the IF-ELSE-THEN statement, but that didn't work for me (read: I was only able to pull out a single state, not multiple). Advice on the best way to accomplish this would be very helpful. Thank you!
@lynnekilgore the best option for you is the Find and Replace. Create a table (can be a simple Text Input) with all the state abbreviations. Find that field on the address field of the other table, check the options to Append Field and select the state abbreviation field.