get date from string

Question

4.00/5 (1 vote)

See more:

If I have a string such as :

<filename>_yyyymmdd.csv

Note that <filename> varies.

How do I get the yyyymmdd into a date format using c# please?

Posted 10-Feb-12 5:48am

arkiboys

Updated 10-Feb-12 16:44pm

Chris Maunder772.7K

v2

Add a Solution

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)

Christian Graus · Answer 1 · 2012-02-10T05:50:00

Solution 1

You will need to use regex or string mashing to get your date out. Then if it's always this format, I am not sure if DateTime.TryParse will work, or if you need to string mash further to get out 3 numbers, use int.TryParse on all of them and then build a datetime from there.

Posted 10-Feb-12 5:50am

Christian Graus

Comments

arkiboys 10-Feb-12 11:51am

Yes, but not sure how to get the date.

Christian Graus 10-Feb-12 11:55am

I just told you, step by step. You find the _ and the . and extract the string between those two. Then you process it, probably as substrings and integers, because I don't think the parsing will recognise this format ( but you could try ).

ProEnggSoft · Answer 2 · 2012-02-10T06:44:00

If all your file names are in the same format as you have mentioned above, then you can use the following console application code snippet to get the date from the string in to the Date format

C#

using System;
using System.Collections.Generic;
using System.Text;

namespace DateString {
    class Program {
        static void Main(string[] args) {
            string fileName = "fileName_20120210.csv";

            DateTime date;
            int dateStringStart = fileName.LastIndexOf("_")+1;
            int dateStringLength = fileName.LastIndexOf(".")-dateStringStart;
            string dateString = fileName.Substring(dateStringStart, dateStringLength);
            date = new DateTime(Int32.Parse(dateString.Substring(0, 4)),
                                Int32.Parse(dateString.Substring(4, 2)),
                                Int32.Parse(dateString.Substring(6, 2)));

            Console.WriteLine(date);
            Console.ReadKey();
        }
    }
}