Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Taking nth column and putting its value in n+1 column using awk
Top Forums Shell Programming and Scripting Taking nth column and putting its value in n+1 column using awk Post 302963469 by RavinderSingh13 on Thursday 31st of December 2015 02:19:07 AM
Old 12-31-2015
Hello umarsatti,

Following is the explanation for same.
Code:
awk -vs1="," -F"|" '{           ######## taking a variable named s1 whose value is comma(,) and setting field separator to |
A=$(NF-1);                      ######## Now making a variable named A whose value is the second last field's value.
split($NF, B,",");              ######## Now using split function I am splitting value of last column $NF and storing it to an array named B with delimiter comma(,).
for(i in B){                    ######## Now going into elements of array B
C=C?C s1 A B[i]:A B[i];         ######## now creating a variable named C whose value is array A's value with array B's value, it is keep appending if it has more than one values to it into C variable by conditional operators ? and :
$NF=C;}                         ######## Now making $NF(last field's) value to variable C's value.
C=""}                           ######## Now nullifying the value of variable C.
1'                              ######## awk works on method of condition and then pattern, here I am mentioning 1 which means condition is TRUE and no action so default action will occur which is printing the line.
OFS="|" Input_file              ######## mentioning the output field seprator to | and mentioning Input_file name.

Thanks,
R. Singh
This User Gave Thanks to RavinderSingh13 For This Post:
umarsatti
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Using tr, sed or awk to delete text from nth column only

Hi everyone, this is my first post here, I hope someone can help me. I have a file which I need to delete characters '_F3' from the end of the text in the first column. The problem is that the characters may also occur elsewhere in the file (i.e. second columns onwards). I tried sed (thinking I... (6 Replies)
Discussion started by: hlwright
6 Replies

2. Shell Programming and Scripting

Using AWK to find top Nth values in Nth column

I have an awk script to find the maximum value of the 2nd column of a 2 column datafile, but I need to find the top 5 maximum values of the 2nd column. Here is the script that works for the maximum value. awk 'BEGIN { subjectmax=$1 ; max=0} $2 >= max {subjectmax=$1 ; max=$2} END {print... (3 Replies)
Discussion started by: ncwxpanther
3 Replies

3. Shell Programming and Scripting

Calculating average for every Nth line in the Nth column

Is there an awk script that can easily perform the following operation? I have a data file that is in the format of 1944-12,5.6 1945-01,9.8 1945-02,6.7 1945-03,9.3 1945-04,5.9 1945-05,0.7 1945-06,0.0 1945-07,0.0 1945-08,0.0 1945-09,0.0 1945-10,0.2 1945-11,10.5 1945-12,22.3... (3 Replies)
Discussion started by: ncwxpanther
3 Replies

4. Shell Programming and Scripting

AWK script to create max value of 3rd column, grouping by first column

Hi, I need an awk script (or whatever shell-construct) that would take data like below and get the max value of 3 column, when grouping by the 1st column. clientname,day-of-month,max-users ----------------------------------- client1,20120610,5 client2,20120610,2 client3,20120610,7... (3 Replies)
Discussion started by: ckmehta
3 Replies

5. Shell Programming and Scripting

Putting mysql column value in variable

Hello, i have the following code : somevariable=`mysql -u root --password="" databasename -e "select count(column_name) from table_name where id=1 and id_age=2 ; " --skip-column-names -s -N` if ] then .... It gives the message ")syntax error: invalid arithmetic operator (error... (2 Replies)
Discussion started by: juve11
2 Replies

6. Shell Programming and Scripting

Need help with awk statement to break nth column in csv file into 3 separate columns

Hello Members, I have a csv file in the format below. Need help with awk statement to break nth column into 3 separate columns and export the changes to new file. input file --> file.csv cat file.csv|less "product/fruit/mango","location/asia/india","type/alphonso" need output in... (2 Replies)
Discussion started by: awk-admirer
2 Replies

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... (3 Replies)
Discussion started by: jacobs.smith
3 Replies

8. Shell Programming and Scripting

awk to search for specific line and replace nth column

I need to be able to search for a string in the first column and if that string exists than replace the nth column with "-9.99". AW12000012012 2.38 1.51 3.01 1.66 0.90 0.91 1.22 0.82 0.57 1.67 2.31 3.63 0.00 AW12000012013 1.52 0.90 1.20 1.34 1.21 0.67 ... (14 Replies)
Discussion started by: ncwxpanther
14 Replies

9. Shell Programming and Scripting

awk search and replace nth column by using a variable.

I am passing a variable and replace nth value with the variable. I tried using many options in awk command but unable to ignore the special characters in the output and also unable to pass the actual value. Input : "1","2","3" Output : "1","1000","3" TempVal=`echo 1000` Cat... (2 Replies)
Discussion started by: onesuri
2 Replies

10. Shell Programming and Scripting

Append data with substring of nth column fields using awk

Hi guys, I have problem to append new data at the end of each line of the files where it takes whole value of the nth column. My expected result i just want to take a specific value only. This new data is based on substring of 11th, 12th 13th column that has comma seperated value. My code: awk... (4 Replies)
Discussion started by: null7
4 Replies

LEARN ABOUT SUSE

unset

unset(n)						       Tcl Built-In Commands							  unset(n)

__________________________________________________________________________________________________________________________________________________

NAME

       unset - Delete variables

SYNOPSIS

       unset ?-nocomplain? ?--? ?name name name ...?
_________________________________________________________________

DESCRIPTION

       This  command removes one or more variables.  Each name is a variable name, specified in any of the ways acceptable to the set command.	If
       a name refers to an element of an array then that element is removed without affecting the rest of the array.  If a  name  consists  of	an
       array name with no parenthesized index, then the entire array is deleted.  The unset command returns an empty string as result.	If -nocom-
       plain is specified as the first argument, any possible errors are suppressed.  The option may not be abbreviated, in order to  disambiguate
       it  from possible variable names.  The option -- indicates the end of the options, and should be used if you wish to remove a variable with
       the same name as any of the options.  If an error occurs, any variables after the named one causing the error not deleted.   An	error  can
       occur  when the named variable does not exist, or the name refers to an array element but the variable is a scalar, or the name refers to a
       variable in a non-existent namespace.

EXAMPLE

       Create an array containing a mapping from some numbers to their squares and remove the array elements for non-prime numbers:
	      array set squares {
		  1 1	 6 36
		  2 4	 7 49
		  3 9	 8 64
		  4 16	 9 81
		  5 25	10 100
	      }

	      puts "The squares are:"
	      parray squares

	      unset squares(1) squares(4) squares(6)
	      unset squares(8) squares(9) squares(10)

	      puts "The prime squares are:"
	      parray squares

SEE ALSO

       set(n), trace(n), upvar(n)

KEYWORDS

       remove, variable

Tcl									8.4								  unset(n)
All times are GMT -4. The time now is 10:46 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy