[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