XML XQUERY: Having problems to write xml Structure including all tags into one record csv file
up vote
0
down vote
favorite
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
add a comment |
up vote
0
down vote
favorite
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
Can you show a minimal but complete XQuery sample allowing others to reproduce the problem?
– Martin Honnen
Nov 21 at 12:51
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
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
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
edited Nov 19 at 13:17
asked Nov 19 at 13:09
guido
11
11
Can you show a minimal but complete XQuery sample allowing others to reproduce the problem?
– Martin Honnen
Nov 21 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 at 12:51
Can you show a minimal but complete XQuery sample allowing others to reproduce the problem?
– Martin Honnen
Nov 21 at 12:51
Can you show a minimal but complete XQuery sample allowing others to reproduce the problem?
– Martin Honnen
Nov 21 at 12:51
add a comment |
active
oldest
votes
active
oldest
votes
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.
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.
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 at 12:51