Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
miro_kopecky
New Contributor III

Subfield

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

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)
agigliotti
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.