Hi Experts,
In short : Need to split file when field in column 5 is blank and need to generate two file in which column 5 is blank and other in which column 5 has values along with other rows and column data
My issue is i am not able to get header for column from raw file into new file which is generated by below command.
awk -F"|" -v OFS="|" '{if ($5 == "") print;}' test1.txt
Current sample output without header
03|||||29AAACH27|||M/s HD . LTD||||29||||||9984||Tel Ser|||||0.00|0.00|9.00|45.00|9.00|45.00|||||590.00||||||||||
Expected sample output should be with header like below
VALOREM|CESSAMOUNTADVALOREM|CESSRATESPECIFIC|CESCIFIC|INVE|REVERSECHARGEFLAG|TCSFLAG|ECOMGSTIN|ITCFLAG|REASONFORCREDITDEBITNOTE|ACCOUNTINGVOUCHERNUMBER|ACCOUNTINGVOUCHERDATE|USERDEFINEDFIELD1|USERDEFINEDFIELD2|USERDEFINEDFIELD3
03|||||29AAAZW|||M/s HD. LTD||||29||||||9984||Tel Ser|||||0.00|0.00|9.00|45.00|9.00|45.00|||||590.00||||||||||