Sponsored Content
Top Forums Shell Programming and Scripting Merge two file data together based on specific pattern match Post 302372892 by patrick87 on Thursday 19th of November 2009 03:56:42 AM
Old 11-19-2009
Merge two file data together based on specific pattern match

My input:
File_1:
2000_t
g1110.b1
abb.1
2001_t
g1111.b1
abb.2
abb.2
g1112.b1
abb.3
2002_t
.
.

File_2:
2000_t Ali england 135
abb.1 Zoe british 150
2001_t Ali england 305
g1111.b1 Lucy russia 126
abb.2 Zoe british 500
abb.2
g1112.b1 Lucy russia 180
abb.3 Zoe british 700
.
.

My desired output file:
2000_t Ali england 135
g1110.b1
abb.1 Zoe british 150
2001_t Ali england 305
g1111.b1 Lucy russia 126
abb.2 Zoe british 500
abb.2
g1112.b1 Lucy russia 180
abb.3 Zoe british 700
2002_t
.
.

My main purpose is merge both file_1 and file_2 data together. All the file_1 data must be in output file. File_2 data will be append to the output file based on those same data of column 1 in both file. In between, some of the file_1 content might be appear twice. Thanks a lot.

Last edited by patrick87; 11-19-2009 at 05:58 AM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Concatenating and appending string based on specific pattern match

Input #GEO-1-type-1-fwd-Initial 890 1519 OPKHIJEFVTEFVHIJEFVOPKHIJTOPKEFVHIJTEFVOPKOPKHIJHIJHIJTTOPKHIJHIJEFVEFVOPKHIJOPKHIJOPKEFVEFVOPKHIJHIJEFVHIJHIJEFVTHIJOPKOPKTEFVEFVEFVOPKHIJOPKOPKHIJTTEFVEFVTEFV #GEO-1-type-2-fwd-Terminal 1572 2030... (7 Replies)
Discussion started by: patrick87
7 Replies

2. Shell Programming and Scripting

Paste two file side by side together based on specific pattern match problem

Input file_1: P78811 P40108 O17861 Q6NTW1 P40986 Q6PBK1 P38264 Q6PBK1 Q9CZ49 Q1GZI0 Input file_2: (6 Replies)
Discussion started by: patrick87
6 Replies

3. Shell Programming and Scripting

Merge lines in text file based on pattern

Hello, I have searched forum trying to find a solution to my problem, but could not find anything or I did not understand the examples.... I should say, I am very inexperienced with text processing. I have a text file with approx 60k lines in it. I need to merge lines based on the number... (8 Replies)
Discussion started by: Bertik
8 Replies

4. Shell Programming and Scripting

fetch last line no form file which is match with specific pattern by grep command

Hi i have a file which have a pattern like this Nov 10 session closed Nov 10 Nov 9 08:14:27 EST5EDT 2010 on tty . Nov 10 Oct 19 02:14:21 EST5EDT 2010 on pts/tk . Nov 10 afrtetryytr Nov 10 session closed Nov 10 Nov 10 03:21:04 EST5EDT 2010 Dec 8 Nov 10 05:03:02 EST5EDT 2010 ... (13 Replies)
Discussion started by: Himanshu_soni
13 Replies

5. Shell Programming and Scripting

Help with replace line based on specific pattern match

Input file data20714 7327 7366 detail data20714 7327 7366 main data250821 56532 57634 detail data250821 57527 57634 main data250821 57359 57474 main data250821 57212 57301 main data250821 57140 57159 detail data250821 56834 57082 main data250821 56708 56779 main ... (3 Replies)
Discussion started by: perl_beginner
3 Replies

6. Shell Programming and Scripting

Help with ksh-to read ip file & append lines to another file based on pattern match

Hi, I need help with this- input.txt : L B white X Y white A B brown M Y black Read this input file and if 3rd column is "white", then add specific lines to another file insert.txt. If 3rd column is brown, add different set of lines to insert.txt, and so on. For example, the given... (6 Replies)
Discussion started by: prashob123
6 Replies

7. Shell Programming and Scripting

How to merge variable data from another file into specific place?

Hello, I'm trying to create multiple commands using a variable input from another file but am not getting any successful results. Basically, file1.txt contains multiple lines with single words: <file1.txt> yellow blue black white I want to create multiple echo commands with these... (8 Replies)
Discussion started by: demmel
8 Replies

8. Shell Programming and Scripting

Match all lines in file where specific text pattern is less than

