|
For anything that requires sophisticated parsing that I know the rules for, I'll paste the raw data into TextPad and then use regular expression Search and Replace to move it around. Then I'll just replace \w or empty space or number or whatever I need to with a delimiter (like comma) and save it as a csv. Then it opens in Excel NP. It's largely a carryover from 2003, where they didn't have Text to Column. 2007+'s T2C is awesome.
__________________
"I'm typing on a computer of science, which is being sent by science wires to a little science server where you can access it. I'm not typing on a computer of philosophy or religion or whatever other thing you think can be used to understand the universe because they're a poor substitute in the role of understanding the universe which exists independent from ourselves." - Willravel
|