I have columns with V_string type which I need to remove the following using Alteryx workflow: Would appreciate your help on this.
Characters that start with any number except 0 and has more than 7 characters.
Example:
8046489335 |
163768034 |
81307446 |
1908876001 |
21369876 |
20,201,345,202,201 |
On the other hand, wanted to keep the following in the same column:
PO 0002450000 |
INV 230450, P.O. 0002356789 |
1678900 |
R00034567 |
Thank you!
Solved! Go to Solution.