how to split string date

Question

1.00/5 (2 votes)

See more:

How to split string

how could i split this string?

JavaScript

year + "-" + month + "-" + day + " " + hours + ":" + minutes + " , " + yearto + "-" + monthto + "-" + dayto + " " + hoursto + ":" + minutesto

JavaScript

var res = listItemFromAndToDate.split("");

So i can add them like this

C#

var fromDate = res[0]; // year month day
var fromTime= res[1]; // hours minutes
var toDate = res[2];  // yearsto monthto dayto
var toTime = res[3]; // hoursto hoursfrom

My string looks like this 2014-12-05 20:00 , 2014-12-06 21:00

Posted 5-Dec-14 9:37am

Kurac1

Updated 5-Dec-14 9:47am

v2

Add a Solution

Comments

Zoltán Zörgő 5-Dec-14 15:42pm

Not clear. You want to split an actual string like: 2010-01-02 10:25, 2011-02-14 19:00, or the exact string you have posted:

year + "-" + month + "-" + day + " " + hours + ":" + minutes + " , " + yearto + "-" + monthto + "-" + dayto + " " + hoursto + ":" + minutesto

? Please provide a more precise example, and expected result.

Kurac1 5-Dec-14 15:47pm

I have updated

ZurdoDev 5-Dec-14 15:46pm

I'm confused. It looks like you are already splitting the string. What exactly is your question?

PIEBALDconsult 5-Dec-14 16:04pm

Regular Expression?

4 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)

hossein64 · Answer 1 · 2014-12-05T10:04:00

JavaScript

//sample : 
var listItemFromAndToDate = "2014-01-01 01:52 , 2014-09-15 16:24";
var str_array = listItemFromAndToDate.split(' '); //seperation with space

        var fromDate = res[0]; // year month day
        var fromTime= res[1]; // hours minutes
        //----------- res[2] = ,
        var toDate = res[3];  // yearsto monthto dayto
        var toTime = res[4]; // hoursto hoursfrom

or -->
var str_array = listItemFromAndToDate.split(' , ');
var dateAndTimeFrom = str_array[0];
var dateAndTimeTo = str_array[1];
var from_array = dateAndTimeFrom.split(' ');
var to_array = dateAndTimeTo.split(' ');
        var fromDate = from_array[0]; // year month day
        var fromTime= from_array[1]; // hours minutes
        var toDate = to_array[0];  // yearsto monthto dayto
        var toTime = to_array[1]; // hoursto hoursfrom

**Zoltán Zörgő** · Answer 2 · 2014-12-05T10:08:00

Here you have it with regexp:

JavaScript

<pre>
<script>
var re = /(\d{4}-\d{2}-\d{2}) (\d{2}:\d{2})\s*,\s*(\d{4}-\d{2}-\d{2}) (\d{2}:\d{2})/;

var str = '2014-12-05 20:00 , 2014-12-06 21:00';

var res = re.exec(str);

document.writeln(res[1]);
document.writeln(res[2]);
document.writeln(res[3]);
document.writeln(res[4]);

</script>
</pre>

mudgilsks · Answer 3 · 2014-12-05T21:10:00

hi,

Tyr this

var dateStr = "2014-01-01 01:52 , 2014-09-15 16:24";
var str_array = dateStr.split(' , ');

var FromDateTime As DateTime = DateTime.Parse(str_array[0])
var FromDate As String = FromDateTime.ToString("dd/MMM/yy")
var FromTime As String = FromDateTime.ToString("HH:mm")

var ToDateTime As DateTime = DateTime.Parse(str_array[1])
var ToDate As String = ToDateTime.ToString("dd/MMM/yy")
var ToTime As String = ToDateTime.ToString("HH:mm")

var fromDate = FromDate; // year month day
var fromTime= FromTime; // hours minutes
var toDate = ToDate; // yearsto monthto dayto
var toTime = ToTime; // hoursto hoursfrom

/\jmot · Answer 4 · 2014-12-05T23:17:00

try this..

C#

string strDate = "2014-12-05 20:00 , 2014-12-06 21:00";
string[] strAr = strDate.Split(',');

datetime dtFrom=Convert.ToDateTime(strAr[0])
datetime dtTo=Convert.ToDateTime(strAr[1])

now you can get the shor date or time string from this datetime format ..like
dtFrom.ToShortTimeString();
dtFrom.ToShortDateString();

dtTo.ToShortTimeString();
dtTo.ToShortDateString()

how to split string date

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0