Rank: Newbie
Joined: 6/12/2009
Posts: 4
Location: Singapore
|
Hi,
I converting XML file to CSV file. In CSV file i have following columns
JOB_NO,CNTNR_NO,HBL_NO,GROUP_NO,WEIGHT_GROSS
JOEC900961,OOLU6400830,OCGLA900029,1,300
JOEC900961,OOLU6400830,OCGLA900030,1,480
JOEC900961,OOLU8233794,OCGLA900031,1,202
JOEC900961,OOLU8233794,OCOLA900004,1,1100.2
JOEC900961,OOLU8233794,ODALA900009,1,238.4
JOEC900961,OOLU6400830,ODMLA900002,1,3915
JOEC900961,OOLU8233794,ODTLA900012,1,297.6
JOEC900961,OOLU8233794,OLALA900123,1,1273
JOEC900961,OOLU6400830,OLALA900126,1,308
JOEC900961,OOLU6400830,OLALA900127,1,993
JOEC900961,OOLU6400830,OLALA900128,1,99.9
JOEC900961,OOLU8233794,OLALA900129,1,381
If I want order by jobno, contnr_no, hbl_no, how to do?
Anyone can assist??
Thanks
|
Rank: Newbie
Joined: 10/28/2002
Posts: 1,283
Location: AT
|
Hi jayakanthang,
it is currently not possible to sort in Mapforce. We do have this listed as a feature request in our internal wishes list for future consideration however.
In your case you may want to apply a handwritten stylesheet which sorts the xml and then map the sorted xml to to the text output.
|
Rank: Advanced Member
Joined: 6/16/2006
Posts: 502
Location: AT
|
As long as the sort key is the start of the row, you can simply run the mapping output through "sort" (the OS utility).
|
Rank: Newbie
Joined: 6/12/2009
Posts: 4
Location: Singapore
|
Hi
Thanks for your reply. Can you give me an example, how to use sort utility?
|
Rank: Newbie
Joined: 10/28/2002
Posts: 1,283
Location: AT
|
This link describes the sort command:
http://technet.microsoft.com/en-us/library/cc722869.aspx
|
