Can StringBuilder be used to effectively store and manage multiple variables of data?

Question

Using C# I want to create one or more text files to store all the data pertaining to a particular 'Thing' on the same line. I am presently leaning towards StringBuilder as per the following.

sb.AppendFormat("{0}{1}{2}{3}{4}{5}{6}{7}"
   , _ThingClass  /* Thing class */ 
   , _ClassType /* Property class type */
   , _Prop0  /* These are generic properties that get manipulated depending on _ThingClass and _ClassType */ 
   , _Prop1        
   , _Prop2  
   , _Prop3   
   , _Prop4
   );

/*
Examples of _ThingClass (Person, Event, Vehicle, Item)
Examples of _ClassType (Teacher, Disaster, Car, Mobile Phone)
Examples of _Prop0-4 (Rachel, Tornado, Fiat, Samsung)
*/

The idea is to break down the string on a line to determine:

• What kind of Thing is stored on the line (first value), and
• How to handle the other fields* based on this value. (For example: Adding _Prop4 number value if a 'Heal' _ThingClass or Subtracting if a 'Harm' _ThingClass item, Perhaps even loading from, saving to a different text file so that the files can have only stuff of their own type (maybe easier for sorting).)

While I welcome any snippets of advice relating to this, I'll narrow down the question focus and ask:

Are there any cases where using a StringBuilder to structure data and save to or load from a file would be the way to go?

PS. I have found the content of "Which C# data structure should I use to quantify this information?" to be a possible alternative to StringBuilder - but I guess that there can be more than one valid path.

Answer 1

Can a StringBuilder be used to do this? Yes.

Can a hammer be used to drive screws into wood. Yes.

Both are possible. Neither are a Good Idea.

What you're describing is a class that takes a line of text and delivers back to you the object represented by that line. That's could be a Factory class, or simply a "Reader" class responsible for loading your file.

Pretty much everything that you put into a StringBuilder has to be dragged back out again (as a String) before you can do anything with it (Replace being the notable exception). So, StringBuilders are good at bolting things together; pulling them apart again (to get to the individual items)? Not so much.

Also remember that a "single line" file format can be easily trashed when storing user-entered text items that can themselves contain line breaks.

Answer 2

First of all this has nothing to do with StringBuilder or string.Format. The question stays the same no matter how you generate the strings.

You are inventing a new serialization format. This means that you must write serialization and deserialization code.

Normally, this is not a good idea because it costs time and is error-prone. Use something read-made such as JSON, XML (XmlSerializer), BinaryFormatter, protobuf or others.

Which one you pick depends on what requirements you have. Normally, you would pick the one that causes the least amount of labor while fulfilling all requirements. If you don't know what to pick, JSON is a good (easy) start.