I have a strange situation of sorting and merging two files based on similar columns
previusly both files has same count of records so, I made below way which is working fine until they reduced the count of one files .
I.e. some times the count of records of both will same and some times it won't but only the columns will remain unchanged .
working well for same row count files
and columns we are talking about are 1,2,3,5,6 which are common in both files.
now files has changed
for today
for yday.csv
now final_outputfile
should looklike
it's possible for yday.csv first row could be missing totally or any other rows
then
final_output should be looklike
anyone have any idea to work this out?
Your script does not - by all means - produce the output you describe, even with files of equal line count. The best that I could get at with generous interpretation of the command in the script is
When files are of different length, the leftover lines will get no or empty fields pasted. Why should a line with field 4 = 79 in today.csv get NAs when field 4 in yday.csv is 76? Please explain the intended algorithm.
My requirement is combine yday and today csv file and create final output file. taking consideration of common columns 1,2,3,5,6 in both yday and today file .
sometimes today file counts are greater than the file counts of yday one.
So merging would only take 1st row of (combined column of 1,2,3,5,6 ) lowest count file (yady) to the first row (combined column of 1,2,3,5,6 ) of highest count file (today) and the very same records (combined column of 1,2,3,5,6 ) for next one in the highest count file (today) should have NA NA NA as there is no record matching for lowest count since 1st row of (combined column of 1,2,3,5,6 ) lowset count file matched above.
please refer below input file for different cases
PS: All field separator is , instead of "TAB". My mistake.
case one
today.csv
yday.csv
merged file
option two
yday.csv
final merged file
case three
today.csv
yday.csv
final merged one
f1=today.csv
f2=yday.csv
f1.X today.csv's X column number
f2.X yday.csv's X column number
---------- Post updated at 06:40 AM ---------- Previous update was at 06:24 AM ----------
Hi Corona,
I tried to resolve your struggling at my best :-) . Do let me know, if something left out.
Cheers!!!
Last edited by manas_ranjan; 08-09-2012 at 08:37 AM..
You mean to say sixth column will be common in both the file and need to merge on the basis of sixth column.
is the file1 sixth column will be sorted as shown in sample file
Dear All, I have two file like this:
file1:
a1234
b1235
c4678
d7859
file2 :
e4575
f7869
g7689
h9687
I want output like this:
a1234
b1235
c4678 (2 Replies)
Hello,
I have a master database of a dictionary with the following structure:
a=b (b is a Unicode string)
a is the English part and b is the equivalent in a foreign language
I have also another file which has a database where the /b/ part of the string has been corrected by an expert. let us... (5 Replies)
Hi
I’m new to scripting and have only had about two days experience with this. I have questions about a bash/gawk script.
Problem:
I have 27 files, which needs to get merged into one, the files are separated into 8 subdivisions containing a 3 row data description. Example of data
File.1
... (7 Replies)
Hi everyone, need your help in sorting and merging two numerical lists
Example:
I have one list 1 2 3 4 5 7 and the other 4 6 8, then the final output should be 1 2 3 4 5 6 7 8
Requesting your kind help in this
Regards,
RB :) (1 Reply)
Hi All:
I have following files:
File 1:
<header>
text...
text ..
text ..
text ..
<\header>
x
y
z
...
File 2:
<header>
text...
text ..
text .. (4 Replies)
I have 2 files
file1.txt
a 123 aqsw
c 234 sfdr
fil2.txt
b 345 hgy
d 4653 jgut
I want to merger in such a manner the the output file should be
outfile.txt
a 123 aqsw
b 345 hgy
c 234 sfdr
d 4653 jgut
Do we have any command to achive this? (8 Replies)
Hi
All,
How can you sort a file that is doubled space ( where even number lines are blank lines) and still preserves the blank lines?
You can use grep,sed and regular expression.
Thanks
Vishal (4 Replies)
Hi All,
I am writing some data's into a file from C++ program. The files which i am writing is of fixed length . say 232 in length per line.
I am writing as . my c code is as
... (0 Replies)
Hey,
I have a problem with nslookup under the newly installed mandrake 9.1, and as I see now also under Redhat 8.0
I have a pc called evo with the ip 10.0.0.1 which entered correctly in the /etc/hosts file. Connection to the internet is via an adsl-router. I have the nameservers from my... (2 Replies)