In the below file I am trying to grep or similar, all lines where only AF= is less than 0.4.. Thank you :). grep grep "AF=" ,+ .4 file file 12 112036782 . T C 34.0248 PASS ... (3 Replies)
Discussion started by: cmccabe
3 Replies

9. Shell Programming and Scripting

awk to update value based on pattern match in another file

In the awk, thanks you @RavinderSingh13, for the help in below, hopefully it is close as I am trying to update the value in $12 of the tab-delimeted file2 with the matching value in $1 of the space delimeted file1. I have added comments for each line as well. Thank you :). awk awk '$12 ==... (10 Replies)
Discussion started by: cmccabe
10 Replies

10. Shell Programming and Scripting

Bash to move specific files to directory based on match to file

I am trying to mv each of the .vcf files in the variants folder to the folder in /home/cmccabe/f2 that the .vcf id is found in file. $2 in file will always have the id of a .vcf in the variants folder. The line in blue staring with R_2019 in file up to the -v5.6 will always be an exact match to a... (4 Replies)
Discussion started by: cmccabe
4 Replies
SPELL(1)						    BSD General Commands Manual 						  SPELL(1)

NAME
spell -- find spelling errors SYNOPSIS
spell [-biltvx] [-d list] [-h spellhist] [-m a | e | l | m | s] [-s stop] [+extra_list] [file ...] DESCRIPTION
spell collects words from the named documents and looks them up in a spelling list. Words that neither occur among nor are derivable (by applying certain inflections, prefixes or suffixes) from words in the spelling list are printed on the standard output. If no files are named, words are collected from the standard input. spell ignores most troff(1), tbl(1), eqn(1), and pic(1) constructions. Copies of all output may be accumulated in the history file, if one is specified. By default, spell (like deroff(1)) follows chains of included files (``.so'' and ``.nx'' commands)). The default spelling list is based on Webster's Second International dictionary and should be fairly complete. Words that appear in the ``stop list'' are immediately flagged as misspellings, regardless of whether or not they exist in one of the word lists. This helps filter out misspellings (e.g. thier=thy-y+ier) that would otherwise pass. Additionally, the british file is also used as a stop list unless the -b option is specified. Site administrators may add words to the local word list, /usr/local/share/dict/words or the local stop list, /usr/local/share/dict/stop. All word (and stop) lists must be sorted in lexicographical order with case folded. The simplest way to achieve this is to use ``sort -df''. If the word files are incorrectly sorted, spell will not be able to operate correctly. The options are as follows: -b Check British spelling. Besides preferring centre, colour, speciality, travelled, etc., this option insists upon -ise in words like standardise, Fowler and the OED to the contrary notwithstanding. In this mode, American variants of words are added to the stop list. -d word_list Use the specified word list instead of the default system word list. The word list must be sorted as specified above. -h spellhist Store misspelled words in the specified history file. The output of who -m is appended to the history file after the list of mis- spelled words. -i Instruct deroff(1) to ignore ``.so'' and ``.nx'' commands. -l Use delatex instead of deroff(1) if it is present on the system. -m Enable support for common troff(1) macro packages; this option is passed verbatim to deroff(1). Refer to the --m description in deroff(1) for details. -s stop_list Use the specified stop list instead of the default system stop list. The stop list must be sorted as specified above. -t Use detex instead of deroff(1) if it is present on the system. -v Print all words not literally in the spelling list in addition to plausible derivations from spelling list words. -x Print every plausible stem, prefixed with '='. +extra_list Use extra_list in addition to the default word list. The extra word list must be sorted as specified above. FILES
/usr/share/dict/words Default spelling list /usr/share/dict/american American spelling of certain words /usr/share/dict/british British spelling of certain words /usr/share/dict/stop Default stop list. /usr/local/share/dict/words Local spelling list (optional) /usr/local/share/dict/stop Local stop list (optional) /usr/libexec/spellprog Binary executed by the shell script /usr/bin/spell. SEE ALSO
deroff(1), look(1), sed(1), sort(1), tee(1), troff(1) HISTORY
The spell command appeared in Version 6 AT&T UNIX. Unlike historic versions, the NetBSD spell command does not use hashed word files. Instead, it uses lexicographically sorted files and the same technique as look(1). BUGS
The spelling list lacks many technical terms; new installations will probably wish to monitor the output for several months to gather local additions. British spelling was done by an American. In -x mode it would be nicer if the stems were grouped with the appropriate word. BSD
April 18, 1994 BSD
All times are GMT -4. The time now is 02:14 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy