Removing characters from field

khaycock — Sat, 16 Nov 2024 03:24:32 GMT

I want to use the filename of my datafile as a field however the filename is a URL as it's a webfile from SharePoint. Is there a way I can trim a field if the the result is currently like..?

/test.sp.test.com/sites/dept/it/Flat%2020File%20Repository/IT/test/Shapshots/2019-05%20Export.csv

Ideally all I want the field to show is 2019-05 but if its not possible to trim on from the right as well it doesn't matter, it just looks ugly with all the other bits in it!

Re: Removing characters from field

Colin-Albert — Mon, 03 Jun 2019 13:42:39 GMT

You can do this using a couple of subfield() commands, to extract the text from the end of the field to the first '/', then from the start of the extracted text to the first %.

subfield(subfield(<yourfilepath>, '/', -1), '%', 1) as file_date

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/StringFunctions/SubField.htm

topic Removing characters from field in QlikView

Removing characters from field

Re: Removing characters from field