parsing text to xml using xquery










0














i need your support formatting the following sample text from its current format to xml format using xquery:
sample text to be parsed:



INTERNATIONAL MOBILE SUBSCRIBER IDENTITY = 001010000000597 TEMPORARY MOBILE SUBSCRIBER IDENTITY = N ACTIVATION STATUS = A


to be in the following xml format



 <item>
<paramName>INTERNATIONAL MOBILE SUBSCRIBER IDENTITY</paramName>
<paramValue>001010000000597</paramValue>
</item>
<item>
<paramName>TEMPORARY MOBILE SUBSCRIBER IDENTITY</paramName>
<paramValue>N</paramValue>
</item>
<item>
<paramName>ACTIVATION STATUS</paramName>
<paramValue>A</paramValue>
</item>


please any one can help me in such case,



Thanks










share|improve this question

















  • 5




    So which XQuery version, which XQuery processor do you use? If you have access to an XQuery 3 processor then see w3.org/TR/xpath-functions/#func-analyze-string.
    – Martin Honnen
    Nov 11 at 18:38















0














i need your support formatting the following sample text from its current format to xml format using xquery:
sample text to be parsed:



INTERNATIONAL MOBILE SUBSCRIBER IDENTITY = 001010000000597 TEMPORARY MOBILE SUBSCRIBER IDENTITY = N ACTIVATION STATUS = A


to be in the following xml format



 <item>
<paramName>INTERNATIONAL MOBILE SUBSCRIBER IDENTITY</paramName>
<paramValue>001010000000597</paramValue>
</item>
<item>
<paramName>TEMPORARY MOBILE SUBSCRIBER IDENTITY</paramName>
<paramValue>N</paramValue>
</item>
<item>
<paramName>ACTIVATION STATUS</paramName>
<paramValue>A</paramValue>
</item>


please any one can help me in such case,



Thanks










share|improve this question

















  • 5




    So which XQuery version, which XQuery processor do you use? If you have access to an XQuery 3 processor then see w3.org/TR/xpath-functions/#func-analyze-string.
    – Martin Honnen
    Nov 11 at 18:38













0












0








0







i need your support formatting the following sample text from its current format to xml format using xquery:
sample text to be parsed:



INTERNATIONAL MOBILE SUBSCRIBER IDENTITY = 001010000000597 TEMPORARY MOBILE SUBSCRIBER IDENTITY = N ACTIVATION STATUS = A


to be in the following xml format



 <item>
<paramName>INTERNATIONAL MOBILE SUBSCRIBER IDENTITY</paramName>
<paramValue>001010000000597</paramValue>
</item>
<item>
<paramName>TEMPORARY MOBILE SUBSCRIBER IDENTITY</paramName>
<paramValue>N</paramValue>
</item>
<item>
<paramName>ACTIVATION STATUS</paramName>
<paramValue>A</paramValue>
</item>


please any one can help me in such case,



Thanks










share|improve this question













i need your support formatting the following sample text from its current format to xml format using xquery:
sample text to be parsed:



INTERNATIONAL MOBILE SUBSCRIBER IDENTITY = 001010000000597 TEMPORARY MOBILE SUBSCRIBER IDENTITY = N ACTIVATION STATUS = A


to be in the following xml format



 <item>
<paramName>INTERNATIONAL MOBILE SUBSCRIBER IDENTITY</paramName>
<paramValue>001010000000597</paramValue>
</item>
<item>
<paramName>TEMPORARY MOBILE SUBSCRIBER IDENTITY</paramName>
<paramValue>N</paramValue>
</item>
<item>
<paramName>ACTIVATION STATUS</paramName>
<paramValue>A</paramValue>
</item>


please any one can help me in such case,



Thanks







xml xquery






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Nov 11 at 17:44









mohamed abd ellatife

11




11







  • 5




    So which XQuery version, which XQuery processor do you use? If you have access to an XQuery 3 processor then see w3.org/TR/xpath-functions/#func-analyze-string.
    – Martin Honnen
    Nov 11 at 18:38












  • 5




    So which XQuery version, which XQuery processor do you use? If you have access to an XQuery 3 processor then see w3.org/TR/xpath-functions/#func-analyze-string.
    – Martin Honnen
    Nov 11 at 18:38







