How to use like in XPath?

edsamiracle picture edsamiracle · Sep 19, 2012 · Viewed 24.7k times · Source

I have a page that searches with filters. I have this code for example,

xmlTempResultSearch = xmlResidentListDisplay.selectNodes("//PeopleList/Row[@LastName != '"+txtSearch.value+"']");
xmlTempResultSearch.removeAll();

This selects the data that is not equal to the LastName inputted on the txtSearch textbox and then removes them from the result set so that its filtered to equal the last name on the txtSearch textbox.

My problem with this code is that it should be equal (=) to the txtSearch.value, what I want is that I want the result set LIKE the txtSearch.value. What happens on my page is that when I type 'santos' on the txtSearch textbox, its result set is all those last names with 'santos'. But when I type 'sant', nothing appears. I want the same result set with 'santos' because it all contains 'sant'

Answer

Dimitre Novatchev picture Dimitre Novatchev · Sep 19, 2012

You can use all of the XPath (1.0) string functions. If you have XPath 2.0 available, then you can even use RegEx.

contains()

starts-with()

substring()

substring-before()

substring-after()

concat()

translate()

string-length()

There is no **ends-with() in XPath 1.0, but it can easily be expressed with this XPath 1.0 expression**:

substring($s, string-length($s) - string-length($t) +1) = $t

is true() exactly when the string $s ends with the string $t.