CSV text qualifier

[gordy]

In CSV mode it would be nice to be able to specify a text qualifier, say for example double-quote char (“) – so that data like this:
“column 1”, “column 2”
“row 1 value 1”, “row 1 value 2”
etc.
..could be displayed without all of the leading and trailing quotes.

[Yutaka Emura]

You can’t specify a text qualifier, it is always double-quotes.
The new cell toolbar will show you the content of the selected cell without double-quotes.

Thanks!

[gordy]

sounds good! being able to copy whole columns without the text qualifier would be very helpful as well

[Yutaka Emura]

Hello,

I wrote a macro that just that for you:

iColumn = document.selection.GetActivePointX( eePosCell );
nLines = document.GetLines();
if( document.GetLine( nLines ) == "" )  nLines--;
sText = "";
for( y = 1; y <= nLines; y++ ) {
	sText += document.GetCell( y, iColumn, eeCellIncludeNone ) + "\r\n";
}
clipboardData.setData("Text", sText );

[Author]

Posts