[Solved] Need help to convert single line xml file to sequential line

Discussion forum for all Windows batch related topics.

Moderator: DosItHelp

Post Reply
Message
Author
capiot23
Posts: 5
Joined: 10 Nov 2023 07:29

[Solved] Need help to convert single line xml file to sequential line

#1 Post by capiot23 » 10 Nov 2023 08:18

Hi everyone,

Can anyone help me write a code to convert xml file from single line to sequential line.

Let say I have this

data.xml (single line)

Code: Select all

<?xml version="1.0" encoding="UTF-8"?><Document xmlns="urn:iso:std:iso:20022:tech:xsd:sese.024.001.01"><SctiesSttlmTxStsAdvc><Id><Id>22052046</Id><CreDtTm><Dt>2023-11-10</Dt></CreDtTm></Id><TxId><AcctOwnrTxId>231110-001-428738</AcctOwnrTxId><CmonId>22052127</CmonId></TxId><MtchgSts><Umtchd><Rsn><Cd><Cd>CMIS</Cd></Cd></Rsn></Umtchd></MtchgSts></SctiesSttlmTxStsAdvc></Document>
I want to convert it as below without <?xml version...> and <Document...> at the start and </Document> at the end.

output.xml (sequential line)

Code: Select all

<SctiesSttlmTxStsAdvc>
<Id>
<Id>22052046</Id>
<CreDtTm>
<Dt>2023-11-10</Dt>
</CreDtTm>
</Id>
<TxId>
<AcctOwnrTxId>231110-001-428738</AcctOwnrTxId>
<CmonId>22052127</CmonId>
</TxId>
<MtchgSts>
<Umtchd>
<Rsn>
<Cd>
<Cd>CMIS</Cd>
</Cd>
</Rsn>
</Umtchd>
</MtchgSts>
</SctiesSttlmTxStsAdvc>
I know this is quite difficult, but I would greatly appreciate it if anyone could help me on this! :o
Last edited by capiot23 on 14 Nov 2023 09:41, edited 1 time in total.


Aacini
Expert
Posts: 1910
Joined: 06 Dec 2011 22:15
Location: México City, México
Contact:

Re: Need help to convert single line xml file to sequential line

#3 Post by Aacini » 11 Nov 2023 12:59

This works:

Code: Select all

@echo off
setlocal EnableDelayedExpansion

for /F "tokens=2* delims=>" %%a in (data.xml) do set "line=%%b"
set "next="
(for /F %%a in (^"!line:^>^<^=^>^
% Do NOT remove this line %
^<!^") do (
   if defined next echo !next!
   set "next=%%a"
)) > output.xml
Antonio

capiot23
Posts: 5
Joined: 10 Nov 2023 07:29

Re: Need help to convert single line xml file to sequential line

#4 Post by capiot23 » 13 Nov 2023 01:07

Squashman wrote:
10 Nov 2023 15:51
This should get you started.
https://stackoverflow.com/questions/330 ... t-them-out
Hey thanks, but this doesn't skip the first 2 tags and I don't want it to be format like this

Code: Select all

<xml>
     <tag>
          <othertag>
          </othertag>
     </tag>
</xml>
Aacini wrote:
11 Nov 2023 12:59
This works:

Code: Select all

@echo off
setlocal EnableDelayedExpansion

for /F "tokens=2* delims=>" %%a in (data.xml) do set "line=%%b"
set "next="
(for /F %%a in (^"!line:^>^<^=^>^
% Do NOT remove this line %
^<!^") do (
   if defined next echo !next!
   set "next=%%a"
)) > output.xml
Antonio
This works great for short length data as my example input.txt above! Thanks!
But if I tested on my actual data 262kb of file size, it doesn't work, I only get the output as "><=>"
Is it because character limitation? Attached my actual data if you or anyone can help me figure it out.
Attachments
input_notwork.xml
(261.62 KiB) Downloaded 696 times

Aacini
Expert
Posts: 1910
Joined: 06 Dec 2011 22:15
Location: México City, México
Contact:

Re: Need help to convert single line xml file to sequential line

#5 Post by Aacini » 13 Nov 2023 05:41

The very first post in this site is How to get help for a batch script - quickly!, so surely you should saw it... Did you read it already? In such a post, there are these phrases:
foxidrive wrote:
08 Dec 2014 05:51
Batch files are often specific to your task because your filepaths, text, filenames and data are often used to write code that is both simpler and more efficient.

It makes it easy for people if you provide accurate details. The script you are given is designed to work in your specific situation and they will often add extra code to handle aspects that you may not have thought of...

If you hide your details... LIKE AN UNUSUAL LARGE FILE SIZE then nobody knows that... In these situations the volunteers can't include appropriate code to handle your special situations because they aren't aware you need it.

By providing poor information about your task the code you are given stands a good chance of failing.

...

Please show respect to those people who give their free time to provide you with code by giving them accurate information about your task.
foxidrive wrote:
28 Jul 2016 03:01
What happens in a thread when incorrect or poor details are supplied: is that the volunteers write a script based upon that information and the next post often comes from the question writer saying "It doesn't work!"

Often a very long series of posts begins where we try to ascertain what the problem is and how the code fails and then what the real details of the task are. The script has to be rewritten, and that just wastes the time of those volunteers who are giving you free code and it is terribly frustrating and unsatisfying for volunteers to have to re-write a script for the same task again.

Don't do this.

Processing a data file with a single line larger than 8 KB is a major challenge for a Batch file.

It could be done, but the solution will take some time...

Antonio

Aacini
Expert
Posts: 1910
Joined: 06 Dec 2011 22:15
Location: México City, México
Contact:

Re: Need help to convert single line xml file to sequential line

#6 Post by Aacini » 13 Nov 2023 07:06

Ok. This new code correctly works with the 262 KB size file. My first attempt fails because I assumed that no value could have a space!

Code: Select all

@echo off
setlocal EnableDelayedExpansion

set "n=0"
set "last="
call :processLine < data.xml > output.xml
goto :EOF


:processLine

set /P "line="
set "line=!last!!line!"
for /F "delims=" %%a in (^"!line:^>^<^=^>^
% Do NOT remove this line %
^<!^") do (
   set /A n+=1
   if !n! gtr 3 echo !last!
   set "last=%%a"
)
set "n=2"
if "!last!" neq "</Document>" goto processLine
exit /B
The program generated an output.xml file with 21668 lines...

Antonio

capiot23
Posts: 5
Joined: 10 Nov 2023 07:29

Re: Need help to convert single line xml file to sequential line

#7 Post by capiot23 » 14 Nov 2023 09:01

Sir, apologize for my overlooked on the rules. I'm just worry I'd leak out some private information from the actual data, but after read by lines, there's nothing much to worry.
Aacini wrote:
13 Nov 2023 07:06
Ok. This new code correctly works with the 262 KB size file. My first attempt fails because I assumed that no value could have a space!

Code: Select all

@echo off
setlocal EnableDelayedExpansion

set "n=0"
set "last="
call :processLine < data.xml > output.xml
goto :EOF


:processLine

set /P "line="
set "line=!last!!line!"
for /F "delims=" %%a in (^"!line:^>^<^=^>^
% Do NOT remove this line %
^<!^") do (
   set /A n+=1
   if !n! gtr 3 echo !last!
   set "last=%%a"
)
set "n=2"
if "!last!" neq "</Document>" goto processLine
exit /B
The program generated an output.xml file with 21668 lines...

Antonio
Bravo!!! This works perfectly as I wanted even for larger file size.
Thank you so much for your time, sir. I've put your name in my batch file credit to you for coding this.
I'll learn from the code although it's short, but no doubt it's kind of unreadable for my current level :o

Squashman
Expert
Posts: 4484
Joined: 23 Dec 2011 13:59

Re: Need help to convert single line xml file to sequential line

#8 Post by Squashman » 16 Nov 2023 11:38

capiot23 wrote:
13 Nov 2023 01:07
Squashman wrote:
10 Nov 2023 15:51
This should get you started.
https://stackoverflow.com/questions/330 ... t-them-out
Hey thanks, but this doesn't skip the first 2 tags and I don't want it to be format like this

Code: Select all

<xml>
     <tag>
          <othertag>
          </othertag>
     </tag>
</xml>
Wasn't meant to be the exact code. Since you provided no attempt at coding a solution, at the very least I gave you a starting point to adapt the code.

Post Reply