Sponsored Content
Operating Systems Linux Ubuntu Match col 1 of File 1 with col 1 File 2 and create a 3rd file Post 302329986 by rakeshawasthi on Tuesday 30th of June 2009 01:38:55 AM
Old 06-30-2009
give some sample input of both the files
and desired output, and
conditions how the two files will be joined.
PS:- Use code tags
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sum(col) finding from a file

Hi I have an file which looks like country address phone amount sweden |address |phone | 10 | Singapo |address |phone | 20 | Italy-N |address |phone | 30 | denmar |address |phone | 40 | Here i need to do the sum(amount), how to do this in shell scripting Thanks Babu (11 Replies)
Discussion started by: ksmbabu
11 Replies

2. Shell Programming and Scripting

sort and split file by 2 cols (1 col after the other)

Dear All, I am a newbie to shell scripting so this one is really over my head. I have a text file with five fields as below: 76576.867188 6232.454102 2.008904 55.000000 3 76576.867188 6232.454102 3.607231 55.000000 4 76576.867188 6232.454102 1.555146 65.000000 3 76576.867188 6232.454102... (19 Replies)
Discussion started by: Ghetz
19 Replies

3. Shell Programming and Scripting

Compare - 1st col of file

Hi, I have two different files, one has two columns and other has only one column. I would like to compare the first column in the first file with the data in the second file and write a third file with the data that is not present is not common to them. First file:... (26 Replies)
Discussion started by: swame_sp
26 Replies

4. Shell Programming and Scripting

Get columns from another file for match in col 2 in 1st file

Hi, My first file has 592155 9 rs16916098 1 592156 19 rs7249604 1 592157 4 rs885156 1 592158 5 rs350067 12nd file has 9 rs16916098 0 113228129 2 4 19 rs7249604 0 58709070 4 2 2 rs17042833 0 113558750 4 2... (2 Replies)
Discussion started by: genehunter
2 Replies

5. Shell Programming and Scripting

how to add new col in a file

Hi, Experts, I have a requirement as following: my source file: a a a b b c c c c I need add one more colume as following: 1 a 2 a 3 a 1 b 2 b 1 c 2 c (4 Replies)
Discussion started by: ken002
4 Replies

6. UNIX for Advanced & Expert Users

Print line based on highest value of col (B) and repetion of values in col (A)

Hello everyone, I am writing a script to process data from the ATP world tour. I have a file which contains: t=540 y=2011 r=1 p=N409 t=540 y=2011 r=2 p=N409 t=540 y=2011 r=3 p=N409 t=540 y=2011 r=4 p=N409 t=520 y=2011 r=1 p=N409 t=520 y=2011 r=2 p=N409 t=520 y=2011 r=3 p=N409 The... (4 Replies)
Discussion started by: imahmoud
4 Replies

7. Shell Programming and Scripting

Printing from col x to end of line, except last col

Hello, I have some tab delimited data and I need to move the last col. I could hard code it, awk '{ print $1,$NF,$2,$3,$4,etc }' infile > outfile but it would be nice to know the syntax to print a range cols. I know in cut you can do, cut -f 1,4-8,11- to print fields 1,... (8 Replies)
Discussion started by: LMHmedchem
8 Replies

8. Shell Programming and Scripting

Run a program-print parameters to output file-replace op file contents with max 4th col

Hi Friends, This is the only solution to my task. So, any help is highly appreciated. I have a file cat input1.bed chr1 100 200 abc chr1 120 300 def chr1 145 226 ghi chr2 567 600 unix Now, I have another file by name input2.bed (This file is a binary file not readable by the... (7 Replies)
Discussion started by: jacobs.smith
7 Replies

9. Shell Programming and Scripting

Modifying col values based on another col

Hi, Please help with this. I have several excel files (with and .xlsx format) with 10-15 columns each. They all have the same type of data but the columns are not ordered in the same way. Here is a 3 column example. What I want to do add the alphabet from column 2 to column 3, provided... (9 Replies)
Discussion started by: newbie83
9 Replies

10. Shell Programming and Scripting

Replace col 23 - 26 with new value, non delimited file

hello, i have a undelimited file which contains 229 byte records. i want to change column 23 - 26 with a new value and also change the sign of the data in colulmn 30 - 70. i've tried SED for the first change, but nothing happens: sed 's/\(^.\{22\}\).\{4\}\(.*\)/\0603\2/' inputfile heres an... (8 Replies)
Discussion started by: blt123
8 Replies
etags(1)						      General Commands Manual							  etags(1)

NAME
etags - Generates a tags file for the emacs or mule editor SYNOPSIS
etags [-a | -append] [-C | -c++] [-D | -no-defines] [-i tagsfile2 | -include=tagsfile2] [-o tagsfile | -output=tagsfile] [-S | -ignore-indentation] [-H | -help] [-V | -version] filename... OPTIONS
Appends output to an existing vi-format tags file. (Supports operation of the emacs editor in vi mode.) Treats files with or extensions as C++, rather than C, code. The etags command always treats files with extensions as C++ code. Does not create tag entries for C preproces- sor definitions. If many header files are tagged, using this option may make the tags file much smaller. Includes a note in the output tags file to indicate that, when searching for a tag, one should also consult the tagsfile2 tags file. Explicitly names the output tags file; overrides the default name, which is TAGS. Instructs etags not to rely on indentation to determine nesting level. Currently, this means not to assume that a closing brace in the first column is the final brace in a function or structure definition in C or C++ code. Prints usage information. Prints the current version of the program. OPERANDS
Specifies the input language source file, or files, to be processed. DESCRIPTION
The etags program creates a tag table file in a format understood by the emacs editor. The program understands the syntax of C, C++, For- tran, Pascal, and Lisp source files. It reads the source files specified on the command line and writes a tag table (named TAGS by default) in the working directory. Recognition of the language used in an input file is based on the filename extension and file contents; there are no options for specifying the language. NOTES
The etags program is software distributed by the Free Software Foundation. SEE ALSO
Commands: emacs(1), mule(1) etags(1)
All times are GMT -4. The time now is 10:38 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy