strip value

[RompStar]

my file name convention is: Store_number_restoffilenameblablabla.xls

example:

Store_43_July2011.xls

I need to strip the store number, just not sure how to do that using the InStr function, or whatever is the best way, need it to work in VBA, thank you!

 

[Jonmo1]

You can use split...

FleNm = "Store_number_restoffilenameblablabla.xls"
MyStore = Split(FleNm,"_")(0)

 

[RompStar]

Hi there, I tried the example, the string that I got back was "Store", but I need the Store number: 43 in my example

 

[RompStar]

this worked!

FleNm = "Store_24_restoffilenameblablabla.xls"
MyStore = Split(FleNm, "_")(1)

Thanks! A LOT!

 

[Jonmo1]

oh, yes...

Split makes an array of all the values deliminated by the _

0 is the first
1 is the 2nd
2 is the 3rd
etc..

 

[RompStar]

Way Cool! A new function that I have just learned about, thanks!