Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to filter out strings?

JT0168
7 - Meteor

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!

2 REPLIES 2
ShankerV
17 - Castor

Hi @JT0168 

 

Please find the expected output.

 

ShankerV_0-1675715741578.png

 

 

Input was:

ShankerV_1-1675715755191.png

 

Many thanks

Shanker V

 

binuacs
20 - Arcturus

@JT0168 One way of doing this

binuacs_0-1675716404152.png

 

Labels