topic Re: get a part of a string in QlikView

get a part of a string

Thu, 29 Oct 2015 11:39:40 GMT

Hello all,

In my qlikview document I load a couple of document locations. The problem is that i only want to load the document name and not the entire path. The problem is that the path to the documents isn't always the same length. For example:

What I load	What I need
C:\Documents\document1.qvw	document1.qvw
C:\Documents\Customer1\Document3.qvw	Document3.qvw
C:\Documents\Customer 3\Document 2.qvw	Document 2.qvw

Does anybody know a solution for this problem?

Thanks a lot for your help!

Re: get a part of a string

marcus_malinow — Thu, 29 Oct 2015 11:43:50 GMT

subfield([Source field], '\', substringcount([Source field], '\') + 1) as [Destination field]

Re: get a part of a string

marcus_malinow — Thu, 29 Oct 2015 11:44:37 GMT

or subfield([Source field], '\', -1) as [Destination field]

Re: get a part of a string

Thu, 29 Oct 2015 11:45:33 GMT

Hello,

Could you use right(DocumentName(),13)??

Regards.

Re: get a part of a string

tresB — Thu, 29 Oct 2015 11:45:49 GMT

Subfield(YourPath, '\', -1)

Or,

You might check if file functions like:

Filename() could help you.

Re: get a part of a string

rubenmarin — Thu, 29 Oct 2015 11:47:14 GMT

SubField[FieldName], '\', -1)

Subfield splits a string base don a specified separator, the parameters:

1st: the string

2nd: the separator

3rd: wich splited part you want to retrieve, negative numbers counts starting by the last

Re: get a part of a string

miguelbraga — Thu, 29 Oct 2015 11:49:00 GMT

Hi mate,

I've done what you need by using this expression:

=SubField(LOAD, '\', substringcount(LOAD, '\')+1)

Here take a look at my qvw

Regards,

Re: get a part of a string

Thu, 29 Oct 2015 11:49:32 GMT

Thank you very much! This was exactly what I need!

Re: get a part of a string

gsbeaton — Thu, 29 Oct 2015 11:49:59 GMT

You can use the subfield() function like this:

SubField('C:\Documents\Customer 3\Document 2.qvw','\',-1)

The second parameter allows you to break the string down, in your case by the backslash and passing the -1 parameter at the end of the function will ensure you only ever pick up the final part of the string.

Re: get a part of a string

MarcoWedel — Thu, 29 Oct 2015 23:42:16 GMT

Hi,

maybe also helpful:

tabFileNames:
First 1
LOAD FileName() as FileName, [@1:1] as Temp
FROM QlikCommunity_Thread_189*.qvw (fix, codepage is 1252);

DROP Field Temp;

regards

Marco