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
asked Nov 11 at 17:44
mohamed abd ellatife
11
add a comment |
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
asked Nov 11 at 17:44
mohamed abd ellatife
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
add a comment |
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
asked Nov 11 at 17:44
mohamed abd ellatife
11
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
asked Nov 11 at 17:44
mohamed abd ellatife
11
asked Nov 11 at 17:44
mohamed abd ellatife
11
asked Nov 11 at 17:44
mohamed abd ellatife
11
asked Nov 11 at 17:44
mohamed abd ellatife
11
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
add a comment |
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
add a comment |
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>
answered Nov 13 at 14:02
Martin Honnen
110k65876
add a comment |
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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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>
answered Nov 13 at 14:02
Martin Honnen
110k65876
add a comment |
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>
answered Nov 13 at 14:02
Martin Honnen
110k65876
add a comment |
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>
answered Nov 13 at 14:02
Martin Honnen
110k65876
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>
answered Nov 13 at 14:02
Martin Honnen
110k65876
answered Nov 13 at 14:02
Martin Honnen
110k65876
answered Nov 13 at 14:02
Martin Honnen
110k65876
answered Nov 13 at 14:02
Martin Honnen
110k65876
110k65876
add a comment |
add a comment |
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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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
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