Subfield

[miro_kopecky]

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

[Anil_Babu_Samineni]

Try this?

=SubField(FileName, '\', -2)&'\'&SubField(FileName, '\', -1)

[agigliotti]

you can do it using Mid function in your script as below:

Mid(FileName, 30) as new_field;

I hope it helps.