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.
Hello. I'm parsing some strings into component parts using the Alteryx RegEx node. I'd like to use a single formula to find the "parsing" characters from the "end of string." I could build a formula with if...then...else, reverse, and regex functions, but think this could be done with node.
In the last two rows of the table below, there are two instances of one of the parsing characters, "X". I'd like to use the "last" instance of that value, or "from the right." The character string lengths in front of or behind the parsing character could be variant lengths, so specifying the number of characters to look for is not a preferred solution.
My current formula is
But would like to get the portion that follows the "last" instance of the "X" character.
The dollar sign anchors the regex to the end of the string so you're searching for the last iteration of a character a-z (which could or may not be there) followed by the last number (including decimal places)
I've attached my workflow for you to download if needed!