awk for concatenation of column values Post: 302749029

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

averaging column values with awk

Hello. Im just starting to learn awk so hang in there with me...I have a large text file formatted as such everything is in a single column ID001 value 1 value 2 value....n ID002 value 1 value 2 value... n I want to be able to calculate the average for values for each ID from the...

2. Shell Programming and Scripting

How to pick values from column based on key values by usin AWK

Dear Guyz:) I have 2 different input files like this. I would like to pick the values or letters from the inputfile2 based on inputfile1 keys (A,F,N,X,Z). I have done similar task by using awk but in that case the inputfiles are similar like in inputfile2 (all keys in 1st column and values in...

3. Shell Programming and Scripting

problem while adding column values in awk

Hi, I have a file "input.txt" with the following content : 5312,0,,,1,8,141.2,20090727 3714,0,,,1,8,285.87,20090727 5426,0,,,1,8,3.9,20090727 3871,0,,,1,8,30.4,20090727 9071,0,,,1,8,146.2,20090727 5141,0,,,1,8,2.8,20090727 0460,0,,,1,8,-0.1,20090727 7918,0,,,1,8,-0.1,20090727...

4. Shell Programming and Scripting

for each different entry in column 1 extract maximum values from column 2 in unix/awk

Hello, I have 2 columns (1st column has multiple entries but the corresponding values in the column 2 may be the same or different.) however I want to extract unique values for each entry in column 1 by assigning the max value from column 2 SDF4 -0.211654 SDF4 0.978068 ...

5. UNIX for Dummies Questions & Answers

Compare values of fields from same column with awk

Hi all ! If there is only one single value in a column (e.g. column 1 below), then return this value in the same output column. If there are several values in the same column (e.g. column 2 below), then return the different values separated by "," in the output. pipe-separated input: ...

6. UNIX for Dummies Questions & Answers

Changing the values of a column using awk and gsub

Hi, I am using the following code to change NA to X in only the 5th column of my text file: awk '{gsub("NA","x",$5)}1' in.file > out.file How can I modify this code if I want to change NA to X in multiple columns of the text file (i.e. columns 5,6 and 7). Thanks!

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

8. Shell Programming and Scripting

How to compare the values of a column in a same file using awk?

Dear Unix experts, I have got a file where I would like to compare the values of second column if first column is same in such a way that the difference between the values is >50. If not, I would like to discard both values. For example, my input file looks like - comp275_c0_seq2 73...

9. Shell Programming and Scripting

Trying to get an awk script to replace values in column

I'm trying to make an awk script to compare values I've set as var1, var2, and var3 earlier in the script to the values in the userinputted column of four text files called Node1.txt, Node2.txt, Node3.txt, and Node4.txt and then replace the values in that userinputted column with either ttt or gcc,...

10. Shell Programming and Scripting

awk script to append suffix to column when column has duplicated values

Please help me to get required output for both scenario 1 and scenario 2 and need separate code for both scenario 1 and scenario 2 Scenario 1 i need to do below changes only when column1 is CR and column3 has duplicates rows/values. This inputfile can contain 100 of this duplicated rows of...

LEARN ABOUT DEBIAN

concat

concat(3tcl)						       Tcl Built-In Commands						      concat(3tcl)

__________________________________________________________________________________________________________________________________________________

NAME

       concat - Join lists together

SYNOPSIS

       concat ?arg arg ...?
_________________________________________________________________

DESCRIPTION

       This  command  joins  each of its arguments together with spaces after trimming leading and trailing white-space from each of them.  If all
       the arguments are lists, this has the same effect as concatenating them into a single list.  It permits any number of arguments; if no args
       are supplied, the result is an empty string.

EXAMPLES

       Although concat will concatenate lists, flattening them in the process (so giving the following interactive session):

	      % concat a b {c d e} {f {g h}}
	      a b c d e f {g h}

       it will also concatenate things that are not lists, as can be seen from this session:

	      % concat " a b {c   " d "  e} f"
	      a b {c d e} f

       Note also that the concatenation does not remove spaces from the middle of values, as can be seen here:

	      % concat "a   b	c" { d e f }
	      a   b   c d e f

       (i.e., there are three spaces between each of the a, the b and the c).

SEE ALSO

       append(3tcl), eval(3tcl), join(3tcl)

KEYWORDS

       concatenate, join, lists

Tcl									8.3							      concat(3tcl)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

averaging column values with awk

Discussion started by: johnmillsbro

2. Shell Programming and Scripting

How to pick values from column based on key values by usin AWK

Discussion started by: repinementer

3. Shell Programming and Scripting

problem while adding column values in awk

Discussion started by: valokv

4. Shell Programming and Scripting

for each different entry in column 1 extract maximum values from column 2 in unix/awk

Discussion started by: Diya123