Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris

Re^2: Alt + Enter

by rpike (Scribe)
on Mar 24, 2011 at 13:57 UTC ( #895259=note: print w/ replies, xml ) Need Help??

in reply to Re: Alt + Enter
in thread Alt + Enter

Not using a module (not my decision). It's a tab-delimited file - i.e. open file handle and print tab-delimited strings to it. It "mainly" gets opened by Excel is all. If there was a way to print alt+enter equivalent or something for Excel it'd be great. The file can have some stuff for Excel in it (can be removed by text editor) but should be formatted in case of import in Excel.

Comment on Re^2: Alt + Enter
Replies are listed 'Best First'.
Re^3: Alt + Enter
by bart (Canon) on Mar 25, 2011 at 11:14 UTC
    You cannot put newlines, or tabs, in a cell, in tab delimited files. It comes with the territory.

    You could upgrade to a CSV file (possibly even using a tab as the column delimiter), which allows you to quote cell contents and thereby including newlines.

    You could also try to just use a standalone return ("\r") in the tab delimited file. No garantees, it could work, but it's an extremely dangerous hack — you never know if somebody editing the file in a text editor could ruin it for you.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://895259]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (6)
As of 2015-12-01 04:58 GMT
Find Nodes?
    Voting Booth?

    What would be the most significant thing to happen if a rope (or wire) tied the Earth and the Moon together?

    Results (794 votes), past polls