Matching column value from 2 different file using awk and append value from different column


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Matching column value from 2 different file using awk and append value from different column
# 8  
Old 09-17-2017
Quote:
Originally Posted by tententen
.
.
.
Is there a way to also handle double quotes?
.
.
.
WHAT? That pipe is DESIGNED to handle double quotes...


Please become accustomed to provide decent context info of your problem.
It is always helpful to carefully and detailedly phrase a request, and to support it with system info like OS and shell, related environment (variables, options), preferred tools, adequate (representative) sample input and desired output data and the logics connecting the two, and, if existent, system (error) messages verbatim, to avoid ambiguities and keep people from guessing.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Compare 1st column from 2 file and if match print line from 1st file and append column 7 from 2nd

hi I have 2 file with more than 10 columns for both 1st file apple,0,0,0...... orange,1,2,3..... mango,2,4,5..... 2nd file apple,2,3,4,5,6,7... orange,2,3,4,5,6,8... watermerlon,2,3,4,5,6,abc... mango,5,6,7,4,6,def.... (1 Reply)
Discussion started by: tententen
1 Replies

2. 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... (1 Reply)
Discussion started by: as7951
1 Replies

3. Shell Programming and Scripting

awk to Sum columns when other column has duplicates and append one column value to another with Care

Hi Experts, Please bear with me, i need help I am learning AWk and stuck up in one issue. First point : I want to sum up column value for column 7, 9, 11,13 and column15 if rows in column 5 are duplicates.No action to be taken for rows where value in column 5 is unique. Second point : For... (1 Reply)
Discussion started by: as7951
1 Replies

4. Shell Programming and Scripting

Matching column then append to existing File as new column

Good evening I have the below requirements, as I am not an experts in Linux/Unix and am looking for your ideas how I can do this. I have file called file1 and file2. I need to get the second column which is text1_random_alphabets and find that in file 2, if it's exists then print the 3rd... (4 Replies)
Discussion started by: mychbears
4 Replies

5. Shell Programming and Scripting

Solution for replacement of 4th column with 3rd column in a file using awk/sed preserving delimters

input "A","B","C,D","E","F" "S","T","U,V","W","X" "AA","BB","CC,DD","EEEE","FFF" required output: "A","B","C,D","C,D","F" "S", T","U,V","U,V","X" "AA","BB","CC,DD","CC,DD","FFF" tried using awk but double quotes not preserving for every field. any help to solve this is much... (5 Replies)
Discussion started by: khblts
5 Replies

6. Shell Programming and Scripting

How to awk or grep the last column in file when date on column contains spaces?

Hi have a large spreadsheet which has 4 columns APM00111803814 server_2 96085 Corp IT Desktop and Apps APM00111803814 server_2 96085 Corp IT Desktop and Apps APM00111803814 server_2 96034 Storage Mgmt Team APM00111803814 server_2 96152 GWP... (6 Replies)
Discussion started by: kieranfoley
6 Replies

7. Shell Programming and Scripting

Find lines with matching column 1 value, retain only the one with highest value in column 2

I have a file like: I would like to find lines lines with duplicate values in column 1, and retain only one based on two conditions: 1) keep line with highest value in column 3, 2) if column 3 values are equal, retain the line with the highest value in column 4. Desired output: I was able to... (3 Replies)
Discussion started by: pathunkathunk
3 Replies

8. Shell Programming and Scripting

Append column using awk/nawk

Is there any way I can achieve this? Considering test1 : a 1 2 3 4 b 2 3 4 5 c 12 1232 14 1 d 10 13 4 5 e 1 5 6 9 1 And test to be some string : qw twe tew we qw I want something like this : a 1 2 qw 4 b 2 3 twe 5 (5 Replies)
Discussion started by: aksijain
5 Replies

9. UNIX for Dummies Questions & Answers

append column and row header to a file in awk script.

Hi! Is there a way to append column and row header to a file in awk script. For example if I have Jane F 39 manager Carlos M 40 system administrator Sam F 20 programmer and I want it to be # name gend age occup 1 Jane F 39 manager 2 Carlos M ... (4 Replies)
Discussion started by: FUTURE_EINSTEIN
4 Replies

10. Shell Programming and Scripting

Awk: Need help replacing a specific column in a file by part of a column in another file

Hi, I have two input files as File1 : ABC:client1:project1 XYZ:client2-aa:project2 DEF:client4:proj File2 : client1:W-170:xx client2-aa:WT-04:yy client4:L-005A:zz Also, array of valid values can be hardcoded like Output : ABC:W:project1 XYZ:WT:project2 (1 Reply)
Discussion started by: aa2601
1 Replies
Login or Register to Ask a Question
CDF(3pm)						User Contributed Perl Documentation						  CDF(3pm)

