Get string right after . . .

[JT]

I need to get string right after "\".
For example if i have this path name
c:\Docs\Year\Months\June2007.txt
then i need get this string
June2007.txt

I used this

File Name: Left([Table1]![FileNm],InStrRev([Table1]![FileNm],"\")-1)

but it will remove that string i need.
Please help.
Thanks.

 

[Jason Lepack]

Untested:
RIGHT([FileNm], LEN([FileNm]) - InStrRev([FileNm],"\"))

 

[fredg]

I need to get string right after "\".
For example if i have this path name
c:\Docs\Year\Months\June2007.txt
then i need get this string
June2007.txt

I used this

File Name: Left([Table1]![FileNm],InStrRev([Table1]![FileNm],"\")-1)

but it will remove that string i need.
Please help.
Thanks.

FileName:Mid([FileNum],InStrRev([FileNum],"\")+1)

 

[KARL DEWEY]

You have 'Left' function and it seems to me you need 'Right.'

 

[JT]

Thank you so much it works perfectly.
It trims before last "\". Exactly way i want.
Thank you.

Untested:
RIGHT([FileNm], LEN([FileNm]) - InStrRev([FileNm],"\"))

I need to get string right after "\".
For example if i have this path name
c:\Docs\Year\Months\June2007.txt
then i need get this string
June2007.txt

I used this

File Name: Left([Table1]![FileNm],InStrRev([Table1]![FileNm],"\")-1)

but it will remove that string i need.
Please help.
Thanks.