Match query

[#1]

Hi all,

I have got a field in a particular table which looks like

Location:

London                                                                                                    

North london zone 3

West

South LonDon zone 4

loNdon Zone 6

East

I would like to display on loctaions which says london (case sensitive)

Desired result I am looking at is

London

North london zone 3

South LonDon zone 4

loNdon Zone 6

Can i get some help on this please.

Regards,

kv.

[Miguel_Angel_Baeyens]

Hi,

Use the function WildMatch() that is not case sensitive. For example:

Location:
LOAD * INLINE [
Location
London                                                                                                    
North london zone 3
West
South LonDon zone 4
loNdon Zone 6
East
]
WHERE WildMatch(Location, '*london*');

Hope that helps.

Miguel

[#3]

Sorry, I asked a wrong question. I am looking to display all the values and group all the values that contains london as London.

Desired output should look like:

london                                                                                                    

West

East

[Miguel_Angel_Baeyens · Accepted solution]

No problem,

Very similar script and same function as well:

Location:
LOAD If(WildMatch(Location, '*london*'), 'London', Location) AS Location 
INLINE [
Location
London                                                                                                    
North london zone 3
West
South LonDon zone 4
loNdon Zone 6
East
];

Hope that helps.

Miguel