Sponsored Content
Top Forums UNIX for Dummies Questions & Answers UNIX one line cmd join 2 sets of data from 2 files Post 302842037 by rbatte1 on Thursday 8th of August 2013 11:00:39 AM
Old 08-08-2013
Hello tugar,

I'm going to assume that the values in column 1 of file 2 are unique.

There might be a way with the paste command, but I've not used that much myself. I'm sure an awk will be more than capable, but I have a shell option for you. This might be a bit slow, but try:-
Code:
#!/bin/ksh
while read f1_c1 f1_rest
do
   index="${f1_c1%-*}"               # Remove section after the hyphen
   index="${index#${line%%???}"    # Remove first 3 characters
   grep "^$index " file2 | read ind ref
   echo "$f1_c1 $ref $f1_rest"
done <file1 >file3



I hope that this helps. Let us know if this is acceptable or misses the point.

Robin
Liverpool/Blackburn
UK
 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to join flat files together under unix

Hi, I have 7 big flat files, each contains 24 million records which have been sorted by the first field delimitered by Ctrl B (002). I want to join them together side by side, eg. File A: 1^Ba^Bb 2^Bx^By .... File B: 1^Bc^Bd 2^Bm^Bn .... After merged, it should look like :... (7 Replies)
Discussion started by: xli
7 Replies

2. Virtualization and Cloud Computing

Clouds (Partially Order Sets) - Streams (Linearly Ordered Sets) - Part 2

timbass Sat, 28 Jul 2007 10:07:53 +0000 Originally posted in Yahoo! CEP-Interest Here is my follow-up note on posets (partially ordered sets) and tosets (totally or linearly ordered sets) as background set theory for event processing, and in particular CEP and ESP. In my last note, we... (0 Replies)
Discussion started by: Linux Bot
0 Replies

3. OS X (Apple)

Command line tool to join multiple .wmv files?

I need a simple command line executable that allows me to join many wmv files into one output wmv file, preferrably in a simple way like this: wmvjoin file1.wmv file2.wmv .... > outputfile.wmv So what I want is the wmv-equivalent of mpgtx I cannot find it on internet. Thanks. (2 Replies)
Discussion started by: karman
2 Replies

4. Shell Programming and Scripting

Inserting Lines between data sets using SED?

Hello all and thanks in advance! What I'm looking to do is insert a blank line, anytime the first 9 characters of a given line don't match the first 9 characters of the previous line. i.e. Convert the data set 1 45 64 89 1 89 69 235 2 89 234 67 2 56 90... (1 Reply)
Discussion started by: selkirk
1 Replies

5. Shell Programming and Scripting

Finding Overlap between two sets of data

Hi everyone, I posted this earlier, but the idea changed since then and I figured it would make more sense if I repost with a clearer idea in hopes someone can help me out. I have two lists of data in file1 and file 2 file1 (tab separated - column1 column2 column 3) 1 91625106 ... (1 Reply)
Discussion started by: labrazil
1 Replies

6. Shell Programming and Scripting

join lines on line break in files

i had a file where lines appear to be broken when they shouldn't eg Line 1. kerl abc sdskd sdsjkdlsd sdsdksd \ Line 2. ksdkks sdnjs djsdjsd i can do a shift join to combine the lines but i there are plenty of files with this issue Line 1. kerl abc sdskd sdsjkdlsd sdsdksd ksdkks sdnjs... (6 Replies)
Discussion started by: mad_man12
6 Replies

7. Shell Programming and Scripting

Unix cmd prompt how to get old cmd run?

Hi, I am using SunOS I want to serch my previous command from unix prompt (like on AIX we can search by ESC -k) how to get in SunOs urgent help require. (10 Replies)
Discussion started by: RahulJoshi
10 Replies

8. Shell Programming and Scripting

UNIX cmd -find empty files in folder else sleep for 8hrs

Hello, I am trying to write a unix cmd , that if files in folder /path/FTP are all zero kb or empty then good to go, if not empty then sleep for 8 hrs. Following cmd list me the files which are not empty, But when I am incorporating IF ELSE cmd fails find /path/FTP. -type f -exec wc -l {}... (6 Replies)
Discussion started by: bluestarmoon
6 Replies

9. Shell Programming and Scripting

Join the line on delimiter using sed/awk in UNIX

I've input as , abcd| ef 123456| 78| 90 Desired output as, abcdef 1234567890 Anyone please give the solution. (5 Replies)
Discussion started by: jinixvimal
5 Replies
uadmin(1M)																uadmin(1M)

NAME
uadmin - administrative control SYNOPSIS
/usr/sbin/uadmin cmd fcn [mdep] /sbin/uadmin cmd fcn [mdep] The uadmin command provides control for basic administrative functions. This command is tightly coupled to the system administration proce- dures and is not intended for general use. It may be invoked only by the super-user. Both the cmd (command) and fcn (function) arguments are converted to integers and passed to the uadmin system call. The optional mdep (machine dependent) argument is only available for the cmd values of 1 (A_REBOOT), 2 (A_SHUTDOWN), or 5 (A_DUMP). For any other cmd value, no mdep command-line argument is allowed. When passing an mdep value that contains whitespaces, the string must be grouped together as a single argument enclosed within quotes, for example: uadmin 1 1 "-s kernel/unix" See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWcsu | +-----------------------------+-----------------------------+ uadmin(2), attributes(5) On systems, shutting down the system by means of uadmin does not update the boot archive. Avoid using this command after manual editing of files such as /etc/system or driver.conf(4). 11 Apr 2005 uadmin(1M)
All times are GMT -4. The time now is 07:12 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy