topic Re: Help in using subfield function in QlikView

Help in using subfield function

Thu, 07 May 2015 09:50:29 GMT

Hi All,

I have a filename as 'MM.YYYY Test_name Sample_test.xls'.

I want to just store the part Test_name Sample_test in a field .

Thanks,

Asma

Re: Help in using subfield function

rubenmarin — Thu, 07 May 2015 10:04:34 GMT

Hi Asma, in example:

'Test_name': =Subfield('MM.YYYY Test_name Sample_test.xls', ' ', 2)

'Sample_test': =Left(Subfield('MM.YYYY Test_name Sample_test.xls', ' ', -1), Index(Subfield('MM.YYYY Test_name Sample_test.xls', ' ', -1), '.', -1)-1)

If Test_name or Sample_test can have blank spaces it could be a problem, as you can't identify which part will be the Test_name and wich one is the Sample_test.

Re: Help in using subfield function

Thu, 07 May 2015 10:11:06 GMT

I want to store Test_name Sample_test, this entire thing in a single variable.

Is it possible by some other way rather than using subfield function

Re: Help in using subfield function

rubenmarin — Thu, 07 May 2015 10:15:33 GMT

Ok, I misundertood, then is easier because the first part to ignore has 8 fixed characters, it can be:

=Mid('MM.YYYY Test_name Sample_test.xls', 9, Index('MM.YYYY Test_name Sample_test.xls', '.', -1)-9)

Re: Help in using subfield function

Thu, 07 May 2015 10:47:02 GMT

Thanks for such a quick reply