Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to join 2 text files using bash scripting?
Top Forums Shell Programming and Scripting How to join 2 text files using bash scripting? Post 302970607 by RavinderSingh13 on Friday 8th of April 2016 04:19:47 PM
Old 04-08-2016
Hello H.R,

Welcome to forums, please use code tags for complete Input_file and sample outputs into posts as per forums rules. Here are some points which are not clear into your request.
I- Number of lines into filea and fileb are NOT same, so how comparison should happen?
II- IN case it should be by filea's $4 and $5 and fileb's $2 and $3(as per your post) then also there is a question, let's say we have following scenario where same values of $4 and $5 have more than one values into it then which value we should print?
It is advisable to please describe your requirement little more with sample Input_file and expected Output_file. Anyways based on few wild assumptions following you could take as a startup for this problem.
Code:
awk 'FNR==NR{sub(/\..*/,X,$4);sub(/\..*/,X,$5);A[$4 FS $5]=$2 FS $NF;next} {$2=($2 FS $3) in A?A[$2 FS $3]:"NA NA"} 1' filea fileb

Output will be as follows.
Code:
3333 2134 30 22222 54367.05 34765.05
3333 NA NA 12235 54298.05 34568.05
3333 2134 30 22222 52765.05 32567.05
3333 NA NA 11111 52875.05 36547.05
3333 2134 30 46678 53789.05 34566.05

Please get back to us in case of any queries on same.

Thanks,
R. Singh
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Log FILES in BASH scripting

Hi Im new to BASH scripting, I have created a simple script #! /bin/sh LOCAL=/home/scanner NOW=$(date +"%b-%d-%y") LOGFILE="log-$NOW.log" cd $LOCAL echo 'Start'; echo $LOGFILE touch $LOGFILE (2 Replies)
Discussion started by: jackdaw
2 Replies

2. Shell Programming and Scripting

Bash scripting to compare N number of files located in two directories

I want to compare "N" (around 2000+) number of huge files located in a directory A against "N" files located in a different directory using Bash scripting. Please help me with any scripts available. Thanks. (2 Replies)
Discussion started by: Sangtha
2 Replies

3. UNIX for Dummies Questions & Answers

Join 2 files with multiple columns: awk/grep/join?

Hello, My apologies if this has been posted elsewhere, I have had a look at several threads but I am still confused how to use these functions. I have two files, each with 5 columns: File A: (tab-delimited) PDB CHAIN Start End Fragment 1avq A 171 176 awyfan 1avq A 172 177 wyfany 1c7k A 2 7... (3 Replies)
Discussion started by: InfoSeeker
3 Replies

4. UNIX for Dummies Questions & Answers

How to use the join command to obtain tab delimited text files as an output?

How do you use the join command and obtain tab delimited text files as an output? Thanks! (2 Replies)
Discussion started by: evelibertine
2 Replies

5. UNIX for Dummies Questions & Answers

How to use the the join command to join multiple files by a common column

Hi, I have 20 tab delimited text files that have a common column (column 1). The files are named GSM1.txt through GSM20.txt. Each file has 3 columns (2 other columns in addition to the first common column). I want to write a script to join the files by the first common column so that in the... (5 Replies)
Discussion started by: evelibertine
5 Replies

6. Shell Programming and Scripting

Is there a way to join 2 text files sorted by

Can anyone please help me i have 2 text files setup like the one below. Textfile1: randomemail1:randompassword1 randomemail2:randompassword2 randomemail3:randompassword3 randomemail4:randompassword4 randomemail5:randompassword5 Textfile2: randompassword1:randomphrase1... (8 Replies)
Discussion started by: nufc
8 Replies

7. Shell Programming and Scripting

Bash: join 2 files

Hello ! I want to join 2 files. They look like this: KE340296.1 1 0/0:11 KE340296.1 2 0/0:12 KE340296.1 6 0/1:13 KE340297.1 1 0/1:14 KE340297.1 3 0/1:15 KE340297.1 4 0/1:16 and KE340296.1 1 0/0:21 KE340296.1 2 0/0:22 KE340296.1 3... (4 Replies)
Discussion started by: MumuGB
4 Replies

8. Shell Programming and Scripting

Join columns across multiple lines in a Text based on common column using BASH

Hello, I have a file with 2 columns ( tableName , ColumnName) delimited by a Pipe like below . File is sorted by ColumnName. Table1|Column1 Table2|Column1 Table5|Column1 Table3|Column2 Table2|Column2 Table4|Column3 Table2|Column3 Table2|Column4 Table5|Column4 Table2|Column5 From... (6 Replies)
Discussion started by: nv186000
6 Replies

9. Shell Programming and Scripting

Alignment tool to join text files in 2 directories to create a parallel corpus

I have two directories called English and Hindi. Each directory contains the same number of files with the only difference being that in the case of the English Directory the tag is .english and in the Hindi one the tag is .Hindi The file may contain either a single text or more than one text... (7 Replies)
Discussion started by: gimley
7 Replies

10. Shell Programming and Scripting

How to move files with first part as new filenamevia bash shell scripting?

I am on linux red hat, want to use the logic within bash shell script file. I have the following type, named files in folder /staging, want to move with new filename just the firstpart upto underscore, example 20180904105056.dat, how can i get upto first part of filename and validate to chk if... (2 Replies)
Discussion started by: cplusplus1
2 Replies

LEARN ABOUT SUSE

gjar

GJAR(1) 								GNU								   GJAR(1)

NAME

       gjar - - Archive tool for Java archives

SYNOPSIS

       gjar -ctxui [OPTIONS] jar-file [-C DIR FILE] FILE...

DESCRIPTION

       gjar is an implementation of Sun's jar utility that comes with the JDK.

       If any file is a directory then it is processed recursively.  The manifest file name and the archive file name needs to be specified in the
       same order the -m and -f flags are specified.

OPTIONS

       Operation mode:

       -c  Create new archive.

       -t  List table of contents for archive.

       -x  Extract named (or all) files from archive.

       -u  Update existing archive.

       -i FILE
	   Compute archive index.

       Operation modifiers:

       -f FILE
	   Specify archive file name.

       -0  Store only; use no ZIP compression.

       -v  Generate verbose output on standard output.

       -M  Do not create a manifest file for the entries.

       -m manifest
	   Include manifest information from specified manifest file.

       File name selection:

       -C DIR FILE
	   Change to the DIR and include the following FILE.

       -@  Read the names of the files to add to the archive from stdin.  This option is supported only in combination with -c or -u.  Non
	   standard option added in the GCC version.

       Standard options:

       -help
	   Print help text, then exit.

       -version
	   Print version number, then exit.

       -JOPTION
	   Pass argument to the Java runtime.

BUGS

SEE ALSO

       java(1), ...

AUTHOR

0.98								    2010-07-05								   GJAR(1)
All times are GMT -4. The time now is 02:50 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy