Can someone help me out to export awk output to excel file in different rows? Plzzzz its urgent...
Write the output with each field separated by a comma and save the output as a .csv file. Excel should recognise it.
The awk is outputting the file with ; as delimiter. so do i hv to change the delimiter to , manually? also the data shud go into different rows of the excel bt nt into differnt columns.... suggest on this
You don't have to - you can tell Excel to split its columns based on any character you like. And as far as swapping rows and columns, that's probably easier to do in Excel as well...once you've got it all in separate columns, copy the whole lot and then "paste special" and select transpose.
:)dat really works... great and tnx a ton...