Adding portion of filename to field

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: