Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor III


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

Bez názvu.png

Labels (2)
2 Replies

Re: Subfield

Try this?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Honored Contributor II

Re: Subfield

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

Mid(FileName, 30) as new_field;

I hope it helps.