http://www.perlmonks.org?node_id=926419


in reply to Re^2: separating two sententences
in thread separating two sententences

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