era: Thanks for the solution! I won't wreck anything because all that the following process does is extract 17 arguments where it knows the tags..The tags with spaces are useless to me but are causing an erorr...I can't use an XML parser because I don't have the correct perl package. The solution you proposed works great but i am having a small problem now:
Here's part of my script:
Basically when the script detects the end of a an xml document. It sends whatever it has recovered from the strFile concatenated with 'line' (i.e. everything before the the </document> including it). My problem arises when i have spaces between the text. The "line" function, when it finds a space it is concatinating it into strFile, the problem is it eliminates the space. (strFile = $strFile$line #the space is lost). Now, after solving the <ta g> spaces, I need a way the line will ignore the <tag>My Coments</tag> mid space and accept it so the overall strFile contains that space. The batch that receives the document cannot handle spaces between tag and tag but it CAN handle spaces within the tags...
Any suggestions as to what I can do? A replacement for line?
A typical xml doc i receive is:
The line function, when it arrives at the tag DMSObjectSubType the Audio Contract turns into AudioContract in the strFile.
Another problem is the script should also be prepared to receive the XML's with spaces between the tags (</document> </documents>) and also with line terminators (</document>
</documents>)
basically the XML shown is the ideal format. I could pass that directly onto my parser and it would work provided the spaces between the <> where removed (which was done with the perl script era provided). Problem comes as i mentioned before, when i have spaces or \n between tags..
Could you rephrase what the problem is, and please edit your posting to add markup so that the code fits on one screen -- it's quite unreadable as it is now.
You are not quoting your arguments properly. I'm not sure if this will help but try adding double quotes around every variable reference. Like replace $strFile with "$strFile" throughout, and ditto for other variables.
Your case statement appears to have invalid syntax. That should be something like "case $line in " rather than just "case".
My problem is my batch file needs the format as follows:
1) No spaces within XML tags (your perl script did the job)
2) No spaces between an XML tag and another (</DMSObject> <DMSType> is not accepted yet </DMSObject><DMSType> is.)
3) Spaces allowed within XML inital and final tag (<DMSObject>Hello there</DMSObject>)
Right now 1 and 2 are being done, but 3 keeps on failing, and if i solve 3 then 1 and 2 are not solved
The XML file that i receive has multiple <document> 's within it, the batch process will process all of them provided they have no spaces between the tags.. but if the have tabs or spaces or \n's it fails..
I have a XML file given as below:
"<ProductUOMAlternativeDetails>
<removetag>
<UOMCode>EA</UOMCode>
<numeratorForConversionToBaseUOM>1</numeratorForConversionToBaseUOM>
<denominatorForConversionToBaseUOM>1</denominatorForConversionToBaseUOM>
<length>0.59</length>
<width>0.96</width> ... (3 Replies)
Hi,
To comply with a new naming convention on a mediawiki site we have to run a SED or other PERL command to change all instances of
] or ] or ]
to
]
Can someone please explain how to do this...
It has to be done on a mysql dump, so if there is a way to do this in mysql even... (2 Replies)
Hello All,
I am trying to remove all tabspaces and all blankspaces from my file using sed & awk, but not getting proper code. Please help me out.
My file is like this (<b> means one blank space, <t> means one tab space)-
$ cat file
NARESH<b><b><b>KUMAR<t><t>PRADHAN... (3 Replies)
Hi,
I have a input xml file like this
<postalAddress:>379 PROSPECT ST </postalAddress:>
<street:>STE B </street:>
<l:>TORRINGTON </l:>
<st:>CT</st:>
<postalCode:>067905238</postalCode:>... (5 Replies)
Hey,
I'm using the command from this thread https://www.unix.com/unix-dummies-questions-answers/590-converting-list-into-line.html
to convert vertical lines to horzontal lines. But I need to remove the spaces that is created. Unfortunately I can't figure out where the space is in the code..
I... (2 Replies)
hey..
i had a problem with the unix command when i want to remove the white spaces in a string..i guess i cud do it with a sed command but i get an error when i give space in the square brackets..
string="nh hjh llk"
p=`echo $string | sed 's/ //g'`
i donno how to give space charater and... (2 Replies)
I have a file with delimiter ~
ABC~12~43~TR ~890~poi~YU ~56~65
What I want is to remove spaces from column 4,7 and other columns as it is
So, the final file becomes
ABC~12~43~TR~890~poi~YU~56~65 (7 Replies)
Hi Everyone,
I am having problem to delete an "empty" folder ( messages attached ).
It displays "total 12" when i typed "ls -lart" on the fnxroot44 folder, but i can't view any file.
Is there any way to view those unseen files ? I don't know why option "a" is not working this time.
Would... (1 Reply)
I am having xml document as below.
<transactionid>
00
</transactionid>
<tracknumber>
0
</tracknumber>
<key>
N/A
</key>
But the data contains leading and trailing spaces between the tags. Please let me know how can i remove these leading and trailing spaces between the tags.... (2 Replies)