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!
