Topic: Re: Sorting CSV files (1 of 2), Read 38 times
Conf: Hints, tips, shortcuts
From: Christian Ziemski
Date: Wednesday, October 03, 2007 03:45 PM

On 03.10.2007 20:28 vtech-tips Listmanager wrote:
> From: "Ed Elizondo"
>
> I am a long time VEDIT user. I am trying, so far unsuccessfully, to sort a .csv file (saved from Excel)
> by the contents of a column which contains a date in the format YYYY-MM-DD.
>
> The documentation for the Sort_Merge command tells you to specify the columns in the "keyfield-list".
> Since I want to sort using only one column (column #5), I have specified it as "5,5", but this does not work.
>
> One perhaps related question not explained in the documentation - what character(s) does VEDIT use
> as a column delimiter? Is it a comma for a csv file?
> I have tried replacing the column delimeters in the file with tabs, with same negative results.

Ed:

Vedit doesn't know anything about data columns. It's all characters.
So the keyfield-list refers to characters.

You can try out the VEDIT menu {Edit, Convert, CSV to Flat} to convert
your CSV to a fixed length data fields format. This can be sorted with
Sort_Merge() then.

Christian

 


Topic: Re: Sorting CSV files (2 of 2), Read 41 times
Conf: Hints, tips, shortcuts
From: Ed Elizondo
Date: Thursday, October 04, 2007 09:32 AM

Thanks. I was misled because the documentation referred to "columns".
Ed