How do I sort a Delimited text file by the second delimitation?

I have a text file that is laid out as such:

aaaa aaa (2000)
bbb bbb bb (2001)
cccc,ccc (1999)
ddd dddddd (2004)

I would like to be able to make a VBScript that sorts the text file and makes a new csv from it that has it in order by (*). That way it would list back:

cccc,ccc (1999)
aaaa aaa (2000)
bbb bbb bb (2001)
ddd dddddd (2004)

I tried a couple times using some other scripts but I am pretty new at this and figured I should reach out for help.

Thank you for any help you could give.


May 26th, 2015 6:23pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics