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.
Any hints?
|
|