Re: Trying to capture Alt characer in Perl

[leuchuk]

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.

[choroba]

That is not true. You can have newlines in strings in CSV if the strings are properly quoted.

[sanPerl]

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.