Re. Wildcard in filter

[dshay248]

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

[AngelosPachis · Accepted solution]

Hi @dshay248 ,

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

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 · Accepted solution]

@AngelosPachis 

Nice one.

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

[AngelosPachis · Accepted solution]

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

[dshay248]

Hi guys,

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