I have a dataset with coordinates of certain points with their names.
file1:
The letters represent names of points. In file1 they are unique.
I also have file2 with a dataset with some points that might be repeating unknown number of times, for which I need coordinates from file1 (coordinates are columns 2 and 3 in file1)
Not all points from file1 are in file2 and viceversa.
file 2:
wanted output:
I want to add to points in file2 the coordinates from file1. Obviously for every instance of AAA in file2, the coordinates will be the same, however, the rest of the line for AAA is not necessarily the same.
Since the fields in file2 repeat I don't know how I would match and paste the values from columns 2 and 3 in file1 to appropriate rows of file2.
If they weren't repeating I'd try with awk something like
but that doesn't work here and I don't know how to start.
Moderator's Comments:
edit by bakunin: sorry for editing instead of answering the post. I have it restored now. My bad.
I'd try with awk something like
but that doesn't work here and I don't know how to start.
You may want to start reading the man page of the join command. As i see it it does exactly what you want. Note that join expects both input files to be sorted (in regards to the common key you want to use for the join-operation) prior to using them.
Hi there, I‘m a newbie in linux (ubuntu) working with several files, some of them containing hundred thousands of lines. I started to extract information out of 2 files, combining them by 1 column: I need a Vlookup-like command that reads sampleID (column 2)(line 2,..line by line) in file 1, looks... (1 Reply)
he following are the files available in my directory
RSK_123_20141113_031500.txt
RSK_123_20141113_081500.txt
RSK_126_20141113_041500.txt
RSK_126_20141113_081800.txt
RSK_128_20141113_091600.txt
Here, "RSK" is file prefix and 123 is a code name and rest is just timestamp of the file when its... (7 Replies)
hi everyone,
im stuck in here with shell :) can you help me??
i have a directory with alot files (genbank files ... all ended in .gbk ) more than 1000 for sure ... and i want to read each one of them and search for some information and if i found the right one i save in new file with new... (6 Replies)
I am using the below script to remove the rows which contains null values in the 3rd column.My requirement here is want to get the filenames which row is removed .please help me.
#!/usr/bin/sh
Scripts=/ushhquest/data001/Scripts
cd /ushhquest/data011/TgtFiles/MonthlyData
ls CUSTADDR*.txt >... (4 Replies)
I need to copy a list of files in directory and only files with content DUMMY_B should be copy over to a new directory. How can i do that ? Thanks a lot. (2 Replies)
I have got this piece of csh code that looks into various log files and outputs some parameters
For example, I might have 4 files and want to grep for the lines containing "Best Value"
npt02-z30-sr65-rgdt0p50-dc0p004-16x12drw.log
npt02-z30-sr65-rgdt0p50-dc0p004-16x12drw-run2.log... (6 Replies)
Hi,
I am new to shell programming and need help. I have File1 with some ID numbers and File2 with ID number and some associated information.
I want to match the ID numbers from File1 to contents in File2 and output a third file which pulls out the ID numbers and the associated information with... (2 Replies)
Hello,
I have several files in a specific directory.
A specific string in one file can occur in another files.
If this string is in other files. Then all the files in which this string occured should be deleted and only 1 file should remain with the string.
Example.
file1
ShortName "Blue... (2 Replies)
Hi all,
I want to get only hidden files(which are start with '.' or '..') information in a current directory. I tried the below command,
$ find . -name "^." -exec ls -la '{}' \;
but it's not working. Can anyone give me your outputs.
Thanks in advance,
Raghu. (5 Replies)