Re: Spaces Between Chars While Reading File

in reply to Spaces Between Chars While Reading File

Using ".+" in a regular expression is generally going to lead to trouble.

Given the excel source and desired removal of quotes, it seems rather likely that you're reading from a CSV file. As such, you might consider using Text::CSV to save you from the complications of the format.

Alternatively, you might even consider reading from the excel file directly with Spreadsheet::ParseExcel, though I must admit that I've never used it on 2007.

Comment on Re: Spaces Between Chars While Reading File

Replies are listed 'Best First'.
Re^2: Spaces Between Chars While Reading File by almut (Canon) on Aug 01, 2008 at 13:47 UTC
Using ".+" in a regular expression is generally going to lead to trouble. Why is that (generally)? — I mean, it all depends on what you want to achieve, doesn't it?	[reply]
Re^3: Spaces Between Chars While Reading File by massa (Hermit) on Aug 01, 2008 at 14:35 UTC
"Greedily garble everything" is rarely what you want to achieve. In the OP case, it will change `"ab", "abc", "cde"` [download] into `ab", "abc", "cde` [download] which is (possibly) not the intended result. The ideal would be `s/"([^"]+)"/$1/g` [download] that would yield `ab, abc, cde` [download] []s, HTH, Massa (κς,πμ,πλ)	[reply] [d/l] [select]

In Section Seekers of Perl Wisdom