Adding portion of filename to field

[suzannemonette]

Hi Everyone,

I'm hoping someone out there who has programming skills might be able to help someone who has no programming skills and frankly isn't wired to do it! Me!

I can't imagine this would be easy at all - but here's what I'm hoping to have done.

I have about 2500 csv files. For each csv file I'd like to take a portion of the name and add it to a new field for each record in that csv. The idea is the name has a unique identifier in it and if I can get that unique identifier in a field I can append all these csv files into one yet still know where each record came from. There is at the moment no unique Identifier in the records.

Each csv name is formatted essentially the same way - here it is. Stands_GM_A4535625344_all_returns_elevation_stats.csv The A4535625344" portion of the name will always have a letter at the start but the number of numbers after that may be different (I think 8-11).

So, I'd like to take the "A4535625344" portion of the name of a csv and enter it into a new field in the same csv that the name came from.

I couldn't write this code to save my life so any help would be great!

Thanks!

Sue:

[JBeaucaire]

Rather than edit the CSV itself, I already have a macro that inserts the CSV fieldname into col A as multiple CSVs are imported into a single master sheet. Like so:

Please Login or Register  to view this content.

[JBeaucaire]

Here's a second routine that can be added to get just the numeric portion of the name string and put it into the col A values.

Please Login or Register  to view this content.

[suzannemonette]

Hi!

Man people that can code are so great! My first question is, the code that pulls out the number in a file name, will that work on my filename since the unique identifier has a letter in front of the number? The letter is part of what makes it unique (I think - not much documentation on how they named things) so it would be a huge bonus to keep it.

Sue

[JBeaucaire]

Is the string you want always the 3rd part? That might be easier...

[JBeaucaire]

Maybe just change this one line in the Function:

Please Login or Register  to view this content.

[suzannemonette]

Maybe just change this one line in the Function:

Please Login or Register  to view this content.

Thanks! I'll give it a try and see how it goes.

Sue