read and sort a semicolon seperated csv file
833246Jan 21 2011 — edited Jan 23 2011Hi all,
I need to sort the given csv file columnwise (alphabatically)... which means the corresponding row/rows also have to be sorted. need help.
the csv file looks like:
Wear;9;;;
;;;Image;1
;;;Area;2
;;;ner;3
;;;Content;1
;;;BContainer;1
;;;View;1
VIEW;10;;;
;;;get;8
;;;ner;1
;;;View;1
ACTIVE;21;;;
;;;Image;1
;;;get;7
;;;Area;4
;;;ner;1
;;;de.vw.mqbkombi.widgets.TransitionContainer;3
;;;Aget2;2
;;;ner2;1
;;;Sget;1
;;;iView;1
The idea is to first sort Wear,VIEW, ACTIVE alphabatically (columnwise), making sure all the rows that they have are also moved.
after that, alphabatically sort all the in-between rows.
would appreciate the help from any expert on csv, excel table.