Simple regexp question

Ruby
1

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?

2

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

3

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:

4

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.

5

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.