![]() |
|
|
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 |
| removing duplicates | stevie_velvet | Shell Programming and Scripting | 5 | 07-07-2008 08:42 AM |
| removing leading zero | risshanth | UNIX for Dummies Questions & Answers | 0 | 02-08-2008 06:51 AM |
| removing duplicates and sort -k | orahi001 | UNIX for Dummies Questions & Answers | 3 | 01-25-2008 09:59 AM |
| Stripping leading spaces on right justified name | Marcia P | UNIX for Dummies Questions & Answers | 2 | 02-28-2006 10:32 PM |
| Removing duplicates | giannicello | Shell Programming and Scripting | 12 | 09-14-2005 07:12 PM |
![]() |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
||||
|
Adding Leading Zero with Right Justified and Removing Duplicates
hello everyone. I'm hoping someone can help me out here. I have 2 files. It looks like this:
File 1: abc1, defg, 50.00, mno,990 abc2, cats, 100.00, pops,991 abc3, dogs, 1.00, treat,992 File 2: 990, airplanes, runway, doctor 991, jets, birds, much 990, *airplanes,runway,doctor 992, cars, ford, toyota Here is what I would like to do: 1. In file 1, column 3, the amount, i would like it to be right justified with leading zero 2. In file 2, all the duplicate need to be removed. Like 990, *airplanes 3. After file 1 and 2 are done, then join them by using the key in column 5 in file 1 and column 1 in file 2. If you need more clarification, let me know. I appreciate it greatly if someone can help me out. Thank you. |
|
||||
|
by the way, the final file would be something like this:
abc1, defg, 000050.00, mno ,990, airplanes, runway,doctor abc2, cats, 000100.00, pops ,991, jets,birds, much abc3, dogs, 000001.00, treat,992, cars,ford, toyota for number 3, I would assume use the join command? |
|
||||
|
Quote:
000000000 000000100 000000090 000001100 000012000 The last 2 digit represent the cents. Example 5.50 will be 000000550 |
|
||||
|
would you be so kind to explain the code a bit for me. Thank you for your help.
|
![]() |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|