Merging 2 csv files and sorting merged file

ruby-talk
1

Hello all!

Things I want to do:
1) merging 2 csv files
2) sorting new merged file
3) delete some columns from a new merged file

1st csv file1:

11101,3310000,IKANIKEISAIGANAIBAAI,NISHI-KU
SAITAMA-SHI,SAITAMA,0,0,0,0,0,0
11101,3310058,IIDA,NISHI-KU SAITAMA-SHI,SAITAMA,0,0,0,0,0,0
11101,3310068,IIDASHINDEN,NISHI-KU SAITAMA-SHI,SAITAMA,0,0,0,0,0,0

2nd csv file2:

12101,2600000,IKANIKEISAIGANAIBAAI,CHUO-KU CHIBA-SHI,CHIBA,0,0,0,0,0,0
12101,2600852,AOBACHO,CHUO-KU CHIBA-SHI,CHIBA,0,0,0,0,0,0
12101,2600804,AKAICHO,CHUO-KU CHIBA-SHI,CHIBA,0,0,0,0,0,0

The code below:

···

------------------------------------
require "fileutils"
FileUtils.cp("file1.csv", "file3.csv")

File.open("file3.csv", "a+")
File.open("file2.csv", "r") do |file|
  file.each_line do |line|
    puts line
    end
  end
------------------------------------

1st I made a copy of the 1st file, and then I try just to add the
content of the 2nd file. At the moment I can only print the content of
the 2nd file, but can't to add this the file3... :frowning: This a problem 1.
2nd is sorting - please advise me directions which I need read more...

Thanks in advance!

--
Posted via http://www.ruby-forum.com/.

2

Here I post the answerI got from japanese mailing list,
which worked for me

out = File.open("file3.csv", "a+")
File.open("file2.csv", "r") do |file|
file.each_line do |line|
  out.puts line # 出力
end
end

OR

File.open("file3.csv", "a+") do |out|
out.print IO.read('file2.csv')
end

···

--
Posted via http://www.ruby-forum.com/.

3

Or you can

cat file1 file2 ! sort

Just put pipe sign instead of ! :slight_smile:

Kresimir Bojcic

···

On May 1, 2011 9:59 AM, "Askar Ka" <tenzancode@gmail.com> wrote:

Here I post the answerI got from japanese mailing list,
which worked for me

out = File.open("file3.csv", "a+")
File.open("file2.csv", "r") do |file|
file.each_line do |line|
out.puts line # 出力
end
end

OR

File.open("file3.csv", "a+") do |out|
out.print IO.read('file2.csv')
end

--
Posted via http://www.ruby-forum.com/\.