Re: Trying to capture Alt characer in Perl

Do I understand it right? You want to output somehow that alt+enter in a CSV file? Somehow having a line break in an Excel cell, don't you? If my assumption is correct the answer is simple: It's not possible. CSV doesn't allow any formatting. An "enter" will destroy the structure of a CSV file because Enter is the symbol for line end. If you want to have the cell format you should output some sort of Excel format, preferrably XLSX.

Comment on Re: Trying to capture Alt characer in Perl

Replies are listed 'Best First'.
Re^2: Trying to capture Alt characer in Perl by choroba (Cardinal) on May 20, 2014 at 14:37 UTC
That is not true. You can have newlines in strings in CSV if the strings are properly quoted. لսႽ† ᥲᥒ⚪⟊Ⴙᘓᖇ Ꮅᘓᖇ⎱ Ⴙᥲ𝇋ƙᘓᖇ	[reply]
Re^2: Trying to capture Alt characer in Perl by sanPerl (Friar) on May 20, 2014 at 19:36 UTC
No , I already have an Excel file (as input) which contains a cell having Enter character. This character is entered by some user, using 'Alt+Enter' key combination. Now I want to convert this Enter character (or 'Alt+Enter' char) to space. This is what is Not happening and I am getting CSV file with Enter character retained (which is spoiling structure of CSV). BTW, thanks a lot for your interest.	[reply]