title: What would be the most efficient way to parse the input from a specific column into separate columns?
body: <p>I have a CSV file with a specific column Message with the following input inside of it that I would like to separate out properly. Please be aware that that snippet below does not look like this in Excel where I currently need it to be formatted for</p>
  
  <pre><code>    ["CorrelationId: b99fb632-78cf-4910-ab23-4f69833ed2d9
  Request for API: /api/acmsxdsreader/readpolicyfrompolicyassignment Caller:C2F023C52E2148C9C1D040FBFAC113D463A368B1 RequestedSchemas: {urn:schema:Microsoft.Rtc.Management.Policy.Voice.2008}VoicePolicy, {urn:schema:Microsoft.Rtc.Management.Policy.Voice.2008}OnlineVoiceRoutingPolicy,  TenantId: 7a205197-8e59-487d-b9fa-3fc1b108f1e5"]
  </code></pre>
  
  <p>I would like to separate it out so that it will look like this.(The names of the column will be before the colon and the information inside of it will be what is after the colon.)</p>
  
  <pre><code>CorrelationID: b99fb632-78cf-4910-ab23-4f69833ed2d9
  Request for API: 
  /api/acmsxdsreader/readpolicyfrompolicyassignment
  Caller:C2F023C52E2148C9C1D040FBFAC113D463A368B1
  RequestedSchemas: {urn:schema:Microsoft.Rtc.Management.Policy.Voice.2008}VoicePolicy, {urn:schema:Microsoft.Rtc.Management.Policy.Voice.2008}OnlineVoiceRoutingPolicy,
  TenantId: 7a205197-8e59-487d-b9fa-3fc1b108f1e5[![enter image description here]
  </code></pre>
  
  <p>I have tried using the text-to-columns but in Excel but it does not come out correctly</p>
  
  <p>What I would like to know what is the best way to do this is. I am currently making a program in C# to try and parse it out properly but what I have does not work correctly. </p>
  
  <p>For any reference here is my C# code. However I am open to any way of doing this.</p>
  
  <pre><code>static void Main(string[] args)
      {
          using (TextFieldParser parser = new TextFieldParser(@"C:\Users\t-maucal\Desktop\MachineLearningTestSets\CSVParse.csv"))
          {
              parser.TextFieldType = FieldType.Delimited;
              parser.SetDelimiters(" ");
              while (!parser.EndOfData)
              {
                  //Process row
                  string[] fields = parser.ReadFields();
                  foreach (string field in fields)
                  {
                      Console.WriteLine(field);
                  }
              }
          }
      }
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/2pr6o.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2pr6o.png" alt="Message Column RAW FORMAT"></a>
  <a href="https://i.stack.imgur.com/ZI99d.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZI99d.png" alt="EXPECTED RESULT"></a></p>