How to split string in array in two?

Question

I currently have a single column CSV file such as: ["firstname lastname", "firstname lastname", ...].

I would like to create a CSV file such as ["f.lastname", "f.lastname"...]; f being the first letter of the firstname.

Any idea how I should do that ?

update

Ok well, I feel that I am close thanks to you guys, here's what I got so far :

  require 'csv'
  filename = CSV.read("mails.csv")
  mails = []
  CSV.foreach(filename) do |col|
   mails << filename.map { |n| n.sub(/\A(\w)\w* (\w+)\z/, '\1. \2') }
  end
  puts mails.to_s

But I still get an error.

update2

Ok this works just fine :

require 'csv'
mails = []
CSV.foreach('mails.csv', :headers => false) do |row|
  mails << row.map(&:split).map{|f,l| "#{f[0]}.#{l}@mail.com" }
end
File.open("mails_final.csv", 'w') {|f| f.puts mails }
puts mails.to_s

Thanks a lot to all of you ;)

/System/Library/Frameworks/Ruby.framework/Versions/2.0/usr/lib/ruby/2.0.0/csv.rb:1254:in `initialize': no implicit conversion of Array into String (TypeError) — gilles
– gilles, Commented Apr 18, 2014 at 12:26

Arie Xiao · Accepted Answer · 2014-04-18 10:59:35Z

4

A solution without using regular expression:

ary = ["firstname lastname", "firstname lastname"]
ary.map(&:split).map{|f, l| "#{f[0]}. #{l}" }
#=> ["f. lastname", "f. lastname"]

answered Apr 18, 2014 at 10:59

Arie Xiao

14.1k3 gold badges35 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

gilles Over a year ago

Okay it works, just one thing, how do I delete the space between f. and lastname for example ? Update : Nevermind, I managed to do it ;) Thanks a lot

Alok Anand · Accepted Answer · 2014-04-18 13:05:57Z

1

ary = ["firstname lastname", "firstname lastname"]
ary.map{|a| e=a.split(" "); e[0][0]+"."+e[1]}
#=> ["f.lastname", "f.lastname"]

You need to modify your this following code:--

CSV.foreach(filename) do |col|
  mails << filename.map { |n| n.sub(/\A(\w)\w* (\w+)\z/, '\1. \2') }
end

to match something like the following:--

CSV.foreach(path_to_csv_file/mails.csv, headers: true/false) do |row|
  # row is kind _of CSV::Row, do not use filename.map => causing error
  mails << row.to_hash.map { |n| n.sub(/\A(\w)\w* (\w+)\z/, '\1. \2') }
end

edited Apr 18, 2014 at 13:05

answered Apr 18, 2014 at 10:59

Alok Anand

3,3761 gold badge22 silver badges17 bronze badges

1 Comment

gilles Over a year ago

Hm I get this : test.rb:5:in block in <main>': undefined method to_hash' for ["Able Parris"]:Array (NoMethodError)

Jozsef NYITRAI · Accepted Answer · 2014-04-18 13:01:23Z

0

I would do that way:

array = ["firstname lastname", "firstname lastname"]
array.map { |n| "#{n[0]}.#{n.split[1]}" }

answered Apr 18, 2014 at 13:01

Jozsef NYITRAI

5225 silver badges15 bronze badges

Collectives™ on Stack Overflow

How to split string in array in two?

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related