Woorksheet question

[Hans-Olav]

Im trying to make some reports

Listing :

• Type is wall
• Layer name starts with 4385* 

 

"start with" and "end with" class name, layer name used to be options when typing *?

Am I just getting old? 

 

Kind regards

Hans-Olav

[Pat Stanford]

The * to mean any characters does not seem to work with Layers.  

 

You could use a criteria of  Class = 'Class*' to get all classes that start with the word Class, but it does not work for Layers.

 

If you have a lot of Layers that start with 4385, you might want to look into using the Database By Script option to generate the database. If you only have a few, you will have to manually select each layer into the criteria. They will be OR'd together to get what you want.

 

((Type = 'Wall') & ((Layer='4385-1') | (Layer='4385-2) | (Layer='4385-3))). where the vertical bar is a logical OR function.

 

Ask again if you want to pursue the Database by Script option.

[Hans-Olav]

Thanks a lot Pat, as always helpful.