Hi Ted!
As a 10 year Vedit user, I finally bought a new copy of 6.111 to get the sorting feature.
When I export SQL tables as CSV files, they don't always come out with each record in sequential order according to the primary index field. Other tools can't handle large files for sorting the records according to the index. I'm sure Vedit can since it can do most anything else, but I don't know how.
The index field in each record is numbered consecutively and unpadded with zeros, e.g., 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13 etc., and that's how I want the sort to end up after the table is jumbled in the export process.
How do I get Vedit to sort the file the way I want instead of 1, 10, 11, 12, 13, 2, 3, 4, etc.? IOW, I want the lines to be sorted according to the numeric value of the entire delimited field instead of the default way Vedit does it.
Thanks!
|
|