Sponsored Content
Top Forums Shell Programming and Scripting Match value in two files and replace values in selected columns Post 303031018 by jiam912 on Wednesday 20th of February 2019 01:16:13 PM
Old 02-20-2019
Hi vgersh99
I remove the OFS here:
Code:
  $1=a[1]  a[2]

because double , appears in the results.
Many thanks for your help.. It works perfectly now

Code:
31431,37113,318512.50,2334387.50,100,O
11111,22222,999991.70,0000000.30,100,R
99999,88888,111113.20,1111111.30,100,R
22222,33333,111113.20,1111111.30,100,R
31431,37491,323237.50,2334387.50,100,O

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Compare selected columns of two files and print whole line with mismatch

hi! i researched about comparing two columns here and got an answer. but after examining my two files, i found out that the first columns of the two files are not unique with each other. all i want to compare is the 2nd and 3rd column. FILE 1: ABS 456 315 EBS 923 163 JYQ3 654 237 FILE 2:... (1 Reply)
Discussion started by: engr.jay
1 Replies

2. Shell Programming and Scripting

compare two files, selected columns only

hi! i have two files that looks like this file 1: ABS 123 456 BCDG 124 542 FGD 459 762 file 2: ABS 132 456 FGD 459 762 output would be: from file1: ABS 132 456 BCDG 124 542 from file 2: ABS 132 456 (4 Replies)
Discussion started by: kingpeejay
4 Replies

3. Shell Programming and Scripting

Get values from different columns from file2 when match values of file1

Hi everyone, I have file1 and file2 comma separated both. file1 is: Header1,Header2,Header3,Header4,Header5,Header6,Header7,Header8,Header9,Header10 Code7,,,,,,,,, Code5,,,,,,,,, Code3,,,,,,,,, Code9,,,,,,,,, Code2,,,,,,,,,file2... (17 Replies)
Discussion started by: cgkmal
17 Replies

4. Shell Programming and Scripting

Replace duplicate columns with values from first occurrence

I've a text file with below values viz. multiple rows with same values in column 3, 4 and 5, which need to be considered as duplicates. For all such cases, the rows from second occurrence onwards should be modified in a way that their values in first two columns are replaced with values as in first... (4 Replies)
Discussion started by: asyed
4 Replies

5. Shell Programming and Scripting

Match on columns and replace other columns

Hi Friends, I have the following input file cat input chr1 100 200 0.1 0.2 na 1 na nd chr1 105 200 0.1 0.2 1 1 na 98 chr1 110 290 nf 1 na nd na 1 chr2 130 150 12 3 na 1 na 1 chr3 450 600 nf nf na 10 na nd chr4 300 330 1 1 10 11 23 34 My requirement is 1. If $6 is na make $7 nd and... (2 Replies)
Discussion started by: jacobs.smith
2 Replies

6. Shell Programming and Scripting

Replace values in columns

I have the following input format: AA00000712000 -0.17 0.90 -1.04 -0.37 -1.45 -1.13 -0.22 -0.34 -0.55 2.37 0.67 -0.48 -0.48 AA00000712001 0.15 0.03 0.47 0.62 2.04 1.14 0.29 -0.81 0.85 0.53 1.00 -0.10 -0.48 BB00000712000 1.32 -0.47 0.44 0.00 0.98 ... (4 Replies)
Discussion started by: ncwxpanther
4 Replies

7. Shell Programming and Scripting

Reporting where values match and mismatch across three columns

Hello, I have values in three columns. Some values occur in all three columns, other values are present in only one or two columns. I would like to be able to see where the matches and mismatches occur. Thanks in advance for any advice! I have: A B C 1 1 2 2 3 3 3 ... (6 Replies)
Discussion started by: MDeBiasse
6 Replies

8. Shell Programming and Scripting

Multiple columns replace with null values.

I am trying to replace the partcular columns(Col3,col5,col20,col44,col55,co56,col59,col60,col61,col62,col74,col75,col88,col90,col91,col93,col94,col95) with empty Input file Col1,col2,col3,col4,col5------,col100 1,2,3,4,5,---------,100 3,4,5,6,7,---------,300 Output : ... (3 Replies)
Discussion started by: onesuri
3 Replies

9. UNIX for Dummies Questions & Answers

Read in Multiple log files and output selected variables and values to cvs file

I have several problems with my problems: I hope you can help me. 1) the If else statement I am getting an error message. My syntax must be incorrect because the entire statement is throwing an error. For example in filew.log if these items don't exist Memsize, SASFoundation and also if... (0 Replies)
Discussion started by: dellanicholson
0 Replies

10. UNIX for Beginners Questions & Answers

Data match 2 files based on first 2 columns matching only and join if match

Hi, i have 2 files , the data i need to match is in masterfile and i need to pull out column 3 from master if column 1 and 2 match and output entire row to new file I have tried with join and awk and i keep getting blank outputs or same file is there an easier way than what i am... (4 Replies)
Discussion started by: axis88
4 Replies
YAGI(5) 							File Formats Manual							   YAGI(5)

NAME
yagi - yagi binary output format DESCRIPTION
This manual page describes the output format of the file created by the Yagi-Uda project's yagi program. The file is a binary file with a header of 100 bytes. The header consists of: offset(bytes) information data-type 0 elements int 4 driven int 8 parasitic int 12 min_frequency double 20 max_frequency double 28 design frequency double 36 step_frequency double 44 angular_step double 52 0 double 92 0 double Following the header, there starts the coordinates(x,y,l) of each element and the voltage applied to each element. Then we write the element currents one after the other, at each frequency. Hence the element currents will be written 12,000 times with a 3 element yagi analysed at 4,000 different frequencies. All complex data is stored in a structure of type fcomplex, defined as: struct fcomplex {double real, double imaginary}; offset(bytes) information data-type 100 x1 double /* coordinates */ 108 y1 double 116 l1 double 100+(n-1)*24 x_n double 100+(n-1)*24+8 y_n double 100+(n-1)*24+16 l_n double -------------- Repeated for each element. 100+24*elements Voltage1 fcomplex /* voltage */ 100+24*elements+(n-1)*16 Voltage_n fcomplex -------------- Repeated for each element n at each frequency step f. 100+40*elements Current1@f1 fcomplex /* current */ 100+40*elements+(n-1)*16 Current_n@f1 fcomplex 100+56*elements Current@f2 fcomplex 100+40*elements+(n-1)*16 Current_n@f2 fcomplex FILES
filename.out binary file SEE ALSO
yagi(1), output(1), input(1), optimise(1), first(1) and input(5). AUTHORS
Dr. David Kirkby G8WRB (david.kirkby@onetel.net), with help with converting to DOS from Dr. Joe Mack NA3T (mack@fcrfv2.ncifcrf.gov). Yagi version 1.16 24th October 2000 YAGI(5)
All times are GMT -4. The time now is 11:12 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy