Shell Programming and Scripting

Hello everyone,

Firstly i do not require alot of help.. i am right at the end of finishing my scipt but cannot find a solution to the last part.

What i need to do is, prompt the user for a file to work with, which i have done.
promt the user for an output file - which is done.

Code:

#!/bin/bash
echo "Get my XML"
echo -n "Enter the source file name : "
read infile
echo -n "Enter output file name : "
read outfile
sed -n 1433,1615p $infile >> $outfile
echo "Data should be in $outfile if this compiled correctly"

The file, is .txt and is massive, i only need the last 200 lines or so which is XML... I know i can use SED to specify what line numbers to extract to the output file, but not all documents that use this script will require the last 200, it could be the midlle 50.

Which leads me on to my problem, using SED or AWK i would like to extract all the xml after 'Sending XML' which is consistant accross all documents, up until the words ' Message sending ended.'

I have been reading various articles/forums which have helped and has lead me to providing my current example. Although, using line numbers is not feasible, they will differ accross the documents, whereas the words above are always present.

I really hope someone can help as i have spent far too much time on this!

Thanks!

H

Code:

sed -n '/Sending XML/,/Message sending ended/p' ${infile} > ${outfile}

I cannot thank you enough.. i have posted on so many forums and no one ever gets back to me! I will be using this more often!

I now have another issue, The XML i have been left with has line breaks, see below:

Code:

 Sending XML          :

 <document> <docRequestID>2010-10-22-11.57.22.903813</docRequestID><docStylesh

 eet>Thunderhead</docStylesheet><requestType>claim</requestType><level0Object>

  <objectType>transaction</objectType><objectID>900</objectID><objectSeq>1</ob
 Line break has effected tag
 jectSeq><level1Object> <objectType>lifelite</objectType><objectID>901</object

As you can see, the line break has effected this tag half is on the line below and this XML cannot be used like that. I would like for it to remove the linespaces at the start of the line, looking like : </object>

Thank you so much for your help!!

Code:

nawk '/Sending XML/,/Message sending ended/' ${infile} | nawk 'NF && /^ *</{printf("%s%c", $0, (/ *<.*>$/)?ORS:"");next}NF' > ${outfile}

Thank you so much, i will try it shortly! I dont have to install nawk do i? is it standard tech?



---------- Post updated at 07:43 PM ---------- Previous update was at 05:11 PM ----------




I tried running that code you gave me and i get an error saying that it cannot revert the file... Unexpected error: Invalid UTF-8 sequence in input.

Im having a look online to see what that means. If you have any ideas let me kno.

cheers

What OS are you on?
If you have nawk/gawk - use either one.

im on ubuntu... i tried using nawk and gawk.. didnt work!



---------- Post updated at 09:01 PM ---------- Previous update was at 08:48 PM ----------




i have tried using nawk and gawk and no luck. i am running ubuntu and the awk is 3.1.6