merging info from 2 files into 1 Post: 302302184

Sponsored Content

Top Forums Shell Programming and Scripting merging info from 2 files into 1 Post 302302184 by joeyg on Monday 30th of March 2009 09:45:56 AM

03-30-2009

Registered User

thinking awk and a couple of arrays is the way to go

Something like the following would allow you to create arrays as you read thru each of your files. The following STARTS the coding for awk to read and set some variables to arrays. This still needs logic on what to write out to a work (output) file, and also ENDING logic. [Don't want to do everything for you.]
If you think this might be a way to go, you could start with this coding and research on how to do the remaining awk commands necessary.

Code:

awk -v wrk1=$workfile1ns -v wrk2x=$workfile2x '
      BEGIN {
         FSf1=","
         FSf2=","
      }
      FNR == 1 {
          if (FILENAME==wrk2x) FS=FSf2
          if (FILENAME==wrk1) FS=FSf1
          $0=$0
      }
      FILENAME==wrk1 { 
         medx[$1]=$2
         }

      FILENAME==wrk2x{ 
         ua1_pl[$1]=$2
         }

joeyg

View Public Profile for joeyg

Find all posts by joeyg

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Merging info

Hi, pls advise how could we merge contents of lines from 2 different files into 1 file but shares common label continously as in the following example: Thanks in advance...rgds. File1: // line: 0 abc def // line: 1 ghi jkl File2: // line: 0 mno pqr // line: 1 stu vwx End...

2. UNIX for Dummies Questions & Answers

Merging two files

Hi I have a requirement like this. I have two files This is how data1.txt looks: EI3171280 38640658501 NENN2005-12-129999-12-312005-12-12HALL NANCY 344 CHENEY HIGHWAY ...

3. Shell Programming and Scripting

merging files

Thanks in advance I have 2 files having key field in each.I would like to join both on common key.I have used join but not sucessful. The files are attached here . what i Want in the output is on the key field SLS OFFR . I have used join commd but not successful. File one ======= SNO ...

4. Shell Programming and Scripting

merging two files

Friends, os: redhat enterprise linux/SCO UNIX5.0 I have two files and I would like to merge on given key value. Now I have tried with join commd but it does not supporte multiple delimiters. and if records length is not fixed. join -a1 5 -a2 1 -t -o file1 file2 > outname Can any...

5. Shell Programming and Scripting

Help with merging files

i would like to merge two files that have the same format but have different data. i would like to create one output file that contains information from both the original files.:rolleyes:

6. UNIX for Dummies Questions & Answers

Merging two files

Hi, I have two files a.txt and b.txt. a.txt 1 2 3 4 b.txt a b c d e I want to generate a file c.txt by merging these two file and the resultant file would contain c.txt 1

7. Shell Programming and Scripting

Merging files

I have two files file 1 containing x rows and 1 column file 2 containing x rows and 1 column I want to merge both the files and add a comma between the two eg plz guide

8. Shell Programming and Scripting

merging two files

file1.txt 1 2 10 11 56 57 7 8 43 44 and let's suppose that there is a file called file2.txt with 100 columns I want to produce a file3.txt with columns specified in file1.txt in that order (1,2,10,11,56,57,7,8,43,44) Thanks!

9. Shell Programming and Scripting

Merging two files

Guys, I am having little problem with getting a daily report! The daily process that I do is as follows 1. Unload Header for the report from the systables to one unl file, say Header.unl 2. Unload the data from the required table/tables to another unl file, say Data.unl 3. Send a...

10. Shell Programming and Scripting

Merging two files

Hi All , I have a scenario where we need to combine two files . Below are the sample files and expected output , File 1: 1|ab 1|ac 1|ae 2|ad 2|ac File 2: 1|xy 1|fc 2|gh 2|ku Output file : 1|ab|xy

LEARN ABOUT BSD

zgrep

ZGREP(1)						      General Commands Manual							  ZGREP(1)

NAME

       zgrep - search possibly compressed files for a regular expression

SYNOPSIS

       zgrep [ grep_options ] [ -e ] pattern filename...

DESCRIPTION

       Zgrep  invokes  grep  on  compressed  or  gzipped  files.   These  grep	options  will  cause  zgrep  to  terminate  with  an  error  code:
       (-[drRzZ]|--di*|--exc*|--inc*|--rec*|--nu*).  All other options specified are passed directly to grep.  If no file is specified,  then  the
       standard input is decompressed if necessary and fed to grep.  Otherwise the given files are uncompressed if necessary and fed to grep.

       If the GREP environment variable is set, zgrep uses it as the grep program to be invoked.

EXIT CODE

       2 - An option that is not supported was specified.

AUTHOR

       Charles Levert (charles@comm.polymtl.ca)

SEE ALSO

       grep(1), gzexe(1), gzip(1), zdiff(1), zforce(1), zmore(1), znew(1)

																	  ZGREP(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Merging info

Discussion started by: Manan

2. UNIX for Dummies Questions & Answers

Merging two files

Discussion started by: venommaker

3. Shell Programming and Scripting

merging files

Discussion started by: vakharia Mahesh

4. Shell Programming and Scripting

merging two files

Discussion started by: vakharia Mahesh

5. Shell Programming and Scripting

Help with merging files

Discussion started by: joe black

6. UNIX for Dummies Questions & Answers

Merging two files

Discussion started by: siba.s.nayak

7. Shell Programming and Scripting

Merging files

Discussion started by: test_user

8. Shell Programming and Scripting

merging two files

Discussion started by: johnkim0806

9. Shell Programming and Scripting

Merging two files

Discussion started by: PikK45

10. Shell Programming and Scripting

Merging two files

Discussion started by: saj

LEARN ABOUT BSD

zgrep