NAME
PDL::GSL::CDF - PDL interface to GSL Cumulative Distribution Functions DESCRIPTION
This is an interface to the Cumulative Distribution Function package present in the GNU Scientific Library. SYNOPSIS
use PDL; use PDL::GSL::CDF; my $p = gsl_cdf_tdist_P( $t, $df ); my $t = gsl_cdf_tdist_Pinv( $p, $df ); FUNCTIONS
gsl_cdf_ugaussian_P Signature: (double x(); [o]out()) gsl_cdf_ugaussian_P does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_ugaussian_Pinv Signature: (double p(); [o]out()) gsl_cdf_ugaussian_Pinv does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_gaussian_P Signature: (double x(); double sigma(); [o]out()) gsl_cdf_gaussian_P does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_gaussian_Pinv Signature: (double p(); double sigma(); [o]out()) gsl_cdf_gaussian_Pinv does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_gamma_P Signature: (double x(); double a(); double b(); [o]out()) gsl_cdf_gamma_P does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_gamma_Pinv Signature: (double p(); double a(); double b(); [o]out()) gsl_cdf_gamma_Pinv does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_cauchy_P Signature: (double x(); double a(); [o]out()) gsl_cdf_cauchy_P does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_cauchy_Pinv Signature: (double p(); double a(); [o]out()) gsl_cdf_cauchy_Pinv does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_laplace_P Signature: (double x(); double a(); [o]out()) gsl_cdf_laplace_P does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_laplace_Pinv Signature: (double p(); double a(); [o]out()) gsl_cdf_laplace_Pinv does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_rayleigh_P Signature: (double x(); double sigma(); [o]out()) gsl_cdf_rayleigh_P does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_rayleigh_Pinv Signature: (double p(); double sigma(); [o]out()) gsl_cdf_rayleigh_Pinv does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_chisq_P Signature: (double x(); double nu(); [o]out()) gsl_cdf_chisq_P does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_chisq_Pinv Signature: (double p(); double nu(); [o]out()) gsl_cdf_chisq_Pinv does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_exponential_P Signature: (double x(); double mu(); [o]out()) gsl_cdf_exponential_P does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_exponential_Pinv Signature: (double p(); double mu(); [o]out()) gsl_cdf_exponential_Pinv does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_exppow_P Signature: (double x(); double a(); double b(); [o]out()) gsl_cdf_exppow_P does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_tdist_P Signature: (double x(); double nu(); [o]out()) gsl_cdf_tdist_P does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_tdist_Pinv Signature: (double p(); double nu(); [o]out()) gsl_cdf_tdist_Pinv does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_fdist_P Signature: (double x(); double nua(); double nub(); [o]out()) gsl_cdf_fdist_P does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_fdist_Pinv Signature: (double p(); double nua(); double nub(); [o]out()) gsl_cdf_fdist_Pinv does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_beta_P Signature: (double x(); double a(); double b(); [o]out()) gsl_cdf_beta_P does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_beta_Pinv Signature: (double p(); double a(); double b(); [o]out()) gsl_cdf_beta_Pinv does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_flat_P Signature: (double x(); double a(); double b(); [o]out()) gsl_cdf_flat_P does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_flat_Pinv Signature: (double p(); double a(); double b(); [o]out()) gsl_cdf_flat_Pinv does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_lognormal_P Signature: (double x(); double zeta(); double sigma(); [o]out()) gsl_cdf_lognormal_P does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_lognormal_Pinv Signature: (double p(); double zeta(); double sigma(); [o]out()) gsl_cdf_lognormal_Pinv does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_gumbel1_P Signature: (double x(); double a(); double b(); [o]out()) gsl_cdf_gumbel1_P does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_gumbel1_Pinv Signature: (double p(); double a(); double b(); [o]out()) gsl_cdf_gumbel1_Pinv does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_gumbel2_P Signature: (double x(); double a(); double b(); [o]out()) gsl_cdf_gumbel2_P does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_gumbel2_Pinv Signature: (double p(); double a(); double b(); [o]out()) gsl_cdf_gumbel2_Pinv does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_weibull_P Signature: (double x(); double a(); double b(); [o]out()) gsl_cdf_weibull_P does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_weibull_Pinv Signature: (double p(); double a(); double b(); [o]out()) gsl_cdf_weibull_Pinv does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_pareto_P Signature: (double x(); double a(); double b(); [o]out()) gsl_cdf_pareto_P does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_pareto_Pinv Signature: (double p(); double a(); double b(); [o]out()) gsl_cdf_pareto_Pinv does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_logistic_P Signature: (double x(); double a(); [o]out()) gsl_cdf_logistic_P does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_logistic_Pinv Signature: (double p(); double a(); [o]out()) gsl_cdf_logistic_Pinv does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_binomial_P Signature: (ushort k(); double p(); ushort n(); [o]out()) gsl_cdf_binomial_P does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_poisson_P Signature: (ushort k(); double mu(); [o]out()) gsl_cdf_poisson_P does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_geometric_P Signature: (ushort k(); double p(); [o]out()) gsl_cdf_geometric_P does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_negative_binomial_P Signature: (ushort k(); double p(); double n(); [o]out()) gsl_cdf_negative_binomial_P does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_pascal_P Signature: (ushort k(); double p(); ushort n(); [o]out()) gsl_cdf_pascal_P does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_cdf_hypergeometric_P Signature: (ushort k(); ushort na(); ushort nb(); ushort t(); [o]out()) gsl_cdf_hypergeometric_P does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. AUTHOR
Copyright (C) 2009 Maggie J. Xiong <maggiexyz users.sourceforge.net> The GSL CDF module was written by J. Stover. All rights reserved. There is no warranty. You are allowed to redistribute this software / documentation as described in the file COPYING in the PDL distribution. perl v5.14.2 2012-06-04 CDF(3pm)