How to filter out using regex

Question

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:

ValueI-1234523455KLMABCABC6666123Pending

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

Output:

ValueI-1234523455123

The above value is either number or contains '-'

Qiu · Answer

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

0921-Sshasnk.yxmd

caltang · Answer

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

MJLee · Answer

@Sshasnk

Please refer to the picture below and the attached WF.

Regex ::

Result ::

SAMPLE.yxmd