|
|||||||
| Forums | Search Forums | Register | Forum Rules | Man Pages | Albums | FAQ | Members | 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 !! |
|
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
01-25-2013
|
|||
|
|||
|
Combining two files with a reference coloumn
Hi all, this is file1.txt Code:
10.210.226.21 alarmSupervisionActive=true 10.64.136.209 alarmSupervisionActive=true 10.64.174.209 alarmSupervisionActive=true 10.64.182.65 alarmSupervisionActive=true 10.66.193.113 alarmSupervisionActive=true 10.80.124.67 alarmSupervisionActive=true 10.80.124.68 alarmSupervisionActive=true 10.80.124.69 alarmSupervisionActive=true 10.80.124.70 alarmSupervisionActive=true 10.80.124.71 alarmSupervisionActive=true 10.80.124.72 alarmSupervisionActive=true 10.80.124.73 alarmSupervisionActive=true and this is file2.txt Code:
10.210.226.21 STN_systemClockUDP_Port=123; 10.64.136.209 STN_systemClockUDP_Port=123; 10.64.174.209 STN_systemClockUDP_Port=123; 10.64.182.65 STN_systemClockUDP_Port=123; 10.66.193.113 STN_systemClockUDP_Port=123; 10.80.124.67 STN_systemClockUDP_Port=123; 10.80.124.68 STN_systemClockUDP_Port=123; 10.80.124.69 STN_systemClockUDP_Port=123; 10.80.124.70 STN_systemClockUDP_Port=123; 10.80.124.71 STN_systemClockUDP_Port=123; 10.80.124.72 STN_systemClockUDP_Port=123; 10.80.124.73 STN_systemClockUDP_Port=123; expecting the output.txt like below; Code:
10.210.226.21 STN_systemClockUDP_Port=123; alarmSupervisionActive=true 10.64.136.209 STN_systemClockUDP_Port=123; alarmSupervisionActive=true 10.64.174.209 STN_systemClockUDP_Port=123; alarmSupervisionActive=true 10.64.182.65 STN_systemClockUDP_Port=123; alarmSupervisionActive=true 10.66.193.113 STN_systemClockUDP_Port=123; alarmSupervisionActive=true 10.80.124.67 STN_systemClockUDP_Port=123; alarmSupervisionActive=true 10.80.124.68 STN_systemClockUDP_Port=123; alarmSupervisionActive=true 10.80.124.69 STN_systemClockUDP_Port=123; alarmSupervisionActive=true 10.80.124.70 STN_systemClockUDP_Port=123; alarmSupervisionActive=true 10.80.124.71 STN_systemClockUDP_Port=123; alarmSupervisionActive=true 10.80.124.72 STN_systemClockUDP_Port=123; alarmSupervisionActive=true 10.80.124.73 STN_systemClockUDP_Port=123; alarmSupervisionActive=true I try join a1 a2 but doesnt work! Waiting for helps? Thanks so much |
| Sponsored Links | ||
|
|
#2
01-25-2013
|
|||
|
|||
|
In what way does join not work?
What error message does it produce? What does it write to standard output? |
| Sponsored Links | ||
|
|
#4
01-25-2013
|
|||
|
|||
|
The output.txt appears like below, no errors actually, I want coloumn by coloumn.. Code:
10.210.226.21 alarmSupervisionActive=true STN_systemClockUDP_Port=123; 10.64.136.209 alarmSupervisionActive=true STN_systemClockUDP_Port=123; 10.64.174.209 alarmSupervisionActive=true STN_systemClockUDP_Port=123; 10.64.182.65 alarmSupervisionActive=true STN_systemClockUDP_Port=123; 10.66.193.113 alarmSupervisionActive=true STN_systemClockUDP_Port=123; 10.80.124.67 alarmSupervisionActive=true STN_systemClockUDP_Port=123; 10.80.124.68 alarmSupervisionActive=true STN_systemClockUDP_Port=123; 10.80.124.69 alarmSupervisionActive=true STN_systemClockUDP_Port=123; 10.80.124.70 alarmSupervisionActive=true STN_systemClockUDP_Port=123; 10.80.124.71 alarmSupervisionActive=true STN_systemClockUDP_Port=123; 10.80.124.72 alarmSupervisionActive=true STN_systemClockUDP_Port=123; 10.80.124.73 alarmSupervisionActive=true STN_systemClockUDP_Port=123; ---------- Post updated at 03:03 PM ---------- Previous update was at 02:58 PM ---------- Code:
omerkah@unix> awk 'NR==FNR{A[$1]=$2;next}$0=$0" "A[$1]' a1 a2
awk: syntax error near line 1
awk: bailing out near line 1when I try Code:
awk 'NR==FNR{A[$1]=$2;next}$0=$0" "A[$1]' a1 a2errors appears, unfortunately. Thanks for the reply |
| Sponsored Links | |
|
|
#5
01-25-2013
|
|||
|
|||
|
Which system are you on?
|
| Sponsored Links | |
|
|
#6
01-25-2013
|
|||
|
|||
|
The system is; Code:
omerkah@unix> uname -a SunOS claps8 5.10 Generic_147440-07 sun4u sparc SUNW,SPARC-Enterprise |
| Sponsored Links | |
|
|
#7
01-25-2013
|
|||
|
|||
|
An internet search mentioned to try using nawk then...
|
| Sponsored Links | ||
|
|
| Thread Tools | Search this Thread |
| Display Modes | |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Need Help in reading N days files from a Directory & combining the files | dsfreddie | UNIX for Dummies Questions & Answers | 1 | 12-30-2011 11:33 AM |
| combining two files | rock1 | UNIX for Dummies Questions & Answers | 36 | 09-29-2008 02:10 PM |
| Combining two files | hemangjani | Shell Programming and Scripting | 7 | 06-13-2007 10:32 PM |
| Combining files | Enda Martin | UNIX for Dummies Questions & Answers | 2 | 07-20-2001 10:31 AM |
| combining files | apalex | UNIX for Dummies Questions & Answers | 3 | 06-19-2001 09:49 AM |
|
|
Linear Mode
