Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!


Click here to return to the 'It's all about NEWLINE replacement...' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
It's all about NEWLINE replacement...
Authored by: marook on Mar 04, '04 06:05:38PM

The thing happening is that in the copy process, WebKit adds RETURN or NEWLINE instead of TABs.
Excel expect TABS.
I do this in BBEdit, if needed:
1: Past in new window.
2: Find and replace all Double Returns "\r\r" with "$r"
3: Find and replace all Single Returns "\r" with a TAB: "\t"
4: Find and replace all $r with Returns: "\r"

Takes about 10 sec, and your done!

The trick here is that a line has Single Returns between cells, but double Returns at the 'end of line'.

Hope it helps...

---
/Marook



[ Reply to This | # ]
one step less
Authored by: ali baba on Mar 06, '04 08:57:08AM

1: Past in new window.
2: Find and replace all Returns "\r" with a TAB: "\t"
3: Find and replace all Double Tabs "\t\t" with a Return: "\r"

sorry if i'm nitpicking



[ Reply to This | # ]
one step less
Authored by: jmat@mac.om on Mar 08, '04 04:45:19PM

I think that will cause problems if a cell is empty. You'll end up with split lines at the empty cell.



[ Reply to This | # ]