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






xml xquery







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






xml xquery







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






xml xquery







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




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

        110k65876




        110k65876






























            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

            Full-time equivalent

            Image
            Full-time equivalent From Wikipedia, the free encyclopedia Jump to navigation Jump to search Full-time equivalent ( FTE ) or whole time equivalent ( WTE ) is a unit that indicates the workload of an employed person (or student) in a way that makes workloads or class loads comparable [1] across various contexts. FTE is often used to measure a worker's or student's involvement in a project, or to track cost reductions in an organization. An FTE of 1.0 is equivalent to a full-time worker or student, while an FTE of 0.5 signals half of a full work or school load. [2] Contents 1 U.S. Federal Government 2 In education 2.1 Example 3 Notes 4 References U.S. Federal Government [ edit ] In the U.S. Federal Government, FTE is defined by the Government Accountability Office (GAO) as the number of total hours worked divided by the maximum number of compensable hours in a full-time schedule as
            Read more

            Bicuculline

            Image
            Bicuculline From Wikipedia, the free encyclopedia Jump to navigation Jump to search Bicuculline Clinical data ATC code none Identifiers IUPAC name (6 R )-​6-​[(5 S )-​6-​methyl-​5,​6,​7,​8-​tetrahydro​[1,3]dioxolo​[4,5- g ]​isoquinolin-​5-​yl]​furo[3,4- e ]​[1,3]​benzodioxol-​8(6 H )-​one CAS Number 485-49-4   Y PubChem CID 10237 IUPHAR/BPS 2312 ChemSpider 9820   Y UNII Y37615DVKC ChEBI CHEBI:3092   N ChEMBL ChEMBL417990   N ECHA InfoCard 100.006.927 Chemical and physical data Formula C 20 H 17 N O 6 Molar mass 367.352 g/mol 3D model (JSmol) Interactive image Melting point 215 °C (419 °F) SMILES O=C1O[C@H](c3c1c2OCOc2cc3)[C@@H]5c4cc6OCOc6cc4CCN5C InChI InChI=1S/C20H17NO6/c1-21-5-4-10-6-14-15(25-8-24-14)7-12(10)17(21)18-11-2-3-13-19(26-9-23-13)16(11)20(22)27-18/h2-3,6-7,17-18H,4-5,8-9H2,1H3/t17-,18+/m0/s1   Y Key:IYGYMKDQCDOMRE-ZWKOTPCHSA-N
            Read more

            What is this shape that looks like a rectangle with rounded ends called?

            Image
            18 2 This cannot be a rounded rectangle because those are not fully or "perfectly" rounded at the two ends. This is more like an elongated circle? A flat cylinder? I searched a lot, but among all guides or pictures that identify and name different shapes, I couldn't get this particular shape. The closest I could get was a stretched ellipse. There are only two processes to get this shape as far as I know: the first one is making a long rectangle and making its corner radius exactly half of the height. The second one is putting two circles a distance apart and adding a rectangle between those. So, are these something like "perfect rounded rectangles" or "rectangular circles"? shapes terminology
            Read more