in reply to Split line with extra delim

A simple way could be to convince Excel to use some other character (instead of a comma) for separating fields. A tab is probably a good choice.

Replies are listed 'Best First'.
Re^2: Split line with extra delim
by QM (Parson) on Aug 24, 2005 at 15:36 UTC
    A tab is probably a good choice.
    That just makes tabs problematic inside double quotes. Granted, with enough searching and foreknowledge, one can pick a character that never occurs. But never is not as long as we think, and a proven solution is better than a statistical one.

    -QM
    --
    Quantum Mechanics: The dreams stuff is made of

[reply]

In Section Seekers of Perl Wisdom