Delete items/rows (not in 7 digit format)

[PassION_es]

Hello Alteryx Community,

Need help on how to delete rows that do not contain a value of 7 digits in a specific column.

Please see attached sample.

Thank you.

[Rana_Kareem · Accepted solution]

Hi @PassION_es ..

You can use this function in Filter Tool:

REGEX_Match([Column Name], "\d{7}")

[PassION_es]

HI @Rana_Kareem , It got a zero or -1 output. By the way, the column is a vstring column, not double or integers. I only want to filter those who have 7 numbers in the string column.

[aatalai · Accepted solution]

@PassION_es take a look at this workflow, using @Rana_Kareem logic but in a filter tool

[Rana_Kareem]

@PassION_esDid you write the function in Filter Tool?

@aatalaiI've also mentioned to use Filter Tool !!

[PassION_es]

thanks @Rana_Kareem and @aatalai .  Yes, I used the filter tool and it works.