Placing part of a string into a variable 1

[Preka]

I'm looking for a way (currently working on something in Access) to place part of a string into a variable. The string in question is a filename, and the format is going to be:

TextThatIWant - MoreTextThatIWant - DateAndTimeInfo.txt

I want to put the two seperate "text that I want" blocks into variables for later use. Any ideas?

 

[PHV]

Have a look at the Split function.
You may also consider the InStr and Mid functions.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Preka]

Split did the trick - thanks a lot!