combine the values from the first two columns within a file

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Add values to file in 2 new columns

Columns 4 and 5 are X and Y coordinates, column 6 is the elevation I would like to add 2 new columns at the end of the file with values the distance between first(X)(Y) and last location (X)(Y), based in 2 rows the difference in elevation = ($6-prev6) How to calculate the requested values...

2. UNIX for Beginners Questions & Answers

Awk: compare values in two columns of the same file

I'm trying to learn awk, but I've hit a roadblock with this problem. I have a hierarchy stored in a file with 3 columns: id name parentID 4 D 2 2 B 1 3 C 1 1 A 5 I need to check if there are any values in column 3 that are not represented anywhere in column 1. I've tried this: awk '{arr;}...

3. Shell Programming and Scripting

Compare multiple files, identify common records and combine unique values into one file

Good morning all, I have a problem that is one step beyond a standard awk compare. I would like to compare three files which have several thousand records against a fourth file. All of them have a value in each row that is identical, and one value in each of those rows which may be duplicated...

4. Shell Programming and Scripting

Combine columns from many files but keep them aligned in columns-shorter left column issue

Hello everyone, I searched the forum looking for answers to this but I could not pinpoint exactly what I need as I keep having trouble. I have many files each having two columns and hundreds of rows. first column is a string (can have many words) and the second column is a number.The files are...

5. Shell Programming and Scripting

Help needed with multiplying two values of two columns in a file

Hi, I am trying to multiply column#1 with column#2 using a shell script. How can I make a for-loop script using 1st column as "i" and the second column as "j" from the following file? Please feel free to share any alternative ways to multiplying column#1 with column#2. .06 5.0000 .49 ...

6. UNIX for Dummies Questions & Answers

Removing columns from a text file that do not have any values in second and third columns

I have a text file that has three columns. But at the end of the text file, there are trailing lines that have missing second and third columns: 4 0.04972604 KLHL28 4 0.0497332 CSTB 4 0.04979822 AIF1 4 0.04983331 DECR2 4 0.04990344 KATNB1 4 4 4 4 How can I remove the trailing...

7. UNIX for Dummies Questions & Answers

Subtracting values from 2 columns in a file

Hello, I have a file with 5 columns that looks like this: A1BG chr19 + 58863335 58866549 A1BG chr19 - 58858171 58864865 A2LD1 chr13 - 101182417 101186056 A2LD1 chr13 - 101182417 101241046 A2M chr12 - 9220303 9268558 A2ML1 ...

8. Shell Programming and Scripting

Math operations with file columns values.

Hello everybody, I have some large files containing statistical data. The data is stored in the following generic format: >cat my_file 1, 2, 3 1, 2, 3 1, 2, 3 > The values of columns no.2 and 3 are expressed in bytes. I would like to transform them in Megabytes, by dividing them with...

9. Shell Programming and Scripting

How to combine 2 files into 1 file with 2 columns

Hi Guys, I want to combine 2 files and and put together in 1 file and make two columns out it. See below desired output. Any help will be much appreciated. inputfile1.txt 12345 67890 24580 inputfile2.txt AAAAA BBBBB CCCCC

10. Shell Programming and Scripting

combine two values within a file

Can you guys help me, I have two files: File A 60|11111| 601|11111| 6012|11111| 6013|11111| 60142|11111| File B 642|11111| 659|11111| 852|11111| 6012|11111| 6013|11111| I want to combine the two file into: File C 60|642| 601|642| 6012|642|

LEARN ABOUT OPENSOLARIS

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  specifi-
		  cation 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.11							    3 Jul 1990								  fspec(4)

UNIX for Dummies Questions & Answers