# Filter schema browser with trailing space does not work **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [August 24, 2022, 11:26am UTC](https://forums.toadworld.com/t/filter-schema-browser-with-trailing-space-does-not-work/55918 "2022-08-24T11:26:19Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![esko.lakso](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/esko.lakso/32/13094_2.png) [@esko.lakso](https://forums.toadworld.com/u/esko.lakso)\ **Post date:** [August 24, 2022, 11:26am UTC](https://forums.toadworld.com/t/filter-schema-browser-with-trailing-space-does-not-work/55918/1 "2022-08-24T11:26:19Z")
I often filter my tabs in the Schema browser, and I have found that if you have a leading space the filter still works, but not if you have a trailing space " convert\_tz\_time" works but not "convert\_tz\_time " ![image](https://global.discourse-cdn.com/quest/original/2X/0/09df75d14aa61f1c67921edf916653b113428882.png) ---
**Author:** ![Gary.Jerep](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gary.jerep/32/205_2.png) [@Gary.Jerep](https://forums.toadworld.com/u/Gary.Jerep)\ **Post date:** [August 24, 2022, 5:00pm UTC](https://forums.toadworld.com/t/filter-schema-browser-with-trailing-space-does-not-work/55918/2 "2022-08-24T17:00:28Z")
Looks like we trim leading Spaces. However, anything following the pattern you enter will be considered part of the pattern. As best practice, I always use the wildcard character if I'm trying to get fancy... e.g. the filter pattern %C%C% in my Schema Browser returns matched functions per below snap. Note to Quest Dev... would be useful to allow regex patterns in the ad hoc filter box (and formal filter pane too, BTW). ![image](https://global.discourse-cdn.com/quest/original/2X/5/5540f382616d873a6a08382f200108e5468d883d.png) ---
**Author:** ![esko.lakso](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/esko.lakso/32/13094_2.png) [@esko.lakso](https://forums.toadworld.com/u/esko.lakso)\ **Post date:** [August 24, 2022, 5:57pm UTC](https://forums.toadworld.com/t/filter-schema-browser-with-trailing-space-does-not-work/55918/3 "2022-08-24T17:57:22Z")
I use the wildcard symbol all the time as well. I noticed this when I copied a p\_full\_name from a Teams chat and pasted into the filter field and nothing was shown. Apparently when you copy from different programs an extra space is often added to string ---
**Author:** ![Gary.Jerep](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gary.jerep/32/205_2.png) [@Gary.Jerep](https://forums.toadworld.com/u/Gary.Jerep)\ **Post date:** [August 24, 2022, 8:31pm UTC](https://forums.toadworld.com/t/filter-schema-browser-with-trailing-space-does-not-work/55918/4 "2022-08-24T20:31:26Z")
Quest Dev may want to consider trimming trailing spaces in the filter fields as well, since it's very unlikely that a database object name would contain a space char. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [August 29, 2022, 9:39pm UTC](https://forums.toadworld.com/t/filter-schema-browser-with-trailing-space-does-not-work/55918/5 "2022-08-29T21:39:15Z")
I'll trim the spaces. Thanks. ---
**Author:** ![russell.cannon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/russell.cannon/32/12042_2.png) [@russell.cannon](https://forums.toadworld.com/u/russell.cannon)\ **Post date:** [August 31, 2022, 1:12pm UTC](https://forums.toadworld.com/t/filter-schema-browser-with-trailing-space-does-not-work/55918/6 "2022-08-31T13:12:12Z")
It would be great if REGEX patterns were allowed in the filter box. Cheers, Russ ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [August 31, 2022, 1:20pm UTC](https://forums.toadworld.com/t/filter-schema-browser-with-trailing-space-does-not-work/55918/7 "2022-08-31T13:20:46Z")
I really don't want to add a "regex" checkbox or something like that to turn regex on/off here. Also, at that point, I'd have to remember if each saved filter text is regex or not. Hm, Maybe there could be a special key sequence to indicate it's regex. For example, right now, you can do a NOT filter by starting with ! !a\* will show you everything which does NOT start with the letter a. I could do something similar to indicate a regex filter. Maybe {R}, but that doesn't roll off the fingers too easily. Suggestions? ---
**Author:** ![russell.cannon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/russell.cannon/32/12042_2.png) [@russell.cannon](https://forums.toadworld.com/u/russell.cannon)\ **Post date:** [August 31, 2022, 4:35pm UTC](https://forums.toadworld.com/t/filter-schema-browser-with-trailing-space-does-not-work/55918/8 "2022-08-31T16:35:27Z")
Would it even be the full REGEX notation or just a subset? Cheers, Russ ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [August 31, 2022, 5:18pm UTC](https://forums.toadworld.com/t/filter-schema-browser-with-trailing-space-does-not-work/55918/9 "2022-08-31T17:18:52Z")
full, unless there is some reason not to. I mean, If we're gonna do this, we might as well do it... ---
**Author:** ![russell.cannon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/russell.cannon/32/12042_2.png) [@russell.cannon](https://forums.toadworld.com/u/russell.cannon)\ **Post date:** [August 31, 2022, 5:38pm UTC](https://forums.toadworld.com/t/filter-schema-browser-with-trailing-space-does-not-work/55918/10 "2022-08-31T17:38:27Z")
Then, how about using [...] for signaling REGEX notation? Would that just be a dll? You wouldn't have to code all that up yourself? ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [August 31, 2022, 5:43pm UTC](https://forums.toadworld.com/t/filter-schema-browser-with-trailing-space-does-not-work/55918/11 "2022-08-31T17:43:47Z")
So, the whole thing in brackets? That could work. We have an internal regex library that we make heavy use of already in Toad. I would just use that. ---
**Author:** ![russell.cannon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/russell.cannon/32/12042_2.png) [@russell.cannon](https://forums.toadworld.com/u/russell.cannon)\ **Post date:** [August 31, 2022, 5:45pm UTC](https://forums.toadworld.com/t/filter-schema-browser-with-trailing-space-does-not-work/55918/12 "2022-08-31T17:45:39Z")
Yeah, the whole thing in square brackets. We already have to use brackets for some character classes in REGEX, so what's a couple more. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [August 31, 2022, 6:06pm UTC](https://forums.toadworld.com/t/filter-schema-browser-with-trailing-space-does-not-work/55918/13 "2022-08-31T18:06:27Z")
Mike just pointed out to me that if we do it this way, the only 2 ppl on the planet who will know about this feature are you and me, lol. He's probably right. I'll see if I can come up with a built-in button or something in the filter box. Also, I forgot that we are already storing the history in XML format, so it shouldn't be that big of a deal for me to remember if each filter item is regex or not. This will probably not come until the version after 16.2 though. We are about done with 16.2. ---
**Author:** ![russell.cannon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/russell.cannon/32/12042_2.png) [@russell.cannon](https://forums.toadworld.com/u/russell.cannon)\ **Post date:** [August 31, 2022, 6:07pm UTC](https://forums.toadworld.com/t/filter-schema-browser-with-trailing-space-does-not-work/55918/14 "2022-08-31T18:07:44Z")
Thanks for considering it.