Simple regexp question

Hi

I have a .txt file which contains one line data as

“George”,33,“engineer, r&d department, this company”,“234-7554-344”

I use name,age,memo,tel=File.open(filename).split(’,’) to collect values
but get wrong value for memo and tel. I want string “engineer, r&d
department, this company” not be splited by comma, how can I do that?

Hello,

On 9/27/07, Ak 756 [email protected] wrote:

I have a .txt file which contains one line data as

“George”,33,“engineer, r&d department, this company”,“234-7554-344”

I use name,age,memo,tel=File.open(filename).split(’,’) to collect values
but get wrong value for memo and tel. I want string “engineer, r&d
department, this company” not be splited by comma, how can I do that?

I’m sure there’s a more elegant solution, but this worked for me
(assuming the string is stored in the variable s):

name, age, memo, tel = $1, $2, $3, $4 if s =~
/^"(.+?)",(\d+),"(.+?)","([-\d+]+)"/

Cam

Heesob P. wrote:

Why not use csv module?

require ‘csv’
data = ‘“George”,33,“engineer, r&d department, this
company”,“234-7554-344”’
name,age,memo,tel=CSV.parse_line(data)

Regards,

Park H.

Hi Heesob

Thanks very much.
Great csv module! Everything becoms so easy with it. -:slight_smile:

Hi,

Ak 756 wrote:

Hi

I have a .txt file which contains one line data as

“George”,33,“engineer, r&d department, this company”,“234-7554-344”

I use name,age,memo,tel=File.open(filename).split(’,’) to collect values
but get wrong value for memo and tel. I want string “engineer, r&d
department, this company” not be splited by comma, how can I do that?

Why not use csv module?

require ‘csv’
data = ‘“George”,33,“engineer, r&d department, this
company”,“234-7554-344”’
name,age,memo,tel=CSV.parse_line(data)

Regards,

Park H.

On Sep 27, 2007, at 11:31 PM, Ak 756 wrote:

Hi

I have a .txt file which contains one line data as

“George”,33,“engineer, r&d department, this company”,“234-7554-344”

I use name,age,memo,tel=File.open(filename).split(’,’) to collect
values
but get wrong value for memo and tel. I want string “engineer, r&d
department, this company” not be splited by comma, how can I do that?

fastercsv might help. It’s great, AND a lot faster for parsing comma
separated values.

~ Ari
English is like a pseudo-random number generator - there are a
bajillion rules to it, but nobody cares.

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs