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.
Find answers, ask questions, and share expertise about Alteryx Designer.
General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!
There are two ways you can do this, one using Regex, if you are familiar with this. The other is using the Text to Columns and a Formula Tool which is easier if you're not familiar with Regex!
In the top workflow using Regex - This is looking for anytime the string matches Wk + anything else after this (represented by '.+)
In the bottom workflow - Firstly you use a formula to Replace "Wk" with "|Wk". By inserting a "|" you can then easily use the Text to Columns tool to split the data. The Select tool then allows you to remove unwanted fields/
In fact, there is a simpler solution than the two shown above!
Using a Formula Tool if you enter the syntax of your formula to be Substring([MyField],FindString([MyField]," W")+1,99999) this is going to reference your data field (Replace [MyField] with your field name, and only take the information from the W onwards as you would like.
This means you don't need to use Regex and reduces the number of tools within your workflow!
FindString function brings you the position of your first "W", then take the length of your string and subtract that, that will give you the amount of characters you want to bring from the right of the string you're analyzing.