CODEWITHSUNDEEP
c#sqlparsing
Jake Sankey
Jake Sankey

Reputation: 5137

C# parsing txt files IF name format is desired format

OK, I have txt files that I am parsing and saving into a sql db. The names are formatted like

R306025COMP_272A4075_20090929_080159.txt

However, there are a select few (out of thousands of files) with names that are formatted differently (particularly files that were generated as tests), example

R306025COMP_SU2_TestBottom_20090915_101441.txt

The reason this causes a problem for me is that I am using Split('_')[1,2,etc] to extract the R number, the 272A4075 portion, and the 20090929 (date) portion. When the application comes across the oddly named files, it fails because it is trying to parse 'TestBottom' as a date and inserts 'SU2' instead of the 272 number.

Basically I want the app to recognize that if the file's name is not formatted like my first example, skip it. Any advice?

Upvotes: 2

Views: 203

Answers (3)

slugster
slugster

Reputation: 49985

Use a regex match on the file name, which means it will match the regex anywhere in the filename (so you don't have to be concerned about exactly where in the string it occurs, and the exact result is extracted out for you). Then if you fail to find the required matches, skip the file (no exceptions are generated, you just get nothing in your Matches object).

I'd do you up a sample but i don't have VS handy at the moment. The Regex stuff lives in the System.Text.RegularExpressions namespace.

Upvotes: 1

kevingessner
kevingessner

Reputation: 18995

foreach (var fileName in fileNames) {
    if (fileName.Count(c => c == '_') != 3) continue;
    // etc...
}

Upvotes: 1

Kelsey
Kelsey

Reputation: 47766

Can you just do the following based on the split:

string[] parsedLine = yourData.Split('_');
string theR = parsedLine[0];
string theCode = parsedLine[1];
string theDatePart = (parsedLine.Length > 4) ? parsedLine[3] : parsedLine[2];

If you want it to just skip it the bad lines just do:

string[] parsedLine = yourData.Split('_');
if (parsedLine.Length > 4) continue;  // assuming your looping

Would need to see a little code if you want a better solution as I am not exactly sure how you are getting the line data.

Upvotes: 2

Related Questions