Shell Programming and Scripting

vgersh99,
Since you gave the input as a text file, the output that you got was correct. Instead of using the text file, I used the csv file as under :

pj.csv file
---------
"Store Number", "Quarter 1 Sales", "Quarter 2 Sales", "Quarter 3 Sales", "Quarter 4 Sales"

"1", "35%", "29%", "59%", "42%"
"2", "61%", "37%", "34%", "86%"
"3", "68%", "47%", "62%", "18%"
"4", "78%", "83%", "91%", "78%"
"5", "53%", "44%", "67%", "56%"

pj.awk file
----------
BEGIN {OFS = "\n"}
NR == 1 {for (i = 1; i <=NF; i++)
tag[i]=$i
print "<" node "XML>"}
NR != 1 {print " <" node ">"
for (i = 1; i <= NF; i++)
print " <" tag[i] ">" $i "</" tag[i] ">"
print " </" node ">"}
END {print "</" node "XML>"}

Script Execution Command
-------------------------

nawk -v node=whatever -f pj.awk pj.csv

Output :
--------

<whateverXML>
<whatever>
</whatever>
<whatever>
<"Store>"1",</"Store>
<Number",>"35%",</Number",>
<"Quarter>"29%",</"Quarter>
<1>"59%",</1>
<Sales",>"42%"</Sales",>
</whatever>
<whatever>
<"Store>"2",</"Store>
<Number",>"61%",</Number",>
<"Quarter>"37%",</"Quarter>
<1>"34%",</1>
<Sales",>"86%"</Sales",>
</whatever>
<whatever>
<"Store>"3",</"Store>
<Number",>"68%",</Number",>
<"Quarter>"47%",</"Quarter>
<1>"62%",</1>
<Sales",>"18%"</Sales",>
</whatever>
<whatever>
<"Store>"4",</"Store>
<Number",>"78%",</Number",>
<"Quarter>"83%",</"Quarter>
<1>"91%",</1>
<Sales",>"78%"</Sales",>
</whatever>
<whatever>
<"Store>"5",</"Store>
<Number",>"53%",</Number",>
<"Quarter>"44%",</"Quarter>
<1>"67%",</1>
<Sales",>"56%"</Sales",>
</whatever>
</whateverXML>

Also, please could you explain me the steps, Sir, so I can understand better.

Thanks once again for your help.

pjanakir

Sir,
I need the Input file to be a .CSV file so that I could get the proper output. Could you please help me?

Thanks,
pjanakir

assuming you don't have any embedded commas within the quoted fields.....

pj.awk

Code:

BEGIN {FS=",";OFS = "\n"}
NR == 1 {for (i = 1; i <=NF; i++)
            tag[i]=$i
         print "<" node "XML>"}
NR != 1 {print "   <" node ">"
         for (i = 1; i <= NF; i++)
            print "      <" tag[i] ">" $i "</" tag[i] ">"
         print "   </" node ">"}
END {print "</" node "XML>"}

Sir,
I don't have words to thank you. But I want to understand it, so I can explain it to my supervisor. Can you go ahead and explain the .awk script and the execution command too? I would appreciate if you could do so? I thought awk was just a command used to search for patterns, but never knew that we could also use for file conversion. I really did not understand, what you meant by FS, OFS, NR, NF, node etc. Can you please go thru in detail step by step?

I really thank you once again.

Thanks,
pjanakir

Code:

BEGIN {
      # input Field Separator set to ','
   FS=",";
      # output Field Separator set to '\n' [new line]
   OFS = "\n"}

NR == 1 {
            # for the FIRST record/line in a file - iterate though the fields 
            # from '1' to 'NF' [NF stands for 'Number_of_Fields'
         for (i = 1; i <=NF; i++)
                # populate an array 'tag' indexed by the field NUMBER with the
                # VALUE of the field - here're we're reading the HEADERS
            tag[i]=$i

             # print the BEGINNING of the XML document tagged with the value
             # with the value of the variable 'node' passed into the script
         print "<" node "XML>"
}
   # for the other records/lines - other than the FIRST line.....
NR != 1 {
             # this is the BEGINNING of the of the XML record
         print "   <" node ">"
             # iterate though the fields........ "i" is the iterator
         for (i = 1; i <= NF; i++)
              # outputing the header for this field "tag[i]" and the VALUE of this
              # of this field "$i"
            print "      <" tag[i] ">" $i "</" tag[i] ">"

            # this is the END of the XML record
         print "   </" node ">"}
    # at the end of the file processing CLOSE the entire XML document
END {
   print "</" node "XML>"
}

do 'man nawk' for the meaning of the builtin variables [FS, OFS, NF etc...] and the syntax of the language.

Thanks a lot.

Hi vgersh99,
Assuming that we don't know what the name of the jar file, we are searching for is, do we have any way, of finding a string or a file in it. Is there any Unix command for it?

thanks.