splitting a string

[spinkung]

hi

can someone point me in the direction of how to get just the file name out of the following (without the .xls)...

C:\Users\gfrewin\Documents\SupplierOutPO\Outstanding PO Lines.xls


I guessing i need to find the position of the last \ character somehow first?

Thanks

[TMS]

Use Split:

http://spreadsheetpage.com/index.php...plit_function/


Regards, TMS

[spinkung]

perfect thanks

[kbkumar]

Try:

Please Login or Register  to view this content.

[TMS]

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save