|
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| UNIX for Dummies Questions & Answers If you're not sure where to post a UNIX or Linux question, post it here. All UNIX and Linux newbies welcome !! |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| combining fields in two text fields | shocker | Shell Programming and Scripting | 3 | 01-16-2008 11:27 AM |
| Cut Last 3 Fields | bourne | Shell Programming and Scripting | 4 | 01-11-2007 05:17 AM |
| Last fields | Khoomfire | UNIX for Advanced & Expert Users | 3 | 04-13-2006 06:03 PM |
| how to cut fields | rajan_ka1 | Shell Programming and Scripting | 1 | 12-29-2005 05:55 AM |
| Awk - more than 99 fields? | DaveM | UNIX for Dummies Questions & Answers | 2 | 01-23-2001 01:34 PM |
 |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
07-27-2008
|
||||
|
||||
|
Deduplicate fields
Hi All,
I have a file which has the conetent like this:- SELECT F1, F2, F3, F1, F5, F2 FROM T1 I Want to replace multiple occurences of F1 and F2 with single field. Required Output Should be: SELECT F1, F2, F3,F5 FROM T1 Please guide me how can i do this? Thanks in Advance. Dilip |
|
07-27-2008
|
|||||
|
|||||
|
Assuming your input file contains only select statements: Code:
perl -lne'
($p1, $p2, $p3) =
/(SELECT )(.*?)( FROM .*)/;
print $p1,
(join ", ", grep !$_{$_}++, split ", ", $p2),
$p3;
undef %_' filename
|
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Hybrid Mode
