Shell Programming and Scripting

That's exactly the structure of a .csv (comma separated values) file: just a block of text with fields and separators (commas, semicolons, ...) in between.
Just open that with EXCEL; it should offer sth. like a text wizard (or so).

Rudy,

It is showing the same way as csv file,Below the output

Code:

USERNAME;HOSTNAME;LOGIN_TIME;LOGOUT_TIME;DURATION
wtmp;Tue;1915:49:472015;;
;;;;
reboot;boot;TueMay1915:50:13;TueMay1915:52:13;2015
root;:0;May1915:50:372015;May1915:51:152015;(00:00)
root;:0.0;May1915:50:462015;May1915:50:512015;(00:00)
reboot;boot;TueMay1915:56:39;MonJun1518:30:10;2015

Thanks again for your help.

Moderator's Comments:

Repeated refusal to use CODE tags as required by forum rules has resulted in the creator of this thread being placed in read-only mode for three days. Please review the rules we all agreed to when we joined this forum (and look at the infraction notices you have received in e-mail which provide a tutorial that describes how and when to use CODE and ICODE tags). Do not depend on forum moderators and administrators to clean up your posts for you. Continued refusal to use CODE tags could result in you being banned from this site.

The code you showed us in the 1st post in this thread produced tabular data aligned on tab stop boundaries (although the output you showed us replaced the tabs that your script produced with varying numbers of spaces that misaligned the output). You said you didn't want that; you said you wanted a CSV file output file format instead. You are getting exactly what you asked for. If you want a nicely formatted table style output with aligned output (even if the width of the text in the output columns varies), you can do that too; but nicely formatted table style output is MUCH harder to load into a MicroSoft Excel spreadsheet, while loading a CSV formatted file into MicroSoft Excel is easy.