Filter a worksheet by PART of a class name

[mattao]

Hi everyone,

I've produced an heavy VW file and I use the new collapsible classes. I got classes such as 12 Tiles_Green_30x60 and 12 Tiles_Grey_30x30...

I'd like to filter my worksheet by A PART of the class name... like all the classes containing 12 Tiles in there class name.

Could you help?

Thanks

[michaelk]

If I understand what you are trying to do, then yes, you can.

Create a database.

For the criteria use Class = 12 Tiles_Green_30x60

+ whatever other criteria you need.

This will give you a database of just the objects in Class '12 Tiles_Green_30x60'.

Right click on the database row header and choose Edit Critieria.

In the next dialog box hit Cancel.

The formula bar will now say =DATABASE(.........

Look for the expression (C='12 Tiles_Green_30x60')

Delete the part between the single quotes that changes in each class name and replace it with an asterisk.

i.e., (C='12 Tiles_Green_*')

Hit return.

The database will now have all the objects who's class name contains 12 Tiles_Green_

If you edit the criteria again using the GUI you will need to reinsert the asterisk.

example attached.

hth

mk

[mattao]

Thanks for your real fast answer,

BUT

It's not working there, the criteria return 0 objects as soon as I hit "recalculate" I am now updating to SP2....

[michaelk]

If you want to post a stripped down example, I'd be happy to take a look at it. There's one way that it works and a million ways it doesn't!

mk

[mattao]

Ok it's now working... I updated to SP2

I will check for a huge file

Thanks a lot for your help

[mattao]

It's now perfectly working on a huge file too... :-)

Very pleased Mat there

[mattao]

May I suggest to VW developers to add a contain choice in the class CRITERIA?

[mattao]

I noticed a very large difference between refreshing times of a worksheet when I change a criteria ( refresh instantly ) and ask for recalculate ( got the time to check for mail )

Is that normal?

Plus: I'd like to have a shortcut to access the worksheet database criteria