Delete items/rows (not in 7 digit format)

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.

Datasets

Tips and Tricks

Accepted answers

Hi @PassION_es ..

You can use this function in Filter Tool:

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

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

Delete itemsrows (not in 7 digit format).yxzp

All comments

Hi @PassION_es ..

You can use this function in Filter Tool:

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

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.

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

Delete itemsrows (not in 7 digit format).yxzp

@PassION_esDid you write the function in Filter Tool?

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

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

Quick Links

Tags

This months top contributors

Hollingsworth 335