Sponsored Content
Full Discussion: Connecting 3 files
Top Forums Shell Programming and Scripting Connecting 3 files Post 302876766 by Yoda on Tuesday 26th of November 2013 01:32:20 PM
Old 11-26-2013
Here is something that you can start working with:
Code:
awk '
        NR == FNR {
                A[$1] = $1
                next
        }
        !/\[/ && FILENAME == "file2.txt" {
                v = $0
        }
        /\[/ && FILENAME == "file2.txt" {
                d = $0
                gsub ( /\[|\]/, X, $1 )
                if ( length ($1) > 1 )
                        sub ( /.$/, X, $1 )
                gsub ( /.*\[[A-Z]\][ ]*/, X, d )
                A[$1] = d OFS v
                next
        }
        /\[/ && FILENAME == "file1.txt" {
                i = $1
                gsub ( /\[|\]/, X, i )
                if ( length (i) > 1 )
                        sub ( /.$/, X, i )
        }
        A[$NF] && FILENAME == "file1.txt" {
                print $NF, i, A[i]
        }
' OFS=\| file3.txt file2.txt file1.txt

This User Gave Thanks to Yoda For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

connecting ....sql

if; sqlplus /nolog <<EOF conn / as sysdba spool /tmp/start.out @/oracle/home/start.sql spool off exit EOF fi For this code i am getting error: Test.sh: syntax error at line 7 : `<<' unmatched (8 Replies)
Discussion started by: dreams5617
8 Replies

2. UNIX for Dummies Questions & Answers

connecting the ip address

Hi, I have three ip address say x.x.x.x , y.y.y.y and z.z.z.z I am connecting to x.x.x.x first and from there i am telnet y.y.y.y and getting into y and from there i am telnet to z i want to know, can we write a script, which can automatically connect from x to y and from y to z.. is... (1 Reply)
Discussion started by: vasikaran
1 Replies

3. Solaris

Connecting to SAN

I am about to attempt to connect my sun 280R boxes to a EMC SAN. I have Qlogic cards that came from Sun. I am going to load traffic manager, navisphere client. what else do i need, sun foundation suite ro somehting? This is the first time ive ever connected to a SAN. any help would be... (3 Replies)
Discussion started by: BG_JrAdmin
3 Replies

4. AIX

Connecting to DB

Is it possible to connect to two databases in a single query with different username and passwords? provide an example pls (1 Reply)
Discussion started by: rollthecoin
1 Replies

5. UNIX for Dummies Questions & Answers

Connecting to website

Okay, here's the situation: I have a UNIX box hosting a website. The website is basically there to hold a .swf file; when you go to the URL, the .swf file loads, and it pulls data from a database on another computer into a cache. The cache holds things for 24 hours. This all works fine, so it's... (7 Replies)
Discussion started by: BSchow
7 Replies

6. UNIX for Dummies Questions & Answers

Connecting Two Unix Computers To Share Files

I was wondering if I could get some help with two of my Unix computers. Bare with me as I am new to this software and, hardly know anything on these computers, except based on what I have already worked with them. Here is my issue. I have two unix computers setup together, not connected... (6 Replies)
Discussion started by: OrangeNblack
6 Replies

7. UNIX for Dummies Questions & Answers

connecting lines of 2 different files

How would i connect the lines of 2 different files? Also how would i reissue the command to use an equal signsas the seperators between the fields? (1 Reply)
Discussion started by: trob
1 Replies

8. Shell Programming and Scripting

connecting through sqlplus

I am trying to connect to one of the oracle sever using uni through sqlplus command: sqlplus -s BOXI_ALPH_AUDITOR,Q078_audit$@Q047 But its not getting connected. I tried using some different server using same syntax its working. What differene i found is the password is having no special... (2 Replies)
Discussion started by: gander_ss
2 Replies

9. Shell Programming and Scripting

Error when connecting to remote server to find files with timestamp today's day

I am connecting to remote server and try to check if files with timestamp as Today's day are on the directory. Below is my code TARFILE=${NAME}.tar TARGZFILE=${NAME}.tar.gz ssh ${DESTSERVNAME} 'cd /export/home/iciprod/download/let/monthly; Today=`date +%Y%m%d`; if ;then echo "We... (1 Reply)
Discussion started by: digioleg54
1 Replies

10. Shell Programming and Scripting

Shell script for connecting multiple servers and then copying 30 days old files

Shell script for connecting multiple servers and then copying 30 days old files from those server . HI , I have 6 multiple servers pla1,pla2,pla3,pla4,pla5,pla6 1. These six servers have common shared mount point /var/share 2. Running script from /var/share to connect these servers.I... (1 Reply)
Discussion started by: rcroyal88
1 Replies
comm(1) 							   User Commands							   comm(1)

NAME
comm - select or reject lines common to two files SYNOPSIS
comm [-123] file1 file2 DESCRIPTION
The comm utility reads file1 and file2, which must be ordered in the current collating sequence, and produces three text columns as output: lines only in file1; lines only in file2; and lines in both files. If the input files were ordered according to the collating sequence of the current locale, the lines written will be in the collating sequence of the original lines. If not, the results are unspecified. OPTIONS
The following options are supported: -1 Suppresses the output column of lines unique to file1. -2 Suppresses the output column of lines unique to file2. -3 Suppresses the output column of lines duplicated in file1 and file2. OPERANDS
The following operands are supported: file1 A path name of the first file to be compared. If file1 is -, the standard input is used. file2 A path name of the second file to be compared. If file2 is -, the standard input is used. USAGE
See largefile(5) for the description of the behavior of comm when encountering files greater than or equal to 2 Gbyte ( 2**31 bytes). EXAMPLES
Example 1: Printing a list of utilities specified by files If file1, file2, and file3 each contain a sorted list of utilities, the command example% comm -23 file1 file2 | comm -23 - file3 prints a list of utilities in file1 not specified by either of the other files. The entry: example% comm -12 file1 file2 | comm -12 - file3 prints a list of utilities specified by all three files. And the entry: example% comm -12 file2 file3 | comm -23 -file1 prints a list of utilities specified by both file2 and file3, but not specified in file1. ENVIRONMENT VARIABLES
See environ(5) for descriptions of the following environment variables that affect the execution of comm: LANG, LC_ALL, LC_COLLATE, LC_CTYPE, LC_MESSAGES, and NLSPATH. EXIT STATUS
The following exit values are returned: 0 All input files were successfully output as specified. >0 An error occurred. ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWesu | +-----------------------------+-----------------------------+ |CSI |enabled | +-----------------------------+-----------------------------+ |Interface Stability |Standard | +-----------------------------+-----------------------------+ SEE ALSO
cmp(1), diff(1), sort(1), uniq(1), attributes(5), environ(5), largefile(5), standards(5) SunOS 5.10 3 Mar 2004 comm(1)
All times are GMT -4. The time now is 02:46 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy