Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Bashing of Fields then append! Post 302878390 by nikka on Friday 6th of December 2013 01:36:36 AM
Old 12-06-2013
Bashing of Fields then append!

Hi All,

I;m a newbie here, Seeking for your assistance regarding on how to bash the 6th and 7th fields of file2 into 2th and 3rd fields of file1 then add fields in the last line of file2 if it's match, if not they will only display the records.

Ex.
Code:
File1
a,1,2,b,c,d,e,USA
q,3,4,w,e,r,t,CAN

File2
t,y,u,i,o,1,2,5
v,b,n,m,h,3,4,9
a,s,d,f,g,h,j,7

Expected Output:
Code:
t,y,u,i,o,1,2,5,USA - since the 6th and 7th field of file2 is = to 2th and 3rd of file1 it append the last field USA
v,b,n,m,h,3,4,9,CAN - since the 6th and 7th field of file2 is = to 2th and 3rd of file1 it append the last field CAN

a,s,d,f,g,h,j,7 - the 6th and 7th field of file2 is NOT EQUAL to 2th and 3rd of file1 it will only retain the display of records.

Please advise,

Thanks,
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

All right. ... (no Microsoft bashing, thanks)

First off, this is as much as I know about Unix: its an operating system. Now, I know it goes a tad deeper than that, so first off, what exactly is Unix? Next, im freakin sick of everything microsoft crashing on me, so Id like to make Unix my OS, but I dont want to lose anything but internet... (5 Replies)
Discussion started by: gc_wyo_dave
5 Replies

2. Shell Programming and Scripting

Append tabs at the end of each line in NAWK -- varying fields

Hi, I need some help in knowing how I can append tabs at the end of each line... The data looks something like this: field1, field2, field3, field4 1 2 3 4 5 I have values in field1 and field 2 in the first row and I would like to append tab on field3 and field4 for the first row..and in... (6 Replies)
Discussion started by: madhunk
6 Replies

3. Shell Programming and Scripting

Match data based on two fields, and append to a line

I need to write a program to do something like a 'vlookup' in excel. I want to match data from file2 based on two fields (where both match) in file1, and for matching lines, add the data from two of the fields from file2 to file1. If anyone knows something in perl or awk that can do this, I'd be... (20 Replies)
Discussion started by: jamessmith01
20 Replies

4. UNIX for Dummies Questions & Answers

Match values from 2 files and append certain fields

Hi, I need help on appending certain field in my file1.txt based on matched patterns in file2.txt using awk or sed. The blue color need to match with one of the data in field $2 in file2.txt. If match, BEGIN and FINISHED value in red will have a new value from field $3 and $4 accordingly. ... (1 Reply)
Discussion started by: redse171
1 Replies

5. Shell Programming and Scripting

UNIX append field with comparing fields from multiple column

I have a csv dump from sql server that needs to be converted so it can be feed to another program. I already sorted on field 1 but there are multiple columns with same field 1 where it needs to be compared against and if it is same then append field 5. i.e from ANG SJ,0,B,LC22,LC22(0) BAT... (2 Replies)
Discussion started by: nike27
2 Replies

6. UNIX for Dummies Questions & Answers

Bashing of records in different file

Hi Everyone, Good Day, I'm a newbie on scripting, I would like to seek you for assistance regarding on how to bash the 1st file into 2nd file and output the match record. Sample: File1.csv JuanDelaCrus<tab>USA<tab>CANADA TwoDelaCrus<tab>SG<tab>California File2.csv... (2 Replies)
Discussion started by: znesotomayor
2 Replies

7. Shell Programming and Scripting

Bashing of 2 Files

Hi Everyone, Seeking for your assistance on how to bash the file 1 to file 2 records and output the same records with specific field to display to file3. Example: Imagine we have many Files and records in File 1 and the File2 is only 1 file but many records. File1... (3 Replies)
Discussion started by: znesotomayor
3 Replies

8. Shell Programming and Scripting

Bashing of 2 files

Hi All, Seeking for your assistance on how to bash 2 files and then print if the condition met. Ex. file1.txt: Field1 Field2 Field 3 Field 4 usa <blank> <blank> INDIA file2.txt: Field1 Field2 Field 3 Field 4 canada jap INDIA utah... (7 Replies)
Discussion started by: znesotomayor
7 Replies

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

10. Shell Programming and Scripting

Matching two fields in two csv files, create new file and append match

I am trying to parse two csv files and make a match in one column then print the entire file to a new file and append an additional column that gives description from the match to the new file. If a match is not made, I would like to add "NA" to the end of the file Command that Ive been using... (6 Replies)
Discussion started by: dis0wned
6 Replies
h5diff(1)						      General Commands Manual							 h5diff(1)

NAME
h5diff - Compares two HDF5 files and reports the differences. SYNOPSIS
h5diff file1 file2 [OPTIONS] [object1 [object2 ] ] DESCRIPTION
h5diff is a command line tool that compares two HDF5 files, file1 and file2, and reports the differences between them. Optionally, h5diff will compare two objects within these files. If only one object, object1, is specified, h5diff will compare object1 in file1 with object1 in file2. In two objects, object1 and object2, are specified, h5diff will compare object1 in file1 with object2 in file2. These objects must be HDF5 datasets. object1 and object2 must be expressed as absolute paths from the respective file's root group. Additional information, with several sample cases, can be found in the document H5diff Examples. OPTIONS
file1 file2 The HDF5 files to be compared. -h Print all differences. -r Print only the names of objects that differ; do not print the differences. These objects may be HDF5 datasets, groups, or named datatypes. -n count Print difference up to count differences, then stop. count must be a positive integer. -d delta Print only differences that are greater than the limit delta. delta must be a positive number. The comparison criterion is whether the absolute value of the difference of two corresponding values is greater than delta (e.g., |a-b| > delta, where a is a value in file1 and b is a value in file2). -p relative Print only differences that are greater than a relative error. relative must be a positive number. The comparison criterion is whether the absolute value of the difference 1 and the ratio of two corresponding values is greater than relative (e.g., |1-(b/a)| > relative where a is a value in file1 and b is a value in file2). object1 object2 Specific object(s) within the files to be compared. EXAMPLES
The following h5diff call compares the object /a/b in file1 with the object /a/c in file2: h5diff file1 file2 /a/b /a/c This h5diff call compares the object /a/b in file1 with the same object in file2: h5diff file1 file2 /a/b And this h5diff call compares all objects in both files: h5diff file1 file2 SEE ALSO
h5dump(1), h5ls(1), h5repart(1), h5import(1), gif2h5(1), h52gif(1), h5perf(1) h5diff(1)
All times are GMT -4. The time now is 02:30 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy