How can I extract a portion of a string 1

[PleaseGiveHelp]

I am reading in a file name and I want to extract a piece of the file name. So if the filename is C:\Test\Test2\1234_Jingle[1].2_Done.csv, I only want the portion between the "-" and the "[". I believe I've done this within VB before but I cannot remember how. What function can I use to extract the piece? None of the truncation/trim functions allow me to travel to a character. Help!

 

[Golom]

Try
[blue][tt]
theString = Mid$(filename,
Instr(filename,"_") + 1,
Instr(filename,"[") - Instr(filename,"_")-1)
[/tt][/blue]

 

[PleaseGiveHelp]

This worked - thanks so much!!!!!

 

[ccwj]

Read up on the SPLIT Function in the VB Help

Let me know if this works for you