- Mon Nov 13, 2006 7:04 pm
#195055
I need to help out a friend to sort a list of names in alphabetical order, but it's a bit more complex. It's a list of translators and for each translator the list of books they've translated, which also needs to be sorted alphabetically. The list looks like this:
Pretty complex, I have no idea how to write something like that in VB script. I told them they should have started writing a list in Excel instead, but now they have a list of names 130 pages long.....
Code: Select all
Would this be possible to do with some VB script? I'm thinking first it needs to check the text between one name in bold (each translator) all the way to another name in bold. Then inside that text, it needs to check the beginning of a paragraph that starts with a capitalized name, all the way to the text "BRLR". Treat that as one "piece", then find another piece, and sort by the capitalized name.[b]TRANSLATOR NAME[/b]
AUTHOR, Firstname, book title in italic. And each book ends with the a
number: (BRLR 13248)
AUTHOR, Firstname, same stuff bla bla (BRLR 13452)
[b]TRANSLATOR NAME 2[/b]
AUTHOR, Firstname, book title in italic. And each book ends with the a
number: (BRLR 13248)
AUTHOR, firstname, same stuff bla bla (BRLR 13452)
Pretty complex, I have no idea how to write something like that in VB script. I told them they should have started writing a list in Excel instead, but now they have a list of names 130 pages long.....
Maxwellzone.com - tutorials, training and other goodies related to Maxwell Render
Youtube Maxwell channel
Youtube Maxwell channel


- By Mark Bell