How to filter out using regex

[Sshasnk]

Hi I have a data set where I have to filter out all the records if the value is not Number or if the value does not contain '-'

Input:

Value

I-12345

23455

KLMABC

ABC6666

123

Pending

Now in the above, Only three of the above comes under our rules

Output:

Value

I-12345

23455

123

The above value is either number or contains '-'

[MJLee]

@Sshasnk 

Please refer to the picture below and the attached WF.

Regex ::

Result ::

[caltang]

Perhaps you can try this REGEX:

^\d+$|-

Or if you’d like something more traditional, you could try an IF Statement too: 

IF (IsNumber([Value]) OR Contains([Value], '-'))

THEN “True”
ELSE “False”
ENDIF

[Qiu]

@Sshasnk 
Just in case, we can use the Regex_match also in the flter tool as below.