Shell Programming and Scripting

And what is that "....." actually supposed to be?

The awk code goes like the below, (input.txt and output.txt is provided below). The output prints the same XML four times. The first XML only contains the valid values from the input and the remaining three XML files are printed with no valid values. I am not sure why the awk script writes four XML's to the output. The command I use for executing the awk is as follows,

awk -f test.awk input.txt > output.txt

input.txt
********

2012-01,S27,GC00000T

test.awk:
**********

BEGIN{
FS=",";
requestID=100;
ORS="";
}{
requestID=requestID+1;
print "<?xml version=\"1.0\" encoding=\"UTF-8\"?><TCRMService xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:noNamespaceSchemaLocation=\"CMSRequest.xsd\"><RequestControl><requestID>"requestID"</requestID><DWLControl><requesterName>Automated Cleanup TC1</requesterName><requesterLanguage>100</requesterLanguage><clientTransactionName>"$1"</clientTransactionName></DWLControl></RequestControl>";
print "<TCRMTx><TCRMTxType>maintainGlobalClientHierarchy</TCRMTxType><TCRMTxObject>TCRMContractBObj</TCRMTxObject><TCRMObject><TCRMContractBObj><CurrencyType>1</CurrencyType><AgreementName>Moretti New GC</AgreementName><AgreementNickName></AgreementNickName><AgreementStatusType>1000002</AgreementStatusType><AgreementType>1000002</AgreementType>";
print "<TCRMExtension><ExtendedObject>CMSContractBObjExt</ExtendedObject><CMSContractBObjExt><ClientGenType>1000002</ClientGenType></CMSContractBObjExt></TCRMExtension><TCRMContractComponentBObj><ContractStatusType>1000001</ContractStatusType><TCRMContractPartyRoleBObj><RoleType>1000001</RoleType><TCRMOrganizationBObj>";
print "<TCRMAdminContEquivBObj><AdminPartyId>"$2"</AdminPartyId><AdminSystemType>1000001</AdminSystemType></TCRMAdminContEquivBObj></TCRMOrganizationBObj></TCRMContractPartyRoleBObj></TCRMContractComponentBObj><TCRMAdminNativeKeyBObj><AdminContractId>"$3"</AdminContractId><AdminFieldNameType>1000001</AdminFieldNameType></TCRMAdminNativeKeyBObj></TCRMContractBObj></TCRMObject></TCRMTx></TCRMService>\n";
}
END {

}

output.txt:
*********

<?xml version="1.0" encoding="UTF-8"?><TCRMService xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="CMSRequest.xsd"><RequestControl><requestID>101</requestID><DWLControl><requesterName>Automated Cleanup TC1</requesterName><requesterLanguage>100</requesterLanguage><clientTransactionName>2012-01</clientTransactionName></DWLControl></RequestControl><TCRMTx><TCRMTxType>maintainGlobalClientHierarchy</TCRMTxType><TCRMTxObject>TCRMContractBObj</TCRMTxObject><TCRMObject><TCRMContractBObj><CurrencyType>1</CurrencyType><AgreementName>Moretti New GC</AgreementName><AgreementNickName></AgreementNickName><AgreementStatusType>1000002</AgreementStatusType><AgreementType>1000002</AgreementType><TCRMExtension><ExtendedObject>CMSContractBObjExt</ExtendedObject><CMSContractBObjExt><ClientGenType>1000002</ClientGenType></CMSContractBObjExt></TCRMExtension><TCRMContractComponentBObj><ContractStatusType>1000001</ContractStatusType><TCRMContractPartyRoleBObj><RoleType>1000001</RoleType><TCRMOrganizationBObj><TCRMAdminContEquivBObj><AdminPartyId>S27</AdminPartyId><AdminSystemType>1000001</AdminSystemType></TCRMAdminContEquivBObj></TCRMOrganizationBObj></TCRMContractPartyRoleBObj></TCRMContractComponentBObj><TCRMAdminNativeKeyBObj><AdminContractId>GC00000T</AdminContractId><AdminFieldNameType>1000001</AdminFieldNameType></TCRMAdminNativeKeyBObj></TCRMContractBObj></TCRMObject></TCRMTx></TCRMService>



