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 |
 |
| UNIX Desktop for Dummies Questions & Answers Discuss UNIX and Linux user interfaces like GNOME, KDE, CDE, and Open Office here. All UNIX and Linux Newbies Welcome !! |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Changing one column of delimited file column to fixed width column | manneni prakash | Shell Programming and Scripting | 5 | 06-22-2009 05:27 AM |
| Unix shell script to parse the contents of comma-separated file | KrishnaSaran | Shell Programming and Scripting | 11 | 06-20-2008 05:43 AM |
| Remove whitespaces between comma separated fields from file | nitinbjoshi | UNIX for Dummies Questions & Answers | 2 | 06-14-2008 08:14 AM |
| Removing comma after 3rd column | buddyme | UNIX for Dummies Questions & Answers | 13 | 03-17-2008 10:44 AM |
| Splitting comma separated values into an array | tmarikle | Shell Programming and Scripting | 3 | 06-24-2005 05:50 PM |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
07-30-2008
|
||||
|
||||
|
Unix Comma Separated to Excel Column
I would like to copy 2 parts of a csv file from Unix to an XL sheet. However to save time I do not want to format the column ever time I cut and paste into XL(Text2Column). I've used awk -F, '{Print $1, $2....}'. Is there a script or code that can automatically format the csv for XL columns?
Sample CSV 00:10,2344,2332,0,1,0,2,0 00:15,2311,2002,0,0,0,1,0 Sample XL 00:10|2344|2332|0|1|0,2|0 --------------------------- 00:15|2311|2002|0|0|0|1|0 Last edited by ravzter; 07-30-2008 at 02:56 AM.. Reason: missing example |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Threaded Mode
