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 communityI copied your two demo lines to a text file and opened that in excel 2013:
Setting used:
"
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"
SEP=
(but that requires modifying all files or writing a wrapper script. 3) or IIRC excel has an override local settings somewhere. I will need to look that up.
sep=
in the first line... while it is possible, i stopped impoving my skills that way to long ago... so i need to give it a goodbye here :(
Dec 14, 2015 at 10:48
make the first line
sep=
after the = is a tabstop (you simply cant see here) ^^;
you also can use sep=;
to change the seperator to ;
(or whatever seperator you want to use)
Text qualifier
set to ?