SOLVED
Re. Wildcard in filter
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
dshay248
7 - Meteor
03-28-2021
01:06 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
Labels:
- Labels:
- Transformation
4 REPLIES 4
AngelosPachis
16 - Nebula
03-28-2021
01:25 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
21 - Polaris
03-28-2021
03:34 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
AngelosPachis
16 - Nebula
03-28-2021
11:31 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yes we do need that escape, thanks @Qiu! I thought I've put it there but apparently I didn't 😁
03-29-2021
01:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi guys,
Thanks a mil for the blazingly fast response, this resolved my challenge.
