Matching string on two files based on match rules. Post: 302479793

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...

2. Shell Programming and Scripting

awk to print lines based on string match on another line and condition

Hi folks, I have a text file that I need to parse, and I cant figure it out. The source is a report breaking down softwares from various companies with some basic info about them (see source snippet below). Ultimately what I want is an excel sheet with only Adobe and Microsoft software name and...

3. Shell Programming and Scripting

Matching 2 files based on one column

Hi, On a similar subject, the following. I have two files: file1.txt dbSNP_rsID,Chromosome,Position,Gene rs10399749,chr. 01,45162,? rs4030303,chr. 01,72434,? rs4030300,chr. 01,72515,? rs940550,chr. 01,78032,? rs13328714,chr. 01,81468,? rs11490937,chr. 01,222077,? rs6683466,chr....

4. Shell Programming and Scripting

Based on column in file1, find match in file2 and print matching lines

file1: file2: I need to find matches for any lines in file1 that appear in file2. Desired output is '>' plus the file1 term, followed by the line after the match in file2 (so the title is a little misleading): This is honestly beyond what I can do without spending the whole night on it, so I'm...

5. Shell Programming and Scripting

Match part of string in file2 based on column in file1

I have a file containing texts and indexes. I need the text between (and including ) INDEX and number "1" alone in line. I have managed this: awk '/INDEX/,/1$/{if (!/1$/)print}' file1.txt It works for all indexes. And then I have second file with years and indexes per year, one per line...

6. Shell Programming and Scripting

Need to print the next word from the same line based on grep string condtion match.

I need to fetch particular string from log file based on grep condition match. Actual requirement is need to print the next word from the same line based on grep string condtion match. File :Java.lanag.xyz......File copied completed : abc.txt Ouput :abc.txt I have used below...

7. Shell Programming and Scripting

New files based off match or no match

Trying to match $2 in original_targets with $2 of new_targets . If the two numbers match exactly then a match.txt file is outputted using the information in the new_targets in the beginning 4 fields $1, $2, $3, $4 and value of $4 in the original_targets . If there is "No Match" then a no...

8. Shell Programming and Scripting

awk to print fields that match using conditions and a default value for non-matching in two files

Trying to use awk to match the contents of each line in file1 with $5 in file2. Both files are tab-delimited and there may be a space or special character in the name being matched in file2, for example in file1 the name is BRCA1 but in file2 the name is BRCA 1 or in file1 name is BCR but in file2...

9. Shell Programming and Scripting

Matching two fields in two csv files, create new file and append match

I am trying to parse two csv files and make a match in one column then print the entire file to a new file and append an additional column that gives description from the match to the new file. If a match is not made, I would like to add "NA" to the end of the file Command that Ive been using...

10. UNIX for Beginners Questions & Answers

Data match 2 files based on first 2 columns matching only and join if match

Hi, i have 2 files , the data i need to match is in masterfile and i need to pull out column 3 from master if column 1 and 2 match and output entire row to new file I have tried with join and awk and i keep getting blank outputs or same file is there an easier way than what i am...

LEARN ABOUT OSF1

explain

diction(1)						      General Commands Manual							diction(1)

NAME

       diction, explain, suggest - Prints wordy sentences and looks them up in an interactive thesaurus.

SYNOPSIS

       diction [-fpattern_file] [-k] [-ma] [-me] [-ml] [-ms] [-n] [file...]

       explain

       suggest

       The  diction command finds all sentences in an English language document that contain phrases from a database of bad or wordy diction.  The
       explain command is an interactive thesaurus for the English language phrases found by the diction command and only for those phrases.

       The diction command reads from standard in if no file operand is provided.

       The suggest command is a synonym for explain.

OPTIONS

       Names a user-created pattern file to be used in addition to the default file.  Passes the -k option to the deroff command.  The	-k  option
       keeps  blocks  of  text	specified nroff by requests or macros; for example, the request.  Passes the -ma option to deroff.  The -ma option
       interprets nroff man macros only.  Overrides the default nroff -ms macro package.  Causes deroff to skip lists; should be used if  a  docu-
       ment  contains  many  lists of nonsentences.  Overrides the default nroff -ms macro package.  Suppresses use of the default file (used with
       -f).  Only the user-created pattern file is used.

DESCRIPTION

       Each phrase found by the diction command is enclosed in [ ] (brackets).	Because diction runs deroff before looking at  the  text,  include
       formatting header files as part of the input.

       Before using the explain command, use the diction command to obtain a list of poorly worded phrases.  When you use the explain command, the
       system prompts you for a phrase and responds with a grammatically acceptable alternative.  You can continue typing phrases, or you can exit
       by pressing the End-of-File key sequence.

       The explain command can also take input redirected from a file. No other command line arguments are valid.

NOTES

       Use of nonstandard formatting macros may cause incorrect sentence breaks.  In particular, diction does not understand -me.

FILES

       Default pattern file.  Thesaurus used by the explain command.

SEE ALSO

       Commands:  deroff(1), nroff(1)

																	diction(1)