Single variable split to multiple variables in C# class

Question

1.00/5 (1 vote)

See more:

Hi,

I have the column called Codes and the data will return from db like this
Codes=str12,str124,str124...
I need to split this in class and assign to another variables as i need to display these rows in excel sheet..

Can you please help me to fix this...

Thanks.

What I have tried:

Example:

<pre>public string codes { get; set; }

public string codes_format
   {
     get {
       return values
        string[] values = _codes.Split(',');
       for (int i = 0; i < values.Length; i++)
       {
         values[i] = values[i].Trim();
       }
     }
   }

like codes_format1, codes_format2, ... codes_format8..

Posted 7-May-20 6:51am

.net333

Updated 7-May-20 10:10am

v2

Add a Solution

Comments

F-ES Sitecore 7-May-20 13:21pm

Doe the properties "codes_format1" etc already exist on the class?

RmcbainTheThird 7-May-20 13:30pm

that snippet will not even compile. You are returning values before declaring it,you mark your get as a string and yet when you do declare it you declare it as an array.

1 solution

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)

MadMyche · Accepted Answer · 2020-05-07T10:11:00

So you have a column in the DB called codes which is actually comma-delineated values

You have a generic get...set for this public property.
The code you have presented references a property/field called _codes

Normally an underscore represents a private field and is intuitively named by the property which refers to it, something like this

C#

private string _codes { get; set; }
public  string  codes { get { return _codes; } set { _codes = value; } }

Now what it looks like is that you want those codes to come back as a series of values. And you want those values trimmed of any white-space.

You can try working off of this block of code to bring that value back as an array

C#

public string[] codes_format
{
     get
     {
          return (Array.ConvertAll(_codes.Split(','), p => p.Trim()));
     }
}