I have a dataset with each row unique to a unique identifier. Each unique identifier has a city associated to it, some more than one.
XX - London
XY - London, New York
XZ - New York, London
Currently the table is in a filter pane, however using this example, when I type ‘London’ in the city column, only XX and XY appear and not XZ because London is after ‘New York’ in the string. How can I do it so that the filter searched the entire field for ‘London’