How to filter data with a specific sentence

[#1]

Hi,

I would like to filter a group of companies in accord to the last sentence on its name.

Ex.

Field Data:

Brazil Shoes Inc.

Brazil Shoes Ltd.

What I want is to create a new group trough "Inc." and "Ltd."

Thanks,

Ronan

[renjithpl]

If i understood your question correct,

use

subfield([Brazil Shoes Inc.], ' ', 3) as Inc.,

subfield([Brazil Shoes Ltd.], ' ', 3) as Ltd.,

Regards

Ren

[#3]

Ranjit

The thing is, I have several other companies under Ltd and Inc.

Does it works for everyone?

Thanks

Ronan

[renjithpl]

so instead of putting brazil ....

Try this

If(subfield([your Field], ' ', 3) ='Inc.', 'Inc.', 'Ltd.') as XYZ,

Your Field is nothing but the field has all the companies.

then you can select XYZ to filter Inc or Ltd

Regards