Sponsored Content
Full Discussion: match 2 files by values
Top Forums Shell Programming and Scripting match 2 files by values Post 302593527 by rdcwayx on Friday 27th of January 2012 07:10:59 AM
Old 01-27-2012
You post so many topics, but never thanks to anyone?

Seem some similar topics already posted by you, so many codes you need understand from them first.

Show us what you have done, not just waiting for others' free help.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Match values from 2 files and append certain fields

Hi, I need help on appending certain field in my file1.txt based on matched patterns in file2.txt using awk or sed. The blue color need to match with one of the data in field $2 in file2.txt. If match, BEGIN and FINISHED value in red will have a new value from field $3 and $4 accordingly. ... (1 Reply)
Discussion started by: redse171
1 Replies

2. Shell Programming and Scripting

Get values from different columns from file2 when match values of file1

Hi everyone, I have file1 and file2 comma separated both. file1 is: Header1,Header2,Header3,Header4,Header5,Header6,Header7,Header8,Header9,Header10 Code7,,,,,,,,, Code5,,,,,,,,, Code3,,,,,,,,, Code9,,,,,,,,, Code2,,,,,,,,,file2... (17 Replies)
Discussion started by: cgkmal
17 Replies

3. UNIX for Dummies Questions & Answers

Comparing two text files by a column and printing values that do not match

I have two text files where the first three columns are exactly the same. I want to compare the fourth column of the text files and if the values are different, print that row into a new output file. How do I go about doing that? File 1: 100 rs3794811 0.01 0.3434 100 rs8066551 0.01... (8 Replies)
Discussion started by: evelibertine
8 Replies

4. UNIX for Dummies Questions & Answers

Match values/IDs from column and text files

Hello, I am trying to modify 2 files, to yield results in a 3rd file. File-1 is a 8-columned file, separted with tab. 1234:1 xyz1234 blah blah blah blah blah blah 1234:1 xyz1233 blah blah blah blah blah blah 1234:1 abc1234 blah blah blah blah blah blah n/a RRR0000 blah blah blah... (1 Reply)
Discussion started by: ad23
1 Replies

5. UNIX for Dummies Questions & Answers

Comparing two test files and printing out the values that do not match

Hi, I have two text files with matching first columns. Some of the values in the second column do not match. I want to write a script to print out the rows (only the first column) where the values in the second column do not match. Example: Input 1 A 1 B 2 C 3 D 4 Input 2 A 2 B 2... (6 Replies)
Discussion started by: evelibertine
6 Replies

6. Shell Programming and Scripting

Using awk to match strings and outputing their corresponding values

Hi I will appreciate it if you can help me out. I have a file that contains this data System Load: 3244 card: 1903 CPU: 6% card: 1904 CPU: 6% card: 1905 CPU: 28% card: 1906 CPU: 28% card: 1907 CPU: 36% card: 1908 CPU: 37% I need to manipulate and output this as system_load:3244... (2 Replies)
Discussion started by: kaf3773
2 Replies

7. Shell Programming and Scripting

Match values in awk

Having trouble modifying the below awk to match $1 of sample.txt to $1 of data.txt and if there is a match, then $2 of data.txt is copied to $7 of sample.txt. Thank you :). awk 'NR==FNR{A=$1; next} A {$1=$1 " " A}1' data.txt sample.txt > output.txt Desired Output: Data... (3 Replies)
Discussion started by: cmccabe
3 Replies

8. Shell Programming and Scripting

awk to match field between two files and use conditions on match

I am trying to look for $2 of file1 (skipping the header) in $2 of file2 (skipping the header) and if they match and the value in $10 is > 30 and $11 is > 49, then print the line from file1 to a output file. If no match is foung the line is not printed. Both the input and output are tab-delimited.... (3 Replies)
Discussion started by: cmccabe
3 Replies

9. Shell Programming and Scripting

Match value in two files and replace values in selected columns

The purpose is to check if values for column 3 and 4 in file1 match with column 1 in file2. If any value match do: 1) Replace values in file2 for column 2 and 3 using the information of file1 columns 5 and 6 2) Replace string ($1,1,5) and string ($1,6,5) in file2 with values of columns 7... (8 Replies)
Discussion started by: jiam912
8 Replies

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... (4 Replies)
Discussion started by: axis88
4 Replies
NBIBTEX(1)						      General Commands Manual							NBIBTEX(1)

NAME
nbibtex - make a bibliography for LaTeX SYNOPSIS
nbibtex [options] auxname[.aux] [bibname...] DESCRIPTION
NbibTeX is a drop-in replacement for BibTeX. It reads the top-level auxiliary (.aux) file that was output during the running of latex(1) or tex(1) and creates a bibliography (.bbl) file that will be incorporated into the document on subsequent runs of LaTeX or TeX. NbibTeX looks up, in bibliographic database (.bib) files specified by the ibliography command, the entries specified by the cite and ocite commands in the LaTeX or TeX source file. The association of cite command with .bib entry is made by a simple query language described below. NbibTeX formats the information from the .bib entries according to instructions in a bibliography style (.nbs) file (specified by the ibliographystyle command, and it outputs the results to the .bbl file. If the optional bibnames are used, NbibTeX looks in the named bibliographies instead of those specified by the ibliography command. A bibname without a slash (/) character means the same thing it would mean in a ibliographystyle command: it is looked up according to the rules of BibTeX. A bibname with a slash character is taken to be the absolute or relative pathname of a .bib file. Explicit bibnames can be used with the -bib and -o options to make a paper-specific .bib file from larger .bib files. The LaTeX manual explains what a LaTeX source file must contain to work with NbibTeX. Appendix B of the manual describes the format of the .bib files. The `NbibTeXing' document describes extensions and details of this format, and it gives other useful hints for using NbibTeX. OPTIONS
-min-crossrefs=number The -min-crossrefs option defines the minimum number of crossref required for automatic inclusion of the crossref'd entry on the citation list; the default is 2. -terse Accepted for backward compatibility with BibTeX; NbibTeX is terse by default. -permissive Enables NbibTeX to continue working even when some of the .bib files mentioned in the ibliography command are missing. Also tells NbibTeX not to object if duplicate entries are found in multiple .bib files. -strict Tells NbibTeX to complain about all irregularities it spots in any .bib file it parses. By default, NbibTeX (like BibTeX) com- plains only about entries it actually intends to use. -o file Writes the bibliography to file instead of to the default auxname.bbl. If file is -, writes to standard output. -bib Instead of writing a bibliography for use by LaTeX, writes exactly those NbibTeX entries needed by auxname. Useful for making paper-specific .bib files. -help Emit a short help message and exit. -version Emit version information and exit. EXAMPLES
To make a normal bibliography for file paper.tex: nbibtex paper b To use the personal .bib file personal.bib to make a paper-specific bibliography for file paper.tex, which should use the command logra- phy{paper}: nbibtex -o paper.bib -bib paper personal The file personal.bib should be found on the usual BIBINPUTS path. To extend the bibliography paper.bib by filling in missing entries from personal.bib: nbibtex -permissive -o paper.bib -bib paper paper personal QUERY LANGUAGE
To specify a paper you wish to cite, classic BibTeX requires an arbitrary key. The advantage of NbibTeX is that you cite a paper by the contents of the NbibTeX entry. The citation consists of a sequence of one or more constraints separated by colons. A constraint may be empty. A nonempty constraint is of the form key=words, where key is the name of a field in the NbibTeX entry and words is a sequence of one or more words separated by dashes. The contraint is satisfied if every word in words is found in the field named by key. (The key may also be [type], which matches agains the type of the entry, or *, which looks for words in any field.) For example, the following queries might match an entry for a useful source on arithmetic: author=knuth:series=art-programming:volume=2 author=knuth:title=seminumerical:year=1981 As a convenience, keys may be defaulted in up to three constraints. In the first constraint, the default key is author (or if there is no author, editor). In the second constraint, the default key is year if words is all digits, and is title otherwise. In the third con- straint, the default key is year if words is all digits, and is [type] otherwise. So for example, we could have written knuth:seminumerical:1981 To match a word in words, BX uses the Boyer-Moore string-matching algorithm, so longer words are usually faster. NbibTeX's query language can be used on the command line by nbibfind(1). NBIBTEX STYLES AND COMPATIBILITY WITH BibTeX Like BibTeX, NbibTeX supports a variety of "styles" of bibliography. Each style is defined by a program written in Lua, using additional primitives suitable to construction of bibliographies. NbibTeX provides the three standard styles in a form suitable for use with the nat- bib package. Two of these styles (abbrvnat and unsrtnat) are completely compatible with the corresponding BibTeX styles; the third style (plainnat) has been changed to more closely follow the Chicago Manual of Style. A compatible version is available as style plainnatc. Additional styles may be created by writing new Lua code; for example, an author wishing to create a style called mcbride would put a file called mcbride.nbs (for New BibTeX Style) in the directory /usr/share/nbibtex. For guidance on what goes into such a file, consult the other files in that directory and the literate source code for NbibTeX. ENVIRONMENT
For .bib files, NbibTeX searches the directories in the path defined by the BIBINPUTS environment variable if that is set, otherwise the default. For details of the searching, see tex(1) and kpsewhich(1). No special searching is done for the .aux file. FILES
/usr/share/nbibtex/*.nbs New bibliography style files. BUGS
Although I have made some effort in this direction, compatibility with BibTeX does not extend to .bib files containing non-ASCII charac- ters. SEE ALSO
nbibfind(1), latex(1), tex(1), kpsewhich(1), bibtex(1). Leslie Lamport, LaTeX - A Document Preparation System, Addison-Wesley, 1985, ISBN 0-201-15790-X. The NbibTeX home page at http://www.eecs.harvard.edu/~nr/nbibtex. The Lua home page at http://www.lua.org. AUTHOR
Norman Ramsey, Harvard University. 15 May 2006 NBIBTEX(1)
All times are GMT -4. The time now is 07:27 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy