So I'm handling a large file with a dialog tree in it, full of dialog that I'm writing for a game. The structure looks like this, currently using a Word bullet list.
1. Faction name
1.1 DIALOG_FACTION_DESCRIPTIVE_LABEL Hey, man, this is an introductory comment.
1.1.1 DIALOG_FACTION_DESCRIPTIVE_REPLY_LABEL Hey yourself, and guess what, this is a reply.
1.1.1.1 DIALOG_FACTION_TEXT_THAT_IS_REPEATED_ELSEWHERE This text is used in more than one place.
1.1.2 DIALOG_FACTION_DESCRIPTIVE_REPLY_LABEL_VARIANT Hey yourself, and guess what, this is a variant reply.
1.1.1.1 DIALOG_FACTION_TEXT_THAT_IS_REPEATED_ELSEWHERE This text is used in more than one place.
I've begun digging into the formulas, but my knowledge of Excel is not terribly deep, and I'm accustomed to using it to track money, and have no idea how to handle strings.
My problem is this; I have 41 pages of this, largely because many dialog trees are re-used many times, and it will only grow. Some branches with multiple sub-branches occur 8 or 10 times. I want to take a copy of this out of the bulleted format (leaving the descriptive label the first part of the string) and make an alphabetically sorted list of all dialog lines, with no repeats. The list should be composed of the descriptive label in one cell, and the plain text in the other.
This will give me an easy way to export this document via copy and paste to an excel document, providing a cell for the label next to the cell for the English, to evaluate if there are reproduction errors and to provide a list to translate into other languages from.
The label always starts with DIALOG and has no spaces.
1. Faction name
1.1 DIALOG_FACTION_DESCRIPTIVE_LABEL Hey, man, this is an introductory comment.
1.1.1 DIALOG_FACTION_DESCRIPTIVE_REPLY_LABEL Hey yourself, and guess what, this is a reply.
1.1.1.1 DIALOG_FACTION_TEXT_THAT_IS_REPEATED_ELSEWHERE This text is used in more than one place.
1.1.2 DIALOG_FACTION_DESCRIPTIVE_REPLY_LABEL_VARIANT Hey yourself, and guess what, this is a variant reply.
1.1.1.1 DIALOG_FACTION_TEXT_THAT_IS_REPEATED_ELSEWHERE This text is used in more than one place.
I've begun digging into the formulas, but my knowledge of Excel is not terribly deep, and I'm accustomed to using it to track money, and have no idea how to handle strings.
My problem is this; I have 41 pages of this, largely because many dialog trees are re-used many times, and it will only grow. Some branches with multiple sub-branches occur 8 or 10 times. I want to take a copy of this out of the bulleted format (leaving the descriptive label the first part of the string) and make an alphabetically sorted list of all dialog lines, with no repeats. The list should be composed of the descriptive label in one cell, and the plain text in the other.
This will give me an easy way to export this document via copy and paste to an excel document, providing a cell for the label next to the cell for the English, to evaluate if there are reproduction errors and to provide a list to translate into other languages from.
The label always starts with DIALOG and has no spaces.