Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
 |
| Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| iterate through records using AWK | harris2107 | Shell Programming and Scripting | 6 | 08-21-2007 10:07 PM |
| how to put nil at the end of each records. | happyv | Shell Programming and Scripting | 2 | 07-19-2007 11:20 PM |
| Count No of Records in File without counting Header and Trailer Records | guiguy | Shell Programming and Scripting | 2 | 06-07-2007 12:15 PM |
| temperature records | uzerx | HP-UX | 0 | 06-06-2006 01:47 PM |
| A records | Deuce | UNIX for Dummies Questions & Answers | 3 | 09-25-2001 11:42 AM |
 |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
06-14-2006
|
||||
|
||||
|
Records
Hello there,
I am having a script file running on unix solaris server, this script file is designed to calculate the records of a chosen day. The output will be saved to another file in the form of two columns, as an example, the output may look like: Account Name Records Account1 123 Account2 390 Account3 40 and so on..... I would like to know, if there is any way to output this file to an excel worksheet on my windows desktop in a table format. Also if possible, can we output two files from the unix server to two different sheets in the same excel worksheet?? Is there anyway to do this or it can be applied in unix. Please help me since i wanted this urgently!!! Your coordination is highly appreciated...... |
|
06-14-2006
|
||||
|
||||
|
You can't create a workbook easily at all.
However, you can create one csv file at a time, then work with them on the PC Using this as the data input: Code:
Account1 123 Account2 390 Account3 40 Code:
awk '{printf("\"%s\",%d\n", $1, $2)}' file >newfile.csv
Code:
"Account1",123 "Account2",390 "Account3",40 |
|
06-29-2006
|
||||
|
||||
|
thx alot, i have tried what u said and everything seems to be working fine.....
|
| Sponsored Links | ||
|
|
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
