string manipulation - 2

Question

2.00/5 (1 vote)

See more:

I've got text in a file as such:

MSIL

VMMAnalogs_Acquire.c                    1.26  2001_105/02  2001_105/02
    Analogs_Acquire                                  100%         100%
VMMAnalogs_Initialise.c                 1.25  2001_053/02  2001_053/02
    Analogs_InitialiseInput                          100%         100%

I want to write this data to a csv file, thus need to replace certain white space sections with a comma, as such:

VMMAnalogs_Acquire.c,1.26,2001_105/02,2001_105/02
    Analogs_Acquire,100%
VMMAnalogs_Initialise.c,1.25,2001_053/02,2001_053/02
    Analogs_InitialiseInput,100%

Here is code that replaces all white spaces with to get started:

MIDL

string input = listTxtFileContents[line_idx];
string pattern = "\\s+";
string replacement = ",";
Regex rgx = new Regex(pattern);
string result = rgx.Replace(input, replacement);

listTxtFileContents[line_idx] = result;

Can anyone help me please?

The problem that I'm facing is that the code replaces all the spaces with a single comma. I don't want it to replace the indentation of the 2nd and the 4th line's, words. (Analogs_Acquire and Analogs_InitialiseInput)

P.S. please vote up/down!

Posted 17-Nov-10 22:57pm

R. Erasmus

Updated 17-Nov-10 23:48pm

v2

Add a Solution

Comments

Manfred Rudolf Bihy 18-Nov-10 5:21am

I'd be glad to help you if only I knew what problems you have with your code.
You could at the very least specify what issues you're facing.

R. Erasmus 18-Nov-10 5:48am

I've updated the code to contain the problem that I'm facing...

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Fredrik Bornander · Answer 1 · 2010-11-17T23:39:00

Try this;

MSIL

using System;
using System.Text;
using System.Text.RegularExpressions;
namespace SomeNameSpace
{
    class Program
    {
        private static string input = "VMMAnalogs_Acquire.c                    1.26  2001_105/02  2001_105/02\n" +
                               "Analogs_Acquire                                  100%         100%\n" +
                               "VMMAnalogs_Initialise.c                 1.25  2001_053/02  2001_053/02\n" +
                               "Analogs_InitialiseInput                          100%         100%\n";
        static void Main(string[] args)
        {
            Regex regExp = new Regex("\\s+");
            StringBuilder result = new StringBuilder();
            foreach (string line in input.Split('\n'))
            {
                result.AppendLine(regExp.Replace(line, ","));
            }
            Console.WriteLine(result);
        }
    }
}

Hope this helps,
Fredrik

R. Erasmus · Answer 2 · 2010-11-18T00:32:00

I've found the solution to my problem and posted it down below, thanks!

C#

/* convert list buffer to csv (comma delimited) format */
for (line_idx = 0; line_idx < listTxtFileContents.Count; line_idx++)
{
  string input = listTxtFileContents[line_idx];
  string pattern = "\\s+";
  string replacement = ",";
  Regex rgx = new Regex(pattern);
  string result = rgx.Replace(input, replacement);
  listTxtFileContents[line_idx] = result;
  if (listTxtFileContents[line_idx].StartsWith(",") == true)
  {
    listTxtFileContents[line_idx] = listTxtFileContents[line_idx].Remove(0, 1);
    listTxtFileContents[line_idx] = "   " + listTxtFileContents[line_idx];
  }

}

P.S. VOTE - UP/DOWN ;)

string manipulation - 2

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0