split values in multiple column in c# windows application

Priyanka Kumari

7y742Learn iOS Programming

I have following data

where data before - is working hours,data after - is ot hours

0-16:02:04,08:00:00-00:10:35,08:00:00-00:10:19,08:00:00-00:25:58,08:00:00-01:29:01

I want data in following format

Working Hours Ot Hours

0 16:02:04

08:00:00 00:10:35

08:00:00 00:10:19

08:00:00 00:25:58

08:00:00 01:29:01

How i will achieve it

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suraj Kumar7y ago
Accepted answer
Request you to accept the answer as it also helps to other to find the correct answer.
Priyanka Kumari7y ago
I have solved this using:

I have store data in Datatable and then after used split and ternary operator

string[] wrkhrs = dt.Rows[i]["Working Hours"].ToString().Split(',');
if (wrkhrs.Length > 0)
{
string p1 = wrkhrs[k].Split('-')[1] == "" ? "00:00:00" : wrkhrs[k].Split('-')[1];
string p = wrkhrs[k].Split('-')[0] == "" ? "00:00:00" : wrkhrs[k].Split('-')[0];
}

@Suraj Kumar

You have given me a correct suggestion ,but i have soved this before your reply
Suraj Kumar7y ago
You can try the following query
create table #tempWorkingHours (WorkingHours varchar(20))
insert into #tempWorkingHours values ('0-16:02:04'),('08:00:00-00:10:35'),('08:00:00-00:10:19'),('08:00:00-00:25:58'),('08:00:00-01:29:01')

select REPLACE(firstCol, '-', '') AS [Working Hours], SecondCol as [Ot Hours] from (
select left(WorkingHours, CHARINDEX('-', WorkingHours)) as firstCol,
substring(WorkingHours, CHARINDEX('-', WorkingHours)+1, len(WorkingHours)-(CHARINDEX('-', WorkingHours)-1)) as SecondCol
from #tempWorkingHours
)temp

DROP TABLE #tempWorkingHours
The output is as shown below
Working Hours Ot Hours
0                   16:02:04
08:00:00            00:10:35
08:00:00            00:10:19
08:00:00            00:25:58
08:00:00            01:29:01
You can find the live demo here - https://rextester.com/IUGL73259
Above query works in sql server and the below code work in C#.Net also.

EDIT
//Rextester.Program.Main is the entry point for your code. Don't change it.
//Compiler version 4.0.30319.17929 for Microsoft (R) .NET Framework 4.5

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text.RegularExpressions;

namespace Rextester
{
    public class Program
    {
        public static void Main(string[] args)
        {
        string s = "0-16:02:04,08:00:00-00:10:35,08:00:00-00:10:19,08:00:00-00:25:58,08:00:00-01:29:01";

        string[] words = s.Split(',');
        foreach (string word in words)
        {
            var works = word.Split('-');
            string workingHours = works[0];
            string Othours = works[1];

            Console.WriteLine(workingHours + ' ' + Othours);
        }
        }
    }
}
See the live demo in C#.Net - https://rextester.com/LUCLBR34147
Hope you will find it as helpful & mark it as accepted answer also.
Piyush Pansuriya7y ago
You can write code as :
{
string s = "0-16:02:04,08:00:00-00:10:35,08:00:00-00:10:19,08:00:00-00:25:58,08:00:00-01:29:01";

string[] times = s.Split(',');
List tblTime = new List();
foreach (string time in times)
        {
            Timing objTime = new Timing();
            objTime.WorkingHours = time.split[0];
             objTime.OtHours = time.split[1];
              tblTime.Add(objTime);
        }
}

public class Timing
{
string WorkingHours;
string OtHours;
}