Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

How to take a substring of a string?

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?

Tags (2)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: How to take a substring of a string?

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

View solution in original post

2 Replies
MVP & Luminary
MVP & Luminary

Re: How to take a substring of a string?

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

View solution in original post

Highlighted
Contributor
Contributor

Re: How to take a substring of a string?

Ok, it works fine!

Thank You a lot