![]() |
|
|
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 |
| Adding a column to a text based on file name | rlapate | Shell Programming and Scripting | 12 | 05-23-2009 10:22 PM |
| Filtering records of a file based on a value of a column | risk_sly | UNIX for Dummies Questions & Answers | 4 | 09-24-2008 03:22 AM |
| sorting file based on two or more columns | labrazil | Shell Programming and Scripting | 2 | 09-17-2008 12:19 AM |
| Retrieve line from a file based on a value in specific column | efernandes | UNIX for Dummies Questions & Answers | 1 | 01-27-2007 11:04 AM |
| Sorting a flat file based on multiple colums(using character position) | cucubird | Shell Programming and Scripting | 8 | 07-25-2006 01:47 AM |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
||||
|
sorting csv file based on column selected
Hi all,
in my csv file it'll look like this, and of course it may have more columns US to UK;abc-hq-jcl;multimedia UK to CN;def-ny-jkl;standard DE to DM;abc-ab-klm;critical FD to YM;la-yr-tym;standard HY to MC;la-yr-ytm;multimedia GT to KJ;def-ny-jrt;critical I would like to group them based on the 3rd column first, then sort them based on 2nd column so it'll look like this DE to DM;abc-ab-klm;critical GT to KJ;def-ny-jrt;critical US to UK;abc-hq-jcl;multimedia HY to MC;la-yr-ytm;multimedia UK to CN;def-ny-jkl;standard FD to YM;la-yr-tym;standard it would also be nice if somehow I can make it look like this so it'll look more presentable :P, CRITICAL DE to DM;abc-ab-klm;critical GT to KJ;def-ny-jrt;critical Multimedia US to UK;abc-hq-jcl;multimedia HY to MC;la-yr-ytm;multimedia Standard UK to CN;def-ny-jkl;standard FD to YM;la-yr-tym;standard |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|