Parsing out a section of a text file line.

[gjsala]

Thanks for your help in advance. I have a line in a text file for example: c:\program\Files\122310.xlm
I would like to capture the 122310.xml in the text file. The only catch this section will change from one text file to another for example now its 122310.xlm the next text file it could change to 92310.xml and as you can see the number of characters is different. Any help would be appreciated.

Thanks!

 

[PHV]

strLine = "c:\program\Files\122310.xlm"
MsgBox Mid(strLine, 1 + InStrRev(strLine, "\"))

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Bong]

You seem to be referring to the "file name" although you're using the term, "text file". If I'm right, I think your best approach would be with instr.

Let's say you have a string, strFN, that has the value, c:\program\Files\122310.xlm.

i=instr(1,strFN,"\")
do while i>-1
  strFN=mid(strFN,i)
  i=instr(1,strFN,"\")
loop

_________________
Bob Rashkin

 

[Bong]

Ah, instrrev. I didn't know about that one.

_________________
Bob Rashkin

 

[gjsala]

Thank you for the quick response! In my request c:\program\Files\122310.xlm this will be listed in the text file not the name of the text file. I'm looking to capture the 122310.xml but this 122310.xml will change and not have the same number of characters.

Thanks!

 

[SkipVought]

I'm looking to capture the 122310.xml but this 122310.xml will change and not have the same number of characters.

MsgBox Split("c:\program\Files\122310.xlm","\")(UBound(Split("c:\program\Files\122310.xlm","\")))

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[gjsala]

Thank you all for your help!