Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have table with columns FileName and Word as in the picture...
I need to subfield FileName to show only what's behind mole dataset\ so the result would be for example:
cestovny doklad\cest01(cz).jpg
Try this?
=SubField(FileName, '\', -2)&'\'&SubField(FileName, '\', -1)