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.
So there are A LOT of different ways to do this in Alteryx. Revstring is one way but you can also do a combo left and right calc on your field. See the attached app. To run it, just double click it. To see how its complied, right click and edit it. From there you can see how the function works. The only reason that I added the app piece is so that you could see how you could make it easier to update than updating the "10" in the formula, which looks like this in the workflow:
This is essentially taking the left 10 of your field, then the last character of that string that is returned. The "+1" gives you that zero base. If you wanted character was 16, update the 10 to 16.
One thing to be careful about is, if the string you're looking for is more than 1 character in length, to reverse that as well... here's a generic solution looking for the last instance of [stringToFind] inside the parent [testString] ...