CODEWITHSUNDEEP
c#
prabu R
prabu R

Reputation: 2209

split comma separated string in c# and needs to save it in two separate variables

I have to split the comma - separated string in c# and needs to save it in two variables. The C# function is as follows :

public int InsertLogDetails(string RunIDStartTime, int Distribution_ID, List<string> additions, List<string> removals, bool status, string ErrorMessage)
{
    int Run_ID=0;
    DateTime StartTime=DateTime.Now;
    //Needs to split RunIDStartTime and needs to save it in Run_ID and StartTime
}

The RunIDStartTime holds the value of Run_ID ans StartTime.(Eg: 5,Jan 23 2013 9:31AM)

Anybody please helpout. Thanks in advance.

Upvotes: 0

Views: 10328

Answers (3)

nsconnector
nsconnector

Reputation: 836

public int InsertLogDetails(string RunIDStartTime, int Distribution_ID, List<string> additions, List<string> removals, bool status, string ErrorMessage)
{

    var tokens = RunIDStartTime.split(',');
    int Run_ID= int.Parse(tokens[0]);
    DateTime StartTime = DateTime.Parse(tokens[1],"MMM d yyyy h:mmtt", CultureInfo.InvariantCulture, DateTimeStyles.None);        
}

Upvotes: 0

Habib
Habib

Reputation: 223217

Use int.TryParse and DateTime.TryParseExact with DateFormat to parse the string. To Split, using string.Split, Something like:

string RunIDStartTime = "5,Jan 23 2013 9:31AM";

int Run_ID = 0;
DateTime StartTime = DateTime.MinValue;
string[] splittedArray = RunIDStartTime.Split(',');
if (splittedArray.Length >= 2)
{
    if (int.TryParse(splittedArray[0], out Run_ID))
    {
        //valid ID
    }
    else
    {
        //Invalid ID
    }
    if(DateTime.TryParseExact(splittedArray[1],"MMM d yyyy h:mmtt",CultureInfo.InvariantCulture,DateTimeStyles.None, out StartTime))
    {
        //Valid date
    }
    else
    {
        //invalid date
    }
}

For output: 

Console.WriteLine("ID : {0} Date: {1}", Run_ID, StartTime.ToString());

Output:

ID : 5 Date: 23/01/2013 9:31:00 AM

Upvotes: 1

MethodMan
MethodMan

Reputation: 18843

Here is a working answer and you do not need to do .ToArray because Split already returns an array.

var RunIDStartTime = "5,Jan 23 2013 9:31AM";
var listSplit = RunIDStartTime.Split(','); 
var id = int.Parse(listSplit[0]);
var dateTime = DateTime.Parse(listSplit[1]);

returns id = 5 and date = Jan 23 2013 9:31AM

Upvotes: 3

Related Questions