XML XQUERY: Having problems to write xml Structure including all tags into one record csv file
I am currently struggling with the output of an xml structure into a flat file:
The requirement is to get some information using xquery from the XML into a "@" separated file.
In one "column" the complete record structure with all information including tags is requested. I am somehow able to extract the information but after each tag a line feed is being added.
While using the same xquery and displaying it (within the BaseX GUI I am using) no line feeds are shown.
I tried using
"write", "append", "serialize" etc., but somehow I seem to forget a special output option.
declare option output:method "text";
declare option output:item-separator "";
declare option output:omit-xml-declaration "no";
declare option output:indent "no";
declare option output:media-type "text/plain";
.... file:append($delFile1, ....)
Current Output (Contains Line feeds):3959 @ "BLA, BLA" @ -0- @ "XYZ" @ "ABC" @ "BE" @ -0- @ "" @ @ -0- @@ "<entity id="4321" version="20170601140252">
<name>BLA, BLA</name>
<listId>29</listId>
<listCode>XY</listCode>
<entityType>03</entityType>
...
<sdf name="OtherInformation">Please refer to q.a.section.</sdf>
</entity>" @ -0- @ @ "LAZY"
Expected Result (ONE Row):3959 @ "BLA, BLA" @ -0- @ "XYZ" @ "ABC" @ "BE" @ -0- @ "" @ @ -0- @ @ **"<entity id="4321"version="20170601140252"><name>BLA,BLA</name><listId>29</listId><listCode>XY</listCode><entityType>03</entityType>...<sdfname="OtherInformation">Please refer to q.a.section.</sdf></entity>"** @ -0- @ @ "LAZY"
Thanks for your support
xml xquery basex
asked Nov 19 '18 at 13:09
guidoguido
11
add a comment |
I am currently struggling with the output of an xml structure into a flat file:
The requirement is to get some information using xquery from the XML into a "@" separated file.
In one "column" the complete record structure with all information including tags is requested. I am somehow able to extract the information but after each tag a line feed is being added.
While using the same xquery and displaying it (within the BaseX GUI I am using) no line feeds are shown.
I tried using
"write", "append", "serialize" etc., but somehow I seem to forget a special output option.
declare option output:method "text";
declare option output:item-separator "";
declare option output:omit-xml-declaration "no";
declare option output:indent "no";
declare option output:media-type "text/plain";
.... file:append($delFile1, ....)
Current Output (Contains Line feeds):3959 @ "BLA, BLA" @ -0- @ "XYZ" @ "ABC" @ "BE" @ -0- @ "" @ @ -0- @@ "<entity id="4321" version="20170601140252">
<name>BLA, BLA</name>
<listId>29</listId>
<listCode>XY</listCode>
<entityType>03</entityType>
...
<sdf name="OtherInformation">Please refer to q.a.section.</sdf>
</entity>" @ -0- @ @ "LAZY"
Expected Result (ONE Row):3959 @ "BLA, BLA" @ -0- @ "XYZ" @ "ABC" @ "BE" @ -0- @ "" @ @ -0- @ @ **"<entity id="4321"version="20170601140252"><name>BLA,BLA</name><listId>29</listId><listCode>XY</listCode><entityType>03</entityType>...<sdfname="OtherInformation">Please refer to q.a.section.</sdf></entity>"** @ -0- @ @ "LAZY"
Thanks for your support
xml xquery basex
asked Nov 19 '18 at 13:09
guidoguido
11
Can you show a minimal but complete XQuery sample allowing others to reproduce the problem?
– Martin Honnen
Nov 21 '18 at 12:51
add a comment |
I am currently struggling with the output of an xml structure into a flat file:
The requirement is to get some information using xquery from the XML into a "@" separated file.
In one "column" the complete record structure with all information including tags is requested. I am somehow able to extract the information but after each tag a line feed is being added.
While using the same xquery and displaying it (within the BaseX GUI I am using) no line feeds are shown.
I tried using
"write", "append", "serialize" etc., but somehow I seem to forget a special output option.
declare option output:method "text";
declare option output:item-separator "";
declare option output:omit-xml-declaration "no";
declare option output:indent "no";
declare option output:media-type "text/plain";
.... file:append($delFile1, ....)
Current Output (Contains Line feeds):3959 @ "BLA, BLA" @ -0- @ "XYZ" @ "ABC" @ "BE" @ -0- @ "" @ @ -0- @@ "<entity id="4321" version="20170601140252">
<name>BLA, BLA</name>
<listId>29</listId>
<listCode>XY</listCode>
<entityType>03</entityType>
...
<sdf name="OtherInformation">Please refer to q.a.section.</sdf>
</entity>" @ -0- @ @ "LAZY"
Expected Result (ONE Row):3959 @ "BLA, BLA" @ -0- @ "XYZ" @ "ABC" @ "BE" @ -0- @ "" @ @ -0- @ @ **"<entity id="4321"version="20170601140252"><name>BLA,BLA</name><listId>29</listId><listCode>XY</listCode><entityType>03</entityType>...<sdfname="OtherInformation">Please refer to q.a.section.</sdf></entity>"** @ -0- @ @ "LAZY"
Thanks for your support
xml xquery basex
asked Nov 19 '18 at 13:09
guidoguido
11
I am currently struggling with the output of an xml structure into a flat file:
The requirement is to get some information using xquery from the XML into a "@" separated file.
In one "column" the complete record structure with all information including tags is requested. I am somehow able to extract the information but after each tag a line feed is being added.
While using the same xquery and displaying it (within the BaseX GUI I am using) no line feeds are shown.
I tried using
"write", "append", "serialize" etc., but somehow I seem to forget a special output option.
declare option output:method "text";
declare option output:item-separator "";
declare option output:omit-xml-declaration "no";
declare option output:indent "no";
declare option output:media-type "text/plain";
.... file:append($delFile1, ....)
Current Output (Contains Line feeds):3959 @ "BLA, BLA" @ -0- @ "XYZ" @ "ABC" @ "BE" @ -0- @ "" @ @ -0- @@ "<entity id="4321" version="20170601140252">
<name>BLA, BLA</name>
<listId>29</listId>
<listCode>XY</listCode>
<entityType>03</entityType>
...
<sdf name="OtherInformation">Please refer to q.a.section.</sdf>
</entity>" @ -0- @ @ "LAZY"
Expected Result (ONE Row):3959 @ "BLA, BLA" @ -0- @ "XYZ" @ "ABC" @ "BE" @ -0- @ "" @ @ -0- @ @ **"<entity id="4321"version="20170601140252"><name>BLA,BLA</name><listId>29</listId><listCode>XY</listCode><entityType>03</entityType>...<sdfname="OtherInformation">Please refer to q.a.section.</sdf></entity>"** @ -0- @ @ "LAZY"
Thanks for your support
xml xquery basex
xml xquery basex
asked Nov 19 '18 at 13:09
guidoguido
11
asked Nov 19 '18 at 13:09
guidoguido
11
edited Nov 19 '18 at 13:17
guido
asked Nov 19 '18 at 13:09
guidoguido
11
asked Nov 19 '18 at 13:09
guidoguido
11
asked Nov 19 '18 at 13:09
guidoguido
11
11
Can you show a minimal but complete XQuery sample allowing others to reproduce the problem?
– Martin Honnen
Nov 21 '18 at 12:51
add a comment |
Can you show a minimal but complete XQuery sample allowing others to reproduce the problem?
– Martin Honnen
Nov 21 '18 at 12:51
Can you show a minimal but complete XQuery sample allowing others to reproduce the problem?
– Martin Honnen
Nov 21 '18 at 12:51
Can you show a minimal but complete XQuery sample allowing others to reproduce the problem?
– Martin Honnen
Nov 21 '18 at 12:51
add a comment |
0
active
oldest
votes
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
});
}
});
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%2f53375366%2fxml-xquery-having-problems-to-write-xml-structure-including-all-tags-into-one-r%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
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%2f53375366%2fxml-xquery-having-problems-to-write-xml-structure-including-all-tags-into-one-r%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
Can you show a minimal but complete XQuery sample allowing others to reproduce the problem?
– Martin Honnen
Nov 21 '18 at 12:51