TABLE_COLUMNS
Extract a column from a file.

TABLE_COLUMNS is a FORTRAN90 program which extracts specified columns of data from a text file.

The file is presumed to consist of lines of data. Blank lines are ok, and are copied to the output file. Lines beginning with a '#' in column 1 are treated as comments, and are copied to the output file.

Each line of data contains several words, separated by one or more spaces or TAB characters. The first word in each line is the first "column", and so on. TABLE_COLUMNS is given a specificiation of which columns are to be copied, in what order, and how often, and copies the necessary information from each line of the input file to the output file.

The specification of columns is simple. You can simply list every column you want, separated by spaces, or if there are several consecutive columns in a row, you can use a colon to indicate a range.

The program can be used in command line form:

table_columns column_spec filein fileout

For example, let us suppose that file.txt contains the lines:

        CAT RED   APPLE 9.5
        MOUSE  BLUE   ORANGE 
        DOG purple  Banana   34.7
      

Then the command

table_columns 2 file.txt mydata.txt

        RED
        BLUE
        purple
      

The command

table_columns 2 3 2 file.txt mydata.txt

        RED APPLE RED
        BLUE ORANGE BLUE
        purple Banana purple
      

The command

table_columns 2:4 2 2 file.txt mydata.txt

        RED   APPLE 9.5 RED RED
        BLUE   ORANGE *** BLUE BLUE
        purple  Banana   34.7 purple purple
      

If some lines of the file do not have the full number of columns, then the program will print a "***" string for that value, which occurred in the last example above.

Related Data and Programs:

TABLE is a file format used for the input to this program.

TABLE_BARPLOT_PPMA is an executable FORTRAN90 program which reads a table file and creates a PPMA bargraph of the data.

TABLE_BORDER is an executable FORTRAN90 program which can be used to add a border (of zero values) to a table file.

TABLE_COLUMNS_PERMUTE is an executable FORTRAN90 program which permutes the columns of a table file.

TABLE_DELAUNAY is an executable FORTRAN90 program which computes the Delaunay triangulation of a set of points.

TABLE_DIAPHONY is an executable FORTRAN90 program which computes the diaphony of a set of points stored in a table file.

TABLE_HISTOGRAM is an executable FORTRAN90 program which can make a histogram of a set of points stored in a table file.

TABLE_IO is a FORTRAN90 library which supplies the routines used to read the TABLE file.

TABLE_LATINIZE is a FORTRAN90 program that reads a file of points and creates a "latinized" version by adjusting the data.

TABLE_MERGE is a FORTRAN90 program that reads a file of points, and removes duplicates, and points that are close to each other.

TABLE_ORTHONORMALIZE is a FORTRAN90 program that reads a file of points and orthonormalizes the columns.

TABLE_QUALITY is a FORTRAN90 program that reads a file of points and computes the quality of dispersion.

TABLE_READ is a MATLAB script that can read in a TABLE file.

TABLE_RECORD_MATCH is an executable program that can be used to find close records in a table file.

TABLE_SCALE is an executable program that can be used to multiply the entries of a table file by a scale vector.

TABLE_SHIFT is an executable FORTRAN90 program which can be used to shift the entries of a table file by a shift vector.

TABLE_STATS is an executable FORTRAN90 program which can read a table file and compute certain statistics.

TABLE_TET_MESH is an executable program that can read a table file of 3D data, and compute a tetrahedral mesh.

TABLE_TOP is an executable FORTRAN90 program that can read a table file of M-dimensional data and make a table of plots of all pairs of coordinates.

TABLE_UNBORDER is an executable program that can be used to remove the border from a table file.

TABLE_UNIFORM_NOISE is an executable program that can be used to add a uniform noise term to the data in a table file.

TABLE_VORONOI is an executable FORTRAN90 program which can be used to compute information about the Voronoi diagram of the points.

Source Code:

• table_columns.f90, the source code;
• table_columns.csh, commands to compile and load the source code;

Examples and Tests:

• input.txt, a sample text file of 4 comments, 1 blank line, 4 data lines each with 4 columns (except that one line has only 3 columns);
• output2122.txt, results of
  "column 2 1 2 2 input.txt output2122.txt";
• output3.txt, results of
  "column 3 input.txt output3.txt";
• output4321.txt, results of
  "column 4 3 2 1 input.txt output4321.txt";

List of Routines:

• MAIN is the main routine for TABLE_COLUMNS.
• COPY_COLUMNS copies specified columns from one file to another.
• GET_UNIT returns a free FORTRAN unit number.
• RANGER "understands" a range defined by a string like '4:8'.
• S_BLANKS_DELETE replaces consecutive blanks by one blank.
• S_CAT2 concatenates two strings to make a third string.
• S_CH_BLANK replaces each occurrence of a particular character by a blank.
• S_TO_I4 reads an I4 from a string.
• S_WORD_COUNT counts the number of "words" in a string.
• TIMESTAMP prints the current YMDHMS date as a time stamp.
• WORD_BOUNDS returns the start and end of each word in a string.
• WORD_FIND finds the word of a given index in a string.

You can go up one level to the FORTRAN90 source codes.