Getting part of the filename C#

Question

I have a file name dayhappy_02_02345.csv

How do I get the 02 part out to be used in a variable and also how do I get the 02345 part so that I can pass these 2 values into a variable for a function.

Using c#.

I have looked at GetFileName but this gets either the filename, the extention or the full file name only.

Thanks

Ste

Shai · Accepted Answer · 2012-06-12 13:56:51Z

5

For that specific file name,

string sData = "dayhappy_02_02345.csv";
string[] sArr = sData.split('_');

string sPart1 = sArr[1];
string sPart2 = sArr[2];

Will do, but that's a special case, will work only on file names of this type

answered Jun 12, 2012 at 13:56

Shai

25.7k9 gold badges47 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Steven Over a year ago

I think your answer might work, but im using a Dts.Variable and the filename with its extension is located in the variable. Will this work? Can you simply replace string sData = Dts.Variables["filenameVariable"].Value. thanks for quick response

Shai Over a year ago

Ofcourse you can. Furthermore, you have to insert some validations in this code, which I haven't included in the example above

Steven Over a year ago

I have this at the moment: string fileName = Dts.Variables["csvFileNames"].Value; string[] sArray = fileName.Split('_'); string 02345Number = sArray[1]; string 02Number = sArray[2]; MessageBox.Show(02345Number); saying can not convert object to string. Im being really silly here I reckon and im missing syntax, but i have this: using Microsoft.SqlServer.Dts.Runtime; in the namespace so I dont know what would be wrong with this. Thanks for your help

Steven Over a year ago

Sorry I was being very stupid. I was missing a (). lol thanks

David · Accepted Answer · 2012-06-12 13:56:01Z

4

Get the file name as you've already figured out, then use String.Split() to get the individual pieces.

answered Jun 12, 2012 at 13:56

David

73.7k19 gold badges134 silver badges177 bronze badges

6 Comments

Mr. TA Over a year ago

I would advise against using string methods, since change of format will force you to change the code, whereas with Regex you can make the string a configuration setting, and it's more flexible and powerful anyways.

David Over a year ago

@Mr.TA - Fair enough. I agree in general, but in this specific example, String.Split is sufficient. This is subjective, but I like cleaner simpler code, where possible. Also, this is obviously a very new developer, so I gave the simplest answer possible. Learning Regular Expressions is something that needs to be done, but does he need it right now, for this case? I was thinking baby steps before running. But again, I DO agree with what you say in general.

Steven Over a year ago

The filename keeps changing but the extension doesn't, also I have the file in a dts variable. is the Regex way the best way forward?

Mr. TA Over a year ago

Judging by the other answers, the splitting is more popular, who am I to argue with the PEOPLE's choice :)

Mr. TA Over a year ago

@Steven The "filename keeps changing" - meaning the format of it keeps changing?

|

Mr. TA · Accepted Answer · 2012-06-12 13:56:37Z

3

You have to use Regex:

var match = new Regex(@".*_(\d+)_(\d+)").Match(Path.GetFileNameWithoutExtension(fileNAme));
var v02 = match.Groups[0].Value;
var v02345 = match.Groups[1].Value;

answered Jun 12, 2012 at 13:56

Mr. TA

5,3771 gold badge31 silver badges37 bronze badges

Collectives™ on Stack Overflow

Getting part of the filename C#

3 Answers 3

4 Comments

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related