Shell Programming and Scripting

if [ $# -ne 1 ]
then 
	   echo ""
       echo "Wrong syntax, Databse_update.sh <Input_File.csv>"
       echo ""
       exit 0
fi 

rm Database.xml 1>/dev/null 2>&1
echo ""
echo "Creating XML files"
gawk -F ',' '

	BEGIN {} 

		      {#if (print_ok == 0) {
				print "    <Name=\""$1"\">" > "Database.xml"
				#print_ok=1
			  #}		  
			  print "              		<es:"$2">"$3"</es:"$2"> " > "Database.xml"
			 }' $1

if [ -f "Databse.xml" ]
		then
			echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>" > tmp1.txt
			echo "   <fileFooter dateTime=\""`date`"\" />" >> tmp2.txt
			cat tmp1.txt Databse.xml tmp2.txt > tmp3.txt
			mv tmp3.txt "`date`"_Databse.xml
			rm tmp1.txt tmp2.txt 1>/dev/null 2>&1
			rm Database.xml
			echo ""
			echo "File \""`date`"_Database.xml\" created "
			echo ""
fi

Name	Identity	Identity No
XYZ	PIN	5678
LKY	PIN	234

    <Name="Name">
              		<es:Identity>Identity No
</es:Identity> 
    <Name="XYZ">
              		<es:PIN>5678
</es:PIN> 
    <Name="LKY">
              		<es:PIN>234
</es:PIN>

 <Name="Name">
              		<es:Identity>Identity No</es:Identity> 
    <Name="XYZ">
              		<es:PIN>5678</es:PIN> 
    <Name="LKY">
              		<es:PIN>234</es:PIN>

gawk -F ',' '

	BEGIN {}

gawk -F '\t' '

Name,Identity,Identity No
XYZ,PIN,5678
LKY,pin,234

<es:PIN>234
</es:PIN>

<es:PIN>234</es:PIN>

od -bc input_file

od -bc sample.csv
0000000 116 141 155 145 054 111 144 145 156 164 151 164 171 054 111 144
          N   a   m   e   ,   I   d   e   n   t   i   t   y   ,   I   d
0000020 145 156 164 151 164 171 040 116 157 015 012 130 131 132 054 120
          e   n   t   i   t   y       N   o  \r  \n   X   Y   Z   ,   P
0000040 111 116 054 065 066 067 070 015 012 114 113 131 054 120 111 116
          I   N   ,   5   6   7   8  \r  \n   L   K   Y   ,   P   I   N
0000060 054 062 063 064 015 012
          ,   2   3   4  \r  \n
0000066

tr -d '\r' < oldfile > newfile