[Manifold-l] Preserving sort order for exported table
PAUL STANTON
p_stanton at btinternet.com
Fri Dec 29 08:28:40 CST 2006
Seasons Greetings Listers.
Hopefully a simple question. I am using the data handling side of Manifold to help reformat some text files that I have been given (cheeky I know but Manifold has many facets).
Basically I'm going from a proprietary matrix format to a simple 3 column listing (origin_zone, destination_zone, cell_value). To do this I have split the data into separate tables and that cut and paste appended them back into a single master table with the correct formatting.
The problem is that I need to preserve a certain order in my data (sorting in ascending order first on column 1 and then column 2) in the .csv export table that I create. However, the sort command is (as I understand it) merely a transient view of the data and the export utility must use the primary key for sorting. Is there any quick and easy way around this?
Regards
Paul Stanton MSc CMILT CSci MBCS CITP FRGS
Suffolk
England
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.directionsmedia.net/pipermail/manifold-l/attachments/20061229/0b8339ea/attachment.htm
More information about the Manifold-l
mailing list