Shell Programming and Scripting

F1    |######################                  |String1        |<XML><REQ><MSGTYPE>DBDIRECT</MSGTYPE><SYNC>0</SYNC><CLIENT>C11</CLIENT>NAME=MYNAME|JOB=MYJOB|
      |                                        |               |LOCATION=MYLOC|COUNTRY=MYCON|TECHNOLOGY
      |                                        |               |=XML</REQ></XML>

F1    |######################                  |String1        |<XML><REQ><MSGTYPE>DBDIRECT</MSGTYPE><SYNC>0</SYNC><CLIENT>C11</CLIENT>NAME=MYNAME|JOB=MYJOB|LOCATION=MYLOC|COUNTRY=MYCON|TECHNOLOGY=XML</REQ></XML>

sed -n '/<XML>.*<\/XML>/ s/.*\(<XML>.*<\/XML>\).*/\1/p' file

cut -f1 -d'|' in > field1.txt
cut -f2 -d'|' in > field2.txt
cut -f3 -d'|' in > field3.txt
cut -f4-99 -d'|' in > xmlfields.txt

touch fmtxml.txt
while read line
do
  COUNT_CLOSING_TAG=`echo $line|grep -c "</XML>"`
  if [ $COUNT_CLOSING_TAG -eq 0 ]
  then
    echo $line | tr -d "\n"  >> fmtxml.txt
  else
    echo $line >> fmtxml.txt
  fi
done < xmlfields.txt

  paste field1.txt field2.txt field3.txt xmlfields.txt > newfile.txt

#! /bin/bash

sed 's/      |                                        |               |//g' -i file.in
BUFFER=''
cat file.in | \
while read LINE
do
  if [ -n "$( echo $LINE | grep '#######' | grep '</XML>' )" ]
  then
    echo "$LINE" >> file.out
  else
    BUFFER=$( echo "$BUFFER$LINE" )
    if [ -n "$( echo $BUFFER | grep '#######' | grep '</XML>' )" ]
    then
      echo "$BUFFER" >> file.out
      BUFFER=''
    fi
  fi
done

exit 0

awk -F" +[|]" '{printf $0;getline;printf $4;getline;printf $4}' file