Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things

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.

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]
[submersible_toast er]: Padre

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (2)
As of 2018-04-22 11:43 GMT
Find Nodes?
    Voting Booth?