Presently it's possible to use wildcard characters (asterisk for any character string, question mark for any single character) for, say, name and class criteria in a database criteria definition, but not for layer names or wall styles and perhaps others. In other words, the following will work:
=DATABASE(((T=WALL) & (C='New-*')))
but the these won't:
=DATABASE(((T=WALL) & (WST='New-*')))
=DATABASE(((T=WALL) & (L='Mod-*')))
Please add the ability to use wildcard characters in these (ideally all!) database criteria – this would make worksheets significantly more flexible for us!
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
Markus Barrera-Kolb
Presently it's possible to use wildcard characters (asterisk for any character string, question mark for any single character) for, say, name and class criteria in a database criteria definition, but not for layer names or wall styles and perhaps others. In other words, the following will work:
=DATABASE(((T=WALL) & (C='New-*')))
but the these won't:
=DATABASE(((T=WALL) & (WST='New-*')))
=DATABASE(((T=WALL) & (L='Mod-*')))
Please add the ability to use wildcard characters in these (ideally all!) database criteria – this would make worksheets significantly more flexible for us!
Link to comment
0 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.