How to take a substring of a string?

[Anonymous]

Hi guys,

i want to obtain a substring (last part) of a string, because i've a path conteining a file name and i have to retrieve only the file name.

The work case is the following:

PATH: C:\Users\thom.yorke\Desktop\Samples\file1.doc

PATH FOLDER: C:\Users\thom.yorke\Desktop\Samples\

NAME TO RETRIEVE: file1

Is there a method to subtract PATH FOLDER to string PATH?

[marcus_sommer · Accepted solution]

You could use:

subfield('C:\Users\thom.yorke\Desktop\Samples\file1.doc', '\', -1) to get the filename with extension and another subfield() could also split them like:

subfield(subfield('C:\Users\thom.yorke\Desktop\Samples\file1.doc', '\', -1), '.', 1)

If it should happens within a load you could also use filebasename().

- Marcus

[Anonymous]

Ok, it works fine!

Thank You a lot