Filtering

[Simon1187]

Hi there, @Qiu ,     

@atcodedog05 

I am trying to filter just numbers.  In my data set, there are numbers with strings. Could you please let me know how can I filter that? 

The sample data is below.

67487 817 975 is Dave (director), 166 is Lisa (Ops manager).

Thanks, 

[Qiu · Accepted solution]

@Simon1187 
I suppose we can some Find and Replace.
Can you provide a bigger dataset?

Could not find where is the "67487 817 975 is Dave (director), 166 is Lisa (Ops manager)."?

[Simon1187]

@Qiu 

[Qiu · Accepted solution]

@Simon1187 

Hope this works for you.

[Simon1187]

Hi @Qiu , 

Thanks, if in the next step I want to filter string with a phone number from string. How can I achieve that?

[Jonathan-Sherman]

Hi @Simon1187,

You could use a similar approach to @Qiu but place wildcards at the start and end of the string so we're searching for where there are at least 6 characters from the set 0-9, space, ( and ).

REGEX_Match([Value], ".*[0-9\s+()]{6,}.*")

I've attached my workflow for you to download if needed!

Kind regards,

Jonathan