My biggest issue is transferring the compiled data (i.e. the entries for each post that lists which characters are featured in the post) into some sort of format where I can copy and paste automatically generated bbcode onto the forum or upload it to GoogleDocs/Sheets.

For Microsoft Access, I found a way to query the data into an organized list and exporting it to Microsoft Excel, but in order to sort all the entries, I had to assign each character a unique "code" (e.g. 'ara' for Arachne) and number the posts (e.g. ara1 for the 1st Arachne post). Furthermore, I had to repeat post entries for each character who makes an appearance in that post, which is less than idea.

For Microsoft Excel, I found a way with macros to filter the entries and copy them into individual tabs for each character. Then, this document can be uploaded to GoogleSheets. However, my concern is that, when I have over 500 entries, it might take a long time to run through the macro. Furthermore, I would have to figure out how to make an automatically generated table of contents (ideally with hyperlinks) and how to mark out where certain character/story arc begin and end.

Is there any way I could do this in C# programming? Maybe something like the following (obviously it is not code, but it should give a good idea what I am looking for.

[code]
//variables
character Character //each character in the roleplay (class)
post Post //each post in the roleplay (class)
postnum Postnum //the chronological order of each post. a value in the post class
charpres Charpres //what character is present in the post. a value in the post class If I cannot assign multiple charpres, then I could do an individual value of each character and have it true/false (default = false)

For each character, create a new list

For each post where character matches charpres(or true/false check), add to list

Sort post by postnum

[/code]

If I could build in the bbcode, this might be the idea option.