In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Re. Wildcard in filter

dshay248
7 - Meteor

Hi all,

 

I need to filter with a wildcard in this string  'order-lines.0.id'  where the wildcard is the place of the 0, but can contain up to three characters.  So 'order-lines.***.id'

 

Any ideas on how to achieve this?

 

Thanks,

 

dshay248

4 REPLIES 4
AngelosPachis
16 - Nebula

Hi @dshay248 ,

 

You can make use of a filter tool with a RegEx match expression in it

 

AngelosPachis_0-1616963045788.png

 

The dot stands for "everything" and you want 1-3 everything between "order-lines." and ".id". If that everything is always a number, you can replace the .{1,3} with \d{1.3}

 

 

Hope that helps,

 

Angelos

Qiu
21 - Polaris
21 - Polaris

@AngelosPachis 

Nice one.

And I think we may need an escape for the second period.

Capture1.PNG

AngelosPachis
16 - Nebula

Yes we do need that escape, thanks @Qiu!   I thought I've put it there but apparently I didn't 😁

dshay248
7 - Meteor

Hi guys,

 

Thanks a mil for the blazingly fast response, this resolved my challenge.

Labels
Top Solution Authors