Count() on blank space XQUERY












1















I want to count how many books I have listed
I have:



books = "book-one book-two book-three ..."


If i use



count(books)


it only returns 1 no matter how long my string is, since count separates on , I'm guessing.



How can I count separating on blank-space instead?










share|improve this question



























    1















    I want to count how many books I have listed
    I have:



    books = "book-one book-two book-three ..."


    If i use



    count(books)


    it only returns 1 no matter how long my string is, since count separates on , I'm guessing.



    How can I count separating on blank-space instead?










    share|improve this question

























      1












      1








      1








      I want to count how many books I have listed
      I have:



      books = "book-one book-two book-three ..."


      If i use



      count(books)


      it only returns 1 no matter how long my string is, since count separates on , I'm guessing.



      How can I count separating on blank-space instead?










      share|improve this question














      I want to count how many books I have listed
      I have:



      books = "book-one book-two book-three ..."


      If i use



      count(books)


      it only returns 1 no matter how long my string is, since count separates on , I'm guessing.



      How can I count separating on blank-space instead?







      xml count xquery






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 14 '18 at 11:53









      SaraSara

      223




      223
























          1 Answer
          1






          active

          oldest

          votes


















          2














          Assuming the books are separated by a space, you can split the string into a sequence of strings using the fn:tokenize() function:



          fn:tokenize("book-one book-two book-three", " ")


          This will return a sequence of the books:



          ("book-one", "book-two", "book-three")


          The fn:tokenize() function can work with literal strings like " ", or it can take regular expressions like "s+" (to mean "one or more whitespace characters"). This allows for some pretty sophisticated pattern matching.



          For the canonical description of this function, see https://www.w3.org/TR/xpath-functions-31/#func-tokenize, and for more on regular expressions in XPath and XQuery, see https://www.w3.org/TR/xpath-functions-31/#string.match.






          share|improve this answer



















          • 1





            Note that the XQuery 1.0 version of the function requires a regular expression as the second argument, and it's best to call normalize-space() first to get rid of any leading or trailing whitespace, as the count may otherwise be misleading. XQuery 3.1 has a single-argument tokenize() function that tokenizes on whitespace after (effectively) doing an implicit normalize-space().

            – Michael Kay
            Nov 14 '18 at 14:59











          Your Answer






          StackExchange.ifUsing("editor", function () {
          StackExchange.using("externalEditor", function () {
          StackExchange.using("snippets", function () {
          StackExchange.snippets.init();
          });
          });
          }, "code-snippets");

          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "1"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53299647%2fcount-on-blank-space-xquery%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          1 Answer
          1






          active

          oldest

          votes








          1 Answer
          1






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes









          2














          Assuming the books are separated by a space, you can split the string into a sequence of strings using the fn:tokenize() function:



          fn:tokenize("book-one book-two book-three", " ")


          This will return a sequence of the books:



          ("book-one", "book-two", "book-three")


          The fn:tokenize() function can work with literal strings like " ", or it can take regular expressions like "s+" (to mean "one or more whitespace characters"). This allows for some pretty sophisticated pattern matching.



          For the canonical description of this function, see https://www.w3.org/TR/xpath-functions-31/#func-tokenize, and for more on regular expressions in XPath and XQuery, see https://www.w3.org/TR/xpath-functions-31/#string.match.






          share|improve this answer



















          • 1





            Note that the XQuery 1.0 version of the function requires a regular expression as the second argument, and it's best to call normalize-space() first to get rid of any leading or trailing whitespace, as the count may otherwise be misleading. XQuery 3.1 has a single-argument tokenize() function that tokenizes on whitespace after (effectively) doing an implicit normalize-space().

            – Michael Kay
            Nov 14 '18 at 14:59
















          2














          Assuming the books are separated by a space, you can split the string into a sequence of strings using the fn:tokenize() function:



          fn:tokenize("book-one book-two book-three", " ")


          This will return a sequence of the books:



          ("book-one", "book-two", "book-three")


          The fn:tokenize() function can work with literal strings like " ", or it can take regular expressions like "s+" (to mean "one or more whitespace characters"). This allows for some pretty sophisticated pattern matching.



          For the canonical description of this function, see https://www.w3.org/TR/xpath-functions-31/#func-tokenize, and for more on regular expressions in XPath and XQuery, see https://www.w3.org/TR/xpath-functions-31/#string.match.






          share|improve this answer



















          • 1





            Note that the XQuery 1.0 version of the function requires a regular expression as the second argument, and it's best to call normalize-space() first to get rid of any leading or trailing whitespace, as the count may otherwise be misleading. XQuery 3.1 has a single-argument tokenize() function that tokenizes on whitespace after (effectively) doing an implicit normalize-space().

            – Michael Kay
            Nov 14 '18 at 14:59














          2












          2








          2







          Assuming the books are separated by a space, you can split the string into a sequence of strings using the fn:tokenize() function:



          fn:tokenize("book-one book-two book-three", " ")


          This will return a sequence of the books:



          ("book-one", "book-two", "book-three")


          The fn:tokenize() function can work with literal strings like " ", or it can take regular expressions like "s+" (to mean "one or more whitespace characters"). This allows for some pretty sophisticated pattern matching.



          For the canonical description of this function, see https://www.w3.org/TR/xpath-functions-31/#func-tokenize, and for more on regular expressions in XPath and XQuery, see https://www.w3.org/TR/xpath-functions-31/#string.match.






          share|improve this answer













          Assuming the books are separated by a space, you can split the string into a sequence of strings using the fn:tokenize() function:



          fn:tokenize("book-one book-two book-three", " ")


          This will return a sequence of the books:



          ("book-one", "book-two", "book-three")


          The fn:tokenize() function can work with literal strings like " ", or it can take regular expressions like "s+" (to mean "one or more whitespace characters"). This allows for some pretty sophisticated pattern matching.



          For the canonical description of this function, see https://www.w3.org/TR/xpath-functions-31/#func-tokenize, and for more on regular expressions in XPath and XQuery, see https://www.w3.org/TR/xpath-functions-31/#string.match.







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Nov 14 '18 at 12:42









          joewizjoewiz

          3,9571120




          3,9571120








          • 1





            Note that the XQuery 1.0 version of the function requires a regular expression as the second argument, and it's best to call normalize-space() first to get rid of any leading or trailing whitespace, as the count may otherwise be misleading. XQuery 3.1 has a single-argument tokenize() function that tokenizes on whitespace after (effectively) doing an implicit normalize-space().

            – Michael Kay
            Nov 14 '18 at 14:59














          • 1





            Note that the XQuery 1.0 version of the function requires a regular expression as the second argument, and it's best to call normalize-space() first to get rid of any leading or trailing whitespace, as the count may otherwise be misleading. XQuery 3.1 has a single-argument tokenize() function that tokenizes on whitespace after (effectively) doing an implicit normalize-space().

            – Michael Kay
            Nov 14 '18 at 14:59








          1




          1





          Note that the XQuery 1.0 version of the function requires a regular expression as the second argument, and it's best to call normalize-space() first to get rid of any leading or trailing whitespace, as the count may otherwise be misleading. XQuery 3.1 has a single-argument tokenize() function that tokenizes on whitespace after (effectively) doing an implicit normalize-space().

          – Michael Kay
          Nov 14 '18 at 14:59





          Note that the XQuery 1.0 version of the function requires a regular expression as the second argument, and it's best to call normalize-space() first to get rid of any leading or trailing whitespace, as the count may otherwise be misleading. XQuery 3.1 has a single-argument tokenize() function that tokenizes on whitespace after (effectively) doing an implicit normalize-space().

          – Michael Kay
          Nov 14 '18 at 14:59


















          draft saved

          draft discarded




















































          Thanks for contributing an answer to Stack Overflow!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53299647%2fcount-on-blank-space-xquery%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Bressuire

          Vorschmack

          Quarantine