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.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
This expression works based on the fact that you need the Right side of the string after the last period character. While we don't have a string function for the last character, we do have functions to reverse the characters of a string and then to find the first character.
@ChrisB Regex the most intimidating thing that should not be intimidating at all. @Thableaus sent over a great website for explaining what it is. If you want to do some real time testing, check out https://regex101.com/. Here you can paste your sample data in and play around with code and see how it reacts immediately.