Topic: Sorting CSV files (1 of 1), Read 27 times
Conf: Hints, tips, shortcuts
From: Ed Elizondo
Date: Wednesday, October 03, 2007 02:27 PM

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?