<?xml version="1.0" encoding="UTF-8"?><TCRMService xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="CMSRequest.xsd"><RequestControl><requestID>102</requestID><DWLControl><requesterName>Automated Cleanup TC1</requesterName><requesterLanguage>100</requesterLanguage><clientTransactionName></clientTransactionName></DWLControl></RequestControl><TCRMTx><TCRMTxType>maintainGlobalClientHierarchy</TCRMTxType><TCRMTxObject>TCRMContractBObj</TCRMTxObject><TCRMObject><TCRMContractBObj><CurrencyType>1</CurrencyType><AgreementName>Moretti New GC</AgreementName><AgreementNickName></AgreementNickName><AgreementStatusType>1000002</AgreementStatusType><AgreementType>1000002</AgreementType><TCRMExtension><ExtendedObject>CMSContractBObjExt</ExtendedObject><CMSContractBObjExt><ClientGenType>1000002</ClientGenType></CMSContractBObjExt></TCRMExtension><TCRMContractComponentBObj><ContractStatusType>1000001</ContractStatusType><TCRMContractPartyRoleBObj><RoleType>1000001</RoleType><TCRMOrganizationBObj><TCRMAdminContEquivBObj><AdminPartyId></AdminPartyId><AdminSystemType>1000001</AdminSystemType></TCRMAdminContEquivBObj></TCRMOrganizationBObj></TCRMContractPartyRoleBObj></TCRMContractComponentBObj><TCRMAdminNativeKeyBObj><AdminContractId></AdminContractId><AdminFieldNameType>1000001</AdminFieldNameType></TCRMAdminNativeKeyBObj></TCRMContractBObj></TCRMObject></TCRMTx></TCRMService>


<?xml version="1.0" encoding="UTF-8"?><TCRMService xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="CMSRequest.xsd"><RequestControl><requestID>103</requestID><DWLControl><requesterName>Automated Cleanup TC1</requesterName><requesterLanguage>100</requesterLanguage><clientTransactionName></clientTransactionName></DWLControl></RequestControl><TCRMTx><TCRMTxType>maintainGlobalClientHierarchy</TCRMTxType><TCRMTxObject>TCRMContractBObj</TCRMTxObject><TCRMObject><TCRMContractBObj><CurrencyType>1</CurrencyType><AgreementName>Moretti New GC</AgreementName><AgreementNickName></AgreementNickName><AgreementStatusType>1000002</AgreementStatusType><AgreementType>1000002</AgreementType><TCRMExtension><ExtendedObject>CMSContractBObjExt</ExtendedObject><CMSContractBObjExt><ClientGenType>1000002</ClientGenType></CMSContractBObjExt></TCRMExtension><TCRMContractComponentBObj><ContractStatusType>1000001</ContractStatusType><TCRMContractPartyRoleBObj><RoleType>1000001</RoleType><TCRMOrganizationBObj><TCRMAdminContEquivBObj><AdminPartyId></AdminPartyId><AdminSystemType>1000001</AdminSystemType></TCRMAdminContEquivBObj></TCRMOrganizationBObj></TCRMContractPartyRoleBObj></TCRMContractComponentBObj><TCRMAdminNativeKeyBObj><AdminContractId></AdminContractId><AdminFieldNameType>1000001</AdminFieldNameType></TCRMAdminNativeKeyBObj></TCRMContractBObj></TCRMObject></TCRMTx></TCRMService>


<?xml version="1.0" encoding="UTF-8"?><TCRMService xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="CMSRequest.xsd"><RequestControl><requestID>104</requestID><DWLControl><requesterName>Automated Cleanup TC1</requesterName><requesterLanguage>100</requesterLanguage><clientTransactionName></clientTransactionName></DWLControl></RequestControl><TCRMTx><TCRMTxType>maintainGlobalClientHierarchy</TCRMTxType><TCRMTxObject>TCRMContractBObj</TCRMTxObject><TCRMObject><TCRMContractBObj><CurrencyType>1</CurrencyType><AgreementName>Moretti New GC</AgreementName><AgreementNickName></AgreementNickName><AgreementStatusType>1000002</AgreementStatusType><AgreementType>1000002</AgreementType><TCRMExtension><ExtendedObject>CMSContractBObjExt</ExtendedObject><CMSContractBObjExt><ClientGenType>1000002</ClientGenType></CMSContractBObjExt></TCRMExtension><TCRMContractComponentBObj><ContractStatusType>1000001</ContractStatusType><TCRMContractPartyRoleBObj><RoleType>1000001</RoleType><TCRMOrganizationBObj><TCRMAdminContEquivBObj><AdminPartyId></AdminPartyId><AdminSystemType>1000001</AdminSystemType></TCRMAdminContEquivBObj></TCRMOrganizationBObj></TCRMContractPartyRoleBObj></TCRMContractComponentBObj><TCRMAdminNativeKeyBObj><AdminContractId></AdminContractId><AdminFieldNameType>1000001</AdminFieldNameType></TCRMAdminNativeKeyBObj></TCRMContractBObj></TCRMObject></TCRMTx></TCRMService>

What is in your input file? Is it possible that you have one line with valid data and three blank lines? Awk will execute your print statements for each line of input -- whether or not there is information on the line. You could try this:

Code:

BEGIN{
   FS=",";
   requestID=100;
   ORS="";
 }
NF > 1  {
 print "<?xml version=\"1.0\" encoding=\"UTF-8\"?><TCRMService xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" \
xsi:noNamespaceSchemaLocation=\"CMSRequest.xsx\"><RequestControl><requestID>"requestID"</requestID><DWLControl>\
<requesterName>Automated Cleanup TC1</requesterName><requesterLanguage>100</requesterLanguage><clientTransactionName>\
"$1"</clientTransactionName></DWLControl></RequestControl>";

 print "<TCRMTx><TCRMTxType>maintainGlobalClientHierarchy</TCRMTxType><TCRMTxObject>TCRMContractBObj</TCRMTxObject>\
<TCRMObject><TCRMContractBObj><CurrencyType>1</CurrencyType><AgreementName>Moretti New GC</AgreementName><AgreementNickName>\
</AgreementNickName><AgreementStatusType>1000002</AgreementStatusType><AgreementType>1000002</AgreementType>";

 print "<TCRMExtension><ExtendedObject>CMSContractBObjExt</ExtendedObject><CMSContractBObjExt><ClientGenType>1000002</ClientGenType>\
</CMSContractBObjExt></TCRMExtension><TCRMContractComponentBObj><ContractStatusType>1000001</ContractStatusType><TCRMContractPartyRoleBObj>\
<RoleType>1000001</RoleType><TCRMOrganizationBObj>";

 print "<TCRMAdminContEquivBObj><AdminPartyId>"$2"</AdminPartyId><AdminSystemType>1000001</AdminSystemType></TCRMAdminContEquivBObj>\
</TCRMOrganizationBObj></TCRMContractPartyRoleBObj></TCRMContractComponentBObj><TCRMAdminNativeKeyBObj><AdminContractId>"$3"\
</AdminContractId><AdminFieldNameType>1000001</AdminFieldNameType></TCRMAdminNativeKeyBObj></TCRMContractBObj></TCRMObject>\
</TCRMTx></TCRMService>\n";

 }' input-file >output-file

Which will execute your print statements only if there are 2 or more tokens on the line.

Thanks agama.

My Bad. As you mentioned, There were three more empty lines after the first line in the input file.

No problem. For what it's worth -- I wasn't able to pull your attachments, but it seems you've figured it out.