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.
I am trying to do a simple text to columns with fixed width and have viewed the answers on here but cannot find a reply that solves my question.
In the example above I need to ignore the first 9 characters and select anything from the 10th character, there is not a fixed number of characters after the 10th it could be 5 it could be 50. In excel I would do text to columns fixed width starting 10th character. How do I do this in Alteryx? I have tried using RegEX however I do not know what to put in the Regular expression.
I originally answered the post while on my walk. The substring function is zero-based and will pick up from the 11th character going forward if no length is specified. This should be FASTER than a RegEx expression such as:
It is also easier to explain.
That just might work for you.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.