XML 'Like' Search

[Elroacho]

Hi,

I'm working on an application that searches through an XML document to find data. All works well for exact string but I now need to expand it to include a 'like' search (e.g. pick out a node using a search sting 'TEST' and finding a node containing 'MY TEST SEARCH' as text.

Any Ideas?

Cheers in advance.

 

[dwarfthrower]

What are you coding in?

Regular Expressions sound like the way to go if your development environment supports them.

_{Never be afraid to share your dreams with the world.
There's nothing the world loves more than the taste of really sweet dreams.}

 

[Elroacho]

Hi, I'm coding in C#.

My line looks like this at the moment.....

string xpath = string.Format("//vw:OUTLET[vw:OUTLET_NUMBER=\"{0}\"]", routename);

I want to do something like this but on a string using a "like" type search. Is it possible.

Cheers.

 

[Elroacho]

IS there no way of doing this in xpath?

 

[k5tm]

Yes. It is the XPath function matches. You can find it described here.

Tom Morrison

http://www.liant.com

 

[simonchristieis]

i would use xpath function "contains()" and also convert to lower case as the search will be case sensitive.

<xsl:value-of select="contains(translate(//root/etc/@bob,'abcdefghijklmnopqrstuvxyz','ABCDEFGHIJKLMNO­PQRSTUVXYZ'), 'string')"/>

untested - just to give you an idea

hth

simon

 

[Elroacho]

Thanks I'll have a look.