5




5




So which XQuery version, which XQuery processor do you use? If you have access to an XQuery 3 processor then see w3.org/TR/xpath-functions/#func-analyze-string.
– Martin Honnen
Nov 11 at 18:38




So which XQuery version, which XQuery processor do you use? If you have access to an XQuery 3 processor then see w3.org/TR/xpath-functions/#func-analyze-string.
– Martin Honnen
Nov 11 at 18:38












1 Answer
1






active

oldest

votes


















0














Here is an example using XQuery 3.1 and the analyze-string function:



declare namespace output = "http://www.w3.org/2010/xslt-xquery-serialization";

declare option output:method 'xml';
declare option output:indent 'yes';

declare variable $input-string as xs:string external := 'INTERNATIONAL MOBILE SUBSCRIBER IDENTITY = 001010000000597 TEMPORARY MOBILE SUBSCRIBER IDENTITY = N ACTIVATION STATUS = A';

analyze-string($input-string, '(.+?) = (S+)')//fn:match
!
<item>
<paramName> fn:group[@nr = 1] => normalize-space() </paramName>
<paramValue> fn:group[@nr = 2] => normalize-space() </paramValue>
</item>


https://xqueryfiddle.liberty-development.net/nbUY4kq



Using XQuery 3.0 without using the => operator the question looks like this:



declare variable $input-string as xs:string external := 'INTERNATIONAL MOBILE SUBSCRIBER IDENTITY = 001010000000597 TEMPORARY MOBILE SUBSCRIBER IDENTITY = N ACTIVATION STATUS = A';

analyze-string($input-string, '(.+?) = (S+)')//fn:match
!
<item>
<paramName> normalize-space(fn:group[@nr = 1]) </paramName>
<paramValue> normalize-space(fn:group[@nr = 2]) </paramValue>
</item>





share|improve this answer




















    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%2f53251470%2fparsing-text-to-xml-using-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









    0














    Here is an example using XQuery 3.1 and the analyze-string function:



    declare namespace output = "http://www.w3.org/2010/xslt-xquery-serialization";

    declare option output:method 'xml';
    declare option output:indent 'yes';

    declare variable $input-string as xs:string external := 'INTERNATIONAL MOBILE SUBSCRIBER IDENTITY = 001010000000597 TEMPORARY MOBILE SUBSCRIBER IDENTITY = N ACTIVATION STATUS = A';

    analyze-string($input-string, '(.+?) = (S+)')//fn:match
    !
    <item>
    <paramName> fn:group[@nr = 1] => normalize-space() </paramName>
    <paramValue> fn:group[@nr = 2] => normalize-space() </paramValue>
    </item>


    https://xqueryfiddle.liberty-development.net/nbUY4kq



    Using XQuery 3.0 without using the => operator the question looks like this:



    declare variable $input-string as xs:string external := 'INTERNATIONAL MOBILE SUBSCRIBER IDENTITY = 001010000000597 TEMPORARY MOBILE SUBSCRIBER IDENTITY = N ACTIVATION STATUS = A';

    analyze-string($input-string, '(.+?) = (S+)')//fn:match
    !
    <item>
    <paramName> normalize-space(fn:group[@nr = 1]) </paramName>
    <paramValue> normalize-space(fn:group[@nr = 2]) </paramValue>
    </item>





    share|improve this answer

























      0














      Here is an example using XQuery 3.1 and the analyze-string function:



      declare namespace output = "http://www.w3.org/2010/xslt-xquery-serialization";

      declare option output:method 'xml';
      declare option output:indent 'yes';

      declare variable $input-string as xs:string external := 'INTERNATIONAL MOBILE SUBSCRIBER IDENTITY = 001010000000597 TEMPORARY MOBILE SUBSCRIBER IDENTITY = N ACTIVATION STATUS = A';

      analyze-string($input-string, '(.+?) = (S+)')//fn:match
      !
      <item>
      <paramName> fn:group[@nr = 1] => normalize-space() </paramName>
      <paramValue> fn:group[@nr = 2] => normalize-space() </paramValue>
      </item>


      https://xqueryfiddle.liberty-development.net/nbUY4kq



      Using XQuery 3.0 without using the => operator the question looks like this:



      declare variable $input-string as xs:string external := 'INTERNATIONAL MOBILE SUBSCRIBER IDENTITY = 001010000000597 TEMPORARY MOBILE SUBSCRIBER IDENTITY = N ACTIVATION STATUS = A';

      analyze-string($input-string, '(.+?) = (S+)')//fn:match
      !
      <item>
      <paramName> normalize-space(fn:group[@nr = 1]) </paramName>
      <paramValue> normalize-space(fn:group[@nr = 2]) </paramValue>
      </item>





      share|improve this answer























        0












        0








        0






        Here is an example using XQuery 3.1 and the analyze-string function:



        declare namespace output = "http://www.w3.org/2010/xslt-xquery-serialization";

        declare option output:method 'xml';
        declare option output:indent 'yes';

        declare variable $input-string as xs:string external := 'INTERNATIONAL MOBILE SUBSCRIBER IDENTITY = 001010000000597 TEMPORARY MOBILE SUBSCRIBER IDENTITY = N ACTIVATION STATUS = A';

        analyze-string($input-string, '(.+?) = (S+)')//fn:match
        !
        <item>
        <paramName> fn:group[@nr = 1] => normalize-space() </paramName>
        <paramValue> fn:group[@nr = 2] => normalize-space() </paramValue>
        </item>


        https://xqueryfiddle.liberty-development.net/nbUY4kq



        Using XQuery 3.0 without using the => operator the question looks like this:



        declare variable $input-string as xs:string external := 'INTERNATIONAL MOBILE SUBSCRIBER IDENTITY = 001010000000597 TEMPORARY MOBILE SUBSCRIBER IDENTITY = N ACTIVATION STATUS = A';

        analyze-string($input-string, '(.+?) = (S+)')//fn:match
        !
        <item>
        <paramName> normalize-space(fn:group[@nr = 1]) </paramName>
        <paramValue> normalize-space(fn:group[@nr = 2]) </paramValue>
        </item>





        share|improve this answer












        Here is an example using XQuery 3.1 and the analyze-string function:



        declare namespace output = "http://www.w3.org/2010/xslt-xquery-serialization";

        declare option output:method 'xml';
        declare option output:indent 'yes';

        declare variable $input-string as xs:string external := 'INTERNATIONAL MOBILE SUBSCRIBER IDENTITY = 001010000000597 TEMPORARY MOBILE SUBSCRIBER IDENTITY = N ACTIVATION STATUS = A';

        analyze-string($input-string, '(.+?) = (S+)')//fn:match
        !
        <item>
        <paramName> fn:group[@nr = 1] => normalize-space() </paramName>
        <paramValue> fn:group[@nr = 2] => normalize-space() </paramValue>
        </item>


        https://xqueryfiddle.liberty-development.net/nbUY4kq



        Using XQuery 3.0 without using the => operator the question looks like this:



        declare variable $input-string as xs:string external := 'INTERNATIONAL MOBILE SUBSCRIBER IDENTITY = 001010000000597 TEMPORARY MOBILE SUBSCRIBER IDENTITY = N ACTIVATION STATUS = A';

        analyze-string($input-string, '(.+?) = (S+)')//fn:match
        !
        <item>
        <paramName> normalize-space(fn:group[@nr = 1]) </paramName>
        <paramValue> normalize-space(fn:group[@nr = 2]) </paramValue>
        </item>






        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Nov 13 at 14:02









        Martin Honnen

        111k65876




        111k65876



























            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.





            Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


            Please pay close attention to the following guidance:


            • 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%2f53251470%2fparsing-text-to-xml-using-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

            Use pre created SQLite database for Android project in kotlin

            Darth Vader #20

            Ondo