Filter out Values with multiple Dashes

Chirag_Gandhi07

Hey everyone,

I have a field with values that contain one dash and some values contain multiple dashes. For example:

Name

James - Smith

Ryan - Jones

Dylan_ James - English - Burke

Elizabeth - kelly - Steve

How can I filter out the values that have multiple dashes? Any help would be greatly appreciated. Thank you!

Workflow

Accepted answers

Hi @Chirag_Gandhi07 ,

You could use a filter, with a Custom filter based on counting the number of hyphens. The REGEX_CountMatches function can count the number of hyphens. Those rows that have more than one will flow through the T output and those with only one through the F output in the below example

Cheers!

Esther

Hi @Chirag_Gandhi07

You can use REGEX_CountMatches in a formula tool and then filter on the result

Dan

FilterDashes.yxmd

All comments

Hi @Chirag_Gandhi07 ,

You could use a filter, with a Custom filter based on counting the number of hyphens. The REGEX_CountMatches function can count the number of hyphens. Those rows that have more than one will flow through the T output and those with only one through the F output in the below example

Cheers!

Esther

Hi @Chirag_Gandhi07

You can use REGEX_CountMatches in a formula tool and then filter on the result

Dan

FilterDashes.yxmd

Great minds think alike, @danilang !!

You can either step out into two tools, using a formula and filter, or put the formula directly into the filter.

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703