Скачать или смотреть How to Find an Exact Word in a Comma-Separated List Using XSLT

Learn how to effectively search for an exact word in a comma-separated list using XSLT. Explore XPath functions and solutions for both XPath 1.0 and 2.0.
---
This video is based on the question https://stackoverflow.com/q/64587202/ asked by the user 'Gudivada VENKATA PRADEEP' ( https://stackoverflow.com/u/13462378/ ) and on the answer https://stackoverflow.com/a/64587265/ provided by the user 'Tomalak' ( https://stackoverflow.com/u/18771/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: Finding exact word in a comma separated list in xslt

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
How to Find an Exact Word in a Comma-Separated List Using XSLT

Working with XML can often pose challenges, especially when you need to perform specific searches within strings. A common scenario is searching for an exact word within a comma-separated list. This article will guide you through the process of finding an exact word using XSLT (Extensible Stylesheet Language Transformations) by providing solutions tailored for both XPath 1.0 and XPath 2.0.

The Problem

You have a XML node structured like this:

[[See Video to Reveal this Text or Code Snippet]]

The challenge arises when you want to find the word APP in that list. Using the contains function will erroneously return true since APP is a substring of APPLETT. What you want is a method that ensures only the exact word is matched.

Solution Overview

To pinpoint exact matches, we need different approaches depending on the version of XPath you are using. Here, we’ll explore solutions for both:

XPath 1.0 using contains with delimiters.

XPath 2.0 using the tokenize() function.

XPath 1.0 Solution: Using Contains with Delimiters

In XPath 1.0, you can modify the contains function to ensure that you account for the delimiters by prepending and appending commas. Here’s how to implement that:

[[See Video to Reveal this Text or Code Snippet]]

Explanation:

The concat function adds commas before and after both the source string and the search word. This means, for the example input and searching for APP, it will look for ',APP,' in the string ',REQADDINFO,REQADDINFOType2, ACCEPT,APPLETT,'. This effectively excludes partial matches, ensuring you find exact matches only.

XPath 2.0 Solution: Using Tokenize

If you are using XSLT 2.0, a more elegant method is available via the tokenize() function. Here’s the syntax you can use:

[[See Video to Reveal this Text or Code Snippet]]

Explanation:

The tokenize() function splits the comma-separated values into a sequence of items, making it straightforward to check if $searchWord exists as a whole token. If $searchWord is an exact match with any of the elements resulting from the tokenize() function, it returns true.

Conclusion

By implementing the above solutions, you can effectively find exact words in comma-separated lists using XSLT. Whether you are constrained to XPath 1.0 or can utilize the more advanced features of XPath 2.0, knowing how to structure your search is key to avoiding unwanted substring matches.

By reinforcing your XML handling skills with these techniques, you'll be better equipped to handle similar challenges in your future projects. Happy coding!