Urgent help in expression please!!

[#1]

Hi,

I have address with values as

2343,Gerry street, London

453454,Licd Dale colony, Derry

2565363,Gerry street, London

2354y45y3, Dovey street, London

2346463,Piorh street, London

2343,XXXX, Canada

2343,GRaeybb, Australia

dimension is ID

expression is Address

How can I get the straight table to show the address value which contains only  London. could anyone suggest me the expression.

I used the below expression but it is not working.

If(MixMatch([Address],'*London*'),[Address] )

[jagan]

Hi,

Try like this

=Only({<Address={'*London*'}>} Address)

Regards,

Jagan.

[ashfaq_haseeb · Accepted solution]

Hi,

may be like this.

Regards

ASHFAQ

[#4]

Thanks. Tried it is showing error in set modifier. Do I need to change any thing?

[jagan]

HI,

PFA file for solution.

Regards,

Jagan.

[#6]

Thanks perfect.

[nizamsha]

Tab:

Load  * inline

[

ID,Name,City,Address

2343,Gerry street,London

453454,abc,Licd Dale colony,Derry

2565363,xyz,Gerry street, London

2354y45y3,pqr, Dovey street, London

2346463,qwer,Piorh street, London

2343,aaaa,XXXX, Canada

2343,bbbb,GRaeybb, Australia

];

Expression

only({<Address={'London'}>}Address)