Extracting rows from a space delimited text file based on the values of a column

10 More Discussions You Might Find Interesting

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

2. Shell Programming and Scripting

Script for extracting data from csv file based on column values.

Hi all, I am new to shell script.I need your help to write a shell script. I need to write a shell script to extract data from a .csv file where columns are ',' separated. The file has 5 columns having values say column 1,column 2.....column 5 as below along with their valuesm....

3. UNIX for Dummies Questions & Answers

Extracting rows from a text file if the value of a column falls between a certain range

Hi, I have a file that looks like the following: 10 100080417 rs7915867 ILMN_1343295 12 6243093 7747537 10 100190264 rs2296431 ILMN_1343295 12 6643093 6647537 10 100719451 SNP94374 ILMN_1343295 12 6688093 7599537 ...

4. UNIX for Dummies Questions & Answers

Swap two rows in a space delimited text file?

Hi, How do you swap two rows in a space delimited text file? Thanks!

5. UNIX for Dummies Questions & Answers

Extracting rows from a text file based on the values of two columns (given ranges)

Hi, I have a tab delimited text file with multiple columns. The second and third columns include numbers that have not been sorted. I want to extract rows where the second column includes a value between -0.01 and 0.01 (including both numbers) and the first third column includes a value between...

6. UNIX for Dummies Questions & Answers

Adding tags to a specific column of a space delimited text file

I have a space delimited text file with two columns. I would like to add NA to the first column of the text file. Input: 19625 10.4791768259 19700 10.8146489183 19701 10.9084026759 19702 10.9861346978 19703 10.9304364984 Output: NA19625 10.4791768259 NA19700 10.8146489183...

7. UNIX for Dummies Questions & Answers

Extracting rows from a text file based on numerical values of a column

I have a text file where the second column is a list of numbers going from small to large. I want to extract the rows where the second column is smaller than or equal to 0.0001. My input: rs10082730 9e-08 12 46002702 rs2544081 1e-07 12 46015487 rs1425136 1e-06 7 35396742 rs2712590...

8. UNIX for Dummies Questions & Answers

Extracting rows from a text file based on the first column

I have a tab delimited text file where the first column can take on three different values : 100, 150, 250. I want to extract all the rows where the first column is 100 and put them into a separate text file and so on. This is what my text file looks like now: 100 rs3794811 0.01 0.3434 100...

9. UNIX for Dummies Questions & Answers

Extracting rows from a text file based on the first column

10. UNIX for Dummies Questions & Answers

How to echo space or tab delimited values into rows?

Hi, I have the following code: LIST=`ls | grep '.sql$'` echo $LIST The above code will give me something like.. file1.sh file2.sh file3.sh file4.sh file5.sh I want to display the values into rows using echo like... file1.sh file2.sh

LEARN ABOUT OPENDARWIN

funtablerowget

funtablerowget(3)						SAORD Documentation						 funtablerowget(3)

NAME

       FunTableRowGet - get Funtools rows

SYNOPSIS

	 #include <funtools.h>

	 void *FunTableRowGet(Fun fun, void *rows, int maxrow, char *plist,
			      int *nrow)

DESCRIPTION

       The FunTableRowGet() routine retrieves rows from a Funtools binary table or raw event file, and places the values of columns selected by
       FunColumnSelect() into an array of user structs.  Selected column values are automatically converted to the specified user data type (and
       to native data format) as necessary.

       The first argument is the Fun handle associated with this row data.  The second rows argument is the array of user structs into which the
       selected columns will be stored. If NULL is passed, the routine will automatically allocate space for this array. (This includes proper
       allocation of pointers within each struct, if the "@" pointer type is used in the selection of columns.	Note that if you pass NULL in the
       second argument, you should free this space using the standard free() system call when you are finished with the array of rows.)  The third
       maxrow argument specifies the maximum number of rows to be returned. Thus, if rows is allocated by the user, it should be at least of size
       maxrow*sizeof(evstruct).

       The fourth plist argument is a param list string.  Currently, the keyword/value pair "mask=transparent" is supported in the plist argument.
       If this string is passed in the call's plist argument, then all rows are passed back to the user (instead of just rows passing the filter).
       This is only useful when FunColumnSelect() also is used to specify "$region" as a column to return for each row.  In such a case, rows
       found within a region have a returned region value greater than 0 (corresponding to the region id of the region in which they are located),
       rows passing the filter but not in a region have region value of -1, and rows not passing any filter have region value of 0. Thus, using
       "mask=transparent" and the returned region value, a program can process all rows and decide on an action based on whether a given row
       passed the filter or not.

       The final argument is a pointer to an int variable that will return the actual number of rows returned.	The routine returns a pointer to
       the array of stored rows, or NULL if there was an error. (This pointer will be the same as the second argument, if the latter is
       non-NULL).

	 /* get rows -- let routine allocate the row array */
	 while( (buf = (Ev)FunTableRowGet(fun, NULL, MAXROW, NULL, &got)) ){
	   /* process all rows */
	   for(i=0; i<got; i++){
	     /* point to the i'th row */
	     ev = buf+i;
	     /* rearrange some values. etc. */
	     ev->energy = (ev->pi+ev->pha)/2.0;
	     ev->pha = -ev->pha;
	     ev->pi = -ev->pi;
	   }
	   /* write out this batch of rows */
	   FunTableRowPut(fun2, buf, got, 0, NULL);
	   /* free row data */
	   if( buf ) free(buf);
	 }

       As shown above, successive calls to FunTableRowGet() will return the next set of rows from the input file until all rows have been read,
       i.e., the routine behaves like sequential Unix I/O calls such as fread(). See evmerge example code for a more complete example.

       Note that FunTableRowGet() also can be called as FunEventsGet(), for backward compatibility.

SEE ALSO

       See funtools(7) for a list of Funtools help pages

version 1.4.2							  January 2, 2008						 funtablerowget(3)

UNIX for Dummies Questions & Answers