I have a tab-delimited csv file:
"a" "b" "c,d" "e"
Excel renders the second row until comma and the rest of the row is not rendered. I enclose each cell in double-quotes but it doesn't help. Is there a way to fix it?
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.Sign up to join this community
I copied your two demo lines to a text file and opened that in excel 2013:
I get a properly imported set of four elements, as shown below:
Some wrapper script like below might work.
(Attempt to add a line to the cvs file with the SEP indicator and then to start it with excel. Might work. Might because I have no experience with batch files and this is created with the help of some googling and some WAGs).
echo off echo Creating a file with sep echo "SEP= " > %tmp%\Sepfile.txt copy %tmp%\Sepfile.txt + %1 %tmp\%1 start "" "C:\Program Files (x86)\Microsoft Office\Office14\excel.exe" "%tmp\%1"