Comma seperated values

Question

0.00/5 (No votes)

See more:

I am getting a string like

50' FRAME CABLE 2W (6X)50' FRAME CABLE 3W (9X)

but i want to show it like 50' FRAME CABLE (2W (6X),3W (9X))

In this line i am getting the value

C#

StringBuilder terminalBoxSummary = GetFrameCableSensorCableSummary(terminalBoxs);

C#

private static StringBuilder GetFrameCableSensorCableSummary(List<SageControlBase> igus_Sensors)
      {

          var frameCables2WCount = igus_Sensors.Where(x => ((x as IGUs) != null && (x as IGUs).BusBars == SageConstants.BusBarsTypes.Two));
          var frameCables3WCount = igus_Sensors.Where(x => ((x as IGUs) != null && (x as IGUs).BusBars == SageConstants.BusBarsTypes.Three));
          var frameCables4WCount = igus_Sensors.Where(x => ((x as IGUs) != null && (x as IGUs).BusBars == SageConstants.BusBarsTypes.Four));

          var sensorcables2WCount = igus_Sensors.Where(x => ((x as Sensors) != null && (x as Sensors).BusBars == SageConstants.BusBarsTypes.Two));
          var sensorcables3WCount = igus_Sensors.Where(x => ((x as Sensors) != null && (x as Sensors).BusBars == SageConstants.BusBarsTypes.Three));
          var sensorcables4WCount = igus_Sensors.Where(x => ((x as Sensors) != null && (x as Sensors).BusBars == SageConstants.BusBarsTypes.Four));

          StringBuilder frameCableSummary = new StringBuilder();

          foreach (var group in frameCables2WCount.GroupBy(x => (x as IGUs).FrameCableLength))
          {
              if (group.Count() > 0)
                  frameCableSummary.AppendLine(string.Format("{0}' FRAME CABLE 2W ({1}X)", (group.FirstOrDefault() as IGUs).FrameCableLength.ToString(), group.Count().ToString()));
          }

          foreach (var group in frameCables3WCount.GroupBy(x => (x as IGUs).FrameCableLength))
          {
              if (group.Count() > 0)
                  frameCableSummary.AppendLine(string.Format("{0}' FRAME CABLE 3W ({1}X)", (group.FirstOrDefault() as IGUs).FrameCableLength.ToString(), group.Count().ToString()));
          }

          foreach (var group in frameCables4WCount.GroupBy(x => (x as IGUs).FrameCableLength))
          {
              if (group.Count() > 0)
                  frameCableSummary.AppendLine(string.Format("{0}' FRAME CABLE 4W ({1}X)", (group.FirstOrDefault() as IGUs).FrameCableLength.ToString(), group.Count().ToString()));
          }

          foreach (var group in sensorcables2WCount.GroupBy(x => (x as Sensors).FrameCableLength))
          {
              if (group.Count() > 0)
                  frameCableSummary.AppendLine(string.Format("{0}' SENSOR CABLE 2W ({1}X)", (group.FirstOrDefault() as Sensors).FrameCableLength.ToString(), group.Count().ToString()));
          }

          foreach (var group in sensorcables3WCount.GroupBy(x => (x as Sensors).FrameCableLength))
          {
              if (group.Count() > 0)
                  frameCableSummary.AppendLine(string.Format("{0}' SENSOR CABLE 3W ({1}X)", (group.FirstOrDefault() as Sensors).FrameCableLength.ToString(), group.Count().ToString()));
          }

          foreach (var group in sensorcables4WCount.GroupBy(x => (x as Sensors).FrameCableLength))
          {
              if (group.Count() > 0)
                  frameCableSummary.AppendLine(string.Format("{0}' SENSOR CABLE 4W ({1}X)", (group.FirstOrDefault() as Sensors).FrameCableLength.ToString(), group.Count().ToString()));
          }
          return frameCableSummary;
      }

Posted 29-Dec-14 0:49am

chandra sekhar

Updated 29-Dec-14 1:07am

v3

Add a Solution

Comments

Suvendu Shekhar Giri 29-Dec-14 6:50am

Please format the code so that others can understand and accordingly can help you :)

Garth J Lancaster 29-Dec-14 6:51am

What is the definition of [GetFrameCableSensorCableSummary] Procedure - what does it return ?

chandra sekhar 29-Dec-14 6:53am

It Returns this string 50' FRAME CABLE 2W (6X)50' FRAME CABLE 3W (9X)

Garth J Lancaster 29-Dec-14 6:56am

we cant help you if you don't show da code for that procedure

chandra sekhar 29-Dec-14 7:08am

I have updated the question

KaushalJB 29-Dec-14 6:53am

Your string would be fixed like "50' FRAME CABLE 2W (6X)50' FRAME CABLE 3W (9X)" ? or it can be any ?

chandra sekhar 29-Dec-14 6:55am

The format is like that but some times i can get like 50' FRAME CABLE 2W (6X)50' FRAME CABLE 3W (9X) 50' FRAME CABLE 4W (9X)

ridoy 29-Dec-14 6:56am

You need to use Regex to achieve that.

chandra sekhar 29-Dec-14 7:14am

Any help on how can i achieve it coz i have never used regular expressions.

ridoy 29-Dec-14 7:18am

Yes, a jump start for you. After completing it you can solve it yourself i hope. See: http://www.codeproject.com/Articles/9099/The-Minute-Regex-Tutorial

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)

BillWoodruff · Answer 1 · 2014-12-29T04:37:00

Example of one approach that does not use RegEx:

C#

private string dString = @"50' FRAME CABLE 2W (6X)50' FRAME CABLE 3W (9X) 50' FRAME CABLE 4W (9X)";
  
private string fancyOutput(string source)
{
    string[] parse = source.Split(new string[] {"FRAME CABLE"}, StringSplitOptions.RemoveEmptyEntries);

    StringBuilder sb;

    if (parse.Length >= 2)
    {
        string first = parse[0];

        sb = new StringBuilder(first + "Frame Cable (");

        for (int i = 1; i < parse.Length; i++)
        {
            sb.Append(parse[i].Replace(first, ""));
            sb.Append(",");
        }

        sb.Remove(sb.Length - 1, 1);
        sb.Append(")");

        string result = sb.ToString();

        // for debugging only
        Console.WriteLine(result());

        return result;
    }
    else
    {
        return "something went wrong: check input string";
    }
}

suneel kumar gupta · Answer 2 · 2014-12-29T01:39:00

Solution 1

replace 50' FRAME CABLE with (,) using Regx skiping first occurence.
Your will get string like-
50' FRAME CABLE 2W (6X),3W (9X),4W (9X)

Posted 29-Dec-14 1:39am

suneel kumar gupta