in reply to Re: to csv file
in thread to csv file

Actually I think Text::CSV and the others only work with single character separators. From Text::CSV:
sep_char
The char used for separating fields, by default a comma. (,). Limited to a single-byte character, usually in the range from 0x20 (space) to 0x7e (tilde).

The separation character can not be equal to the quote character. The separation character can not be equal to the escape character.
If you spot any bugs in my solutions, it's because I've deliberately left them in as an exercise for the reader! :-)

Replies are listed 'Best First'.
Re^3: to csv file
by hdb (Monsignor) on Jun 29, 2013 at 08:44 UTC
    output in csv viewed in excel should look like abd|sasa|trre|dsa|sdas|dsss

    I just thought that if the input would be opened in Excel specifying two semicolons as separators it would look exactly like described in the OP.

      I really must read more carefully in the morning! :-P
      If you spot any bugs in my solutions, it's because I've deliberately left them in as an exercise for the reader! :-)