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
|
|