good chemistry is complicated, and a little bit messy -LW |
|
PerlMonks |
Re^3: separating two sententencesby Sinistral (Monsignor) |
on Sep 16, 2011 at 14:01 UTC ( [id://926419]=note: print w/replies, xml ) | Need Help?? |
You need to reread dreadpiratepeter's node again: Re^5: separating two sententences. Your input file just needs a split on the semicolon to get the two columns, then a regular expression to remove the quotes. Print those out separated by a comma or tab, and then Excel will read the file
In Section
Seekers of Perl Wisdom
|
|