Issue with date format when exporting to excel

Question

User1267402261 posted

Hi,
    I have a grid where i have to filter the columns like multiple search filter and what ever records i get in the grid i am doing export to excel in c#

Everything was went well except the date column in the grid the date column data is in this format 2014/11//15

here is my c# code which i am using to remove special characters

 private void getfilterdata(string filter, out string key, out string val)
        {
            key = string.Empty;
            val = string.Empty;
            if (!string.IsNullOrEmpty(filter))
            {
                string[] retval2 = filter.Split(new string[] { "data" }, StringSplitOptions.RemoveEmptyEntries);
                if (retval2 != null && retval2.Count() > 1 && !string.IsNullOrEmpty(retval2[1]))
                {
                    string[] strkeys = retval2[0].Split(new char[] { '"' }, StringSplitOptions.RemoveEmptyEntries);
                    if (strkeys.Length >= 3 && !string.IsNullOrEmpty(strkeys[3]))
                    {
                        key = strkeys[3];
                        val = RemoveSpecialCharacters(retval2[1]);
                    }
                }
            }
        }

In the key its shows column name and in the val it shows data..
in the val i am getting data as 20141115.


So its not matching and while exporting its empty i am not getting any records becaus e of this

this is my code for RemoveSpecialCharacters

 public static string RemoveSpecialCharacters(string str)
        {
            return Regex.Replace(str, "[^a-zA-Z0-9_.]+", "", RegexOptions.Compiled);
        }

 

Any help plz.....

Answer 1

User1508394307 posted

You replace all characters except a-zA-Z0-9_. and that's why / was replaced in 2014/11/15

Answer 2

User1267402261 posted

What is the workaround now....what is the new method i can use for removingspecialcharacters..

Answer 3

User1508394307 posted

Well, the "workaround" is not to use that method (at least not for the date column) because / is not a special character. In other case, just add / in 

[^a-zA-Z0-9_./]+

Answer 4

User-1910946339 posted

What result do you want?

Show us some sample input and the result that you want generated for each sample input.