Shell Programming and Scripting

hope this works

Code:

awk -F'>|<' '/BILL_NO/{printf $3}$2=="NAME"{if($3) {print ","$3}else {print ",NA"}}'

Hi yinyuemi,

Sorry to bother again.

Yes this worked except the last two rows. The output is now as below

Code:

1234,ABC
5678,BCA
1256,NA
3458934,PKL

The last two rows are coming together. The outpur should be as below:

Code:

1234,ABC
5678,BCA
1256,NA
345,NA
8934,PKL

As I mentioned before, the ending tag for the second last row is different from the previous tag where name is balnk. The tag is <NAME/> where as for the previous one is <NAME></NAME>. If I change <NAME/> to "<NAME></NAME>", it works fine. But it is not confirmed that the tag will always be complete xml tag. I might receive the xml ending tag (<NAME/>)only. I was also qurious to know what will happen, if no tag is sent.

Thanks
Angshuman

Code:

awk -F'>|<' '/BILL_NO/{printf $3","}/NAME[^I]/{if($3) {print ","$3}else {print ",NA"}}' file

Hi yinyuemi,

Thanks for your support and help. It is now working perfectly irrespective of the tag format. Will it work in case the tag is not passed at all ? What is the purpose of ^I ?

If it takes care of non existense of the tag, it did not give desired output.
I tried by removing NAME tag for one of the bill number and the putput is as below:

Code:

1234,ABC
5678,BCA
1256345,NA
8934,PKL

Thanks
Angsuman

Code:

/NAME[^I]/ means it will not match the word like "NAMEINFO". [^I] means the pattern without "I".

while(<DATA>){
if(/<BILL_NO>(\d+)<\/BILL_NO>/){
print "NA\n" if $flag;
print $1,",";
$flag = 1;
}
elsif(/<NAME>(.*?)<\/NAME>/){
$flag = 0;
my $tmp = ($1 eq "")?"NA":$1;
print $tmp,"\n";
}
}
__DATA__