Match values/IDs from column and text files Post: 302601454

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Finding multiple column values and match in a fixed length file

Hi, I have a fixed length file where I need to verify the values of 3 different fields, where each field will have a different value. How can I do that in a single step.

2. Shell Programming and Scripting

Cat Values from Several files if it meets criteria for column values

I have results from some statistical analyses. The format of the results are as given below: I want to select lines that have a p-value (last column) less than 0.05 from all the results files (*.results) and cat to a new results file. It would be very nice if a new column is added that tells...

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

4. UNIX for Dummies Questions & Answers

Merging two text files by a column and filling in the missing values

Hi, I have to text files that I want to merge by the first column. The values in the first column pretty much match for the first part. However there are some values that are present in column 1 and not present in column 2 or vice versa. For such values I would like to substitute X for the...

5. Shell Programming and Scripting

Adding Column Values Using Pattern Match

Hi All, I have a file with data as below: A,FILE1_MYFILE_20130309_1038,80,25.60 B,FILE1_MYFILE_20130309_1038,24290,18543.38 C,FILE1_dsc_dlk_MYFILE_20130309_1038,3,10.10 A,FILE2_MYFILE_20130310_1039,85,110.10 B,FILE2_MYFILE_20130310_1039,10,12.10...

6. Shell Programming and Scripting

awk Print New Column For Every Two Lines and Match On Multiple Column Values to print another column

Hi, My input files is like this axis1 0 1 10 axis2 0 1 5 axis1 1 2 -4 axis2 2 3 -3 axis1 3 4 5 axis2 3 4 -1 axis1 4 5 -6 axis2 4 5 1 Now, these are my following tasks 1. Print a first column for every two rows that has the same value followed by a string. 2. Match on the...

7. Shell Programming and Scripting

Match value in column and append file with new values

Hi, I need help to match two files based on two columns. file_1 ID AA An Ca Ele Pro Su Ot Tra g13950 No No Yes No Yes Yes Yes Yes g05760 Yes No No No No Yes Yes Yes g12640 No No No No No No No No k17720 No Yes No No No No No Yes g05640 Yes Yes Yes No No Yes Yes Yes file_2 ...

8. UNIX for Dummies Questions & Answers

Match sum of values in each column with the corresponding column value present in trailer record

Hi All, I have a requirement where I need to find sum of values from column D through O present in a CSV file and check whether the sum of each Individual column matches with the value present for that corresponding column present in the trailer record. For example, let's assume for column D...

9. Shell Programming and Scripting

Extracting values based on line-column numbers from multiple text files

Dear All, I have to solve the following problems with multiple tab-separated text file but I don't know how. Any help would be greatly appreciated. I have access to Linux mint (but not as a professional). I have multiple tab-delimited files with the following structure: file1: 1 44 2 ...

10. UNIX for Beginners Questions & Answers

Match duplicate ids in two files

I have two text files. File 1 has 150 ids but all the ids exists in duplicates so it has 300 ids in total. File 2 has 1500 ids but all exists in duplicates so file 2 has 300 ids in total. i want to match the first occurance of every id in file 1 with first occurance of thet id in file 2 and 2nd...

LEARN ABOUT SUNOS

fspec

fspec(4)							   File Formats 							  fspec(4)

NAME

       fspec - format specification in text files

DESCRIPTION

       It  is  sometimes  convenient  to maintain text files on the system with non-standard tabs, (tabs that are not set at every eighth column).
       Such files must generally be converted to a standard format, frequently by replacing all tabs with the appropriate number of spaces, before
       they  can  be  processed by system commands. A format specification occurring in the first line of a text file specifies how tabs are to be
       expanded in the remainder of the file.

       A format specification consists of a sequence of parameters separated by blanks and surrounded by the brackets <: and  :>.  Each  parameter
       consists of a keyletter, possibly followed immediately by a value. The following parameters are recognized:

       ttabs	       The t parameter specifies the tab settings for the file. The value of tabs must be one of the following:

			 o  A list of column numbers separated by commas, indicating tabs set at the specified columns.

			 o  A '-' followed immediately by an integer n, indicating tabs at intervals of n columns.

			 o  A '-' followed by the name of a ``canned'' tab specification.

		       Standard  tabs  are  specified by t-8, or equivalently, t1,9,17,25, etc. The canned tabs that are recognized are defined by
		       the tabs(1) command.

       ssize	       The s parameter specifies a maximum line size. The value of size must be an integer. Size checking is performed after  tabs
		       have been expanded, but before the margin is prepended.

       mmargin	       The m parameter specifies a number of spaces to be prepended to each line. The value of margin must be an integer.

       d	       The  d  parameter takes no value. Its presence indicates that the line containing the format specification is to be deleted
		       from the converted file.

       e	       The e parameter takes no value. Its presence indicates that the current format is to  prevail  only  until  another  format
		       specification is encountered in the file.

       Default	values,  which	are  assumed for parameters not supplied, are t-8 and m0. If the s parameter is not specified, no size checking is
       performed. If the first line of a file does not contain a format specification, the above defaults are assumed for  the	entire	file.  The
       following is an example of a line containing a format specification:

	      * <:t5,10,15 s72:> *

       If a format specification can be disguised as a comment, it is not necessary to code the d parameter.

SEE ALSO

       ed(1), newform(1), tabs(1)

SunOS 5.10							    3 Jul 1990								  fspec(4)