topic Problem with Right() function! in QlikView

Problem with Right() function!

Wed, 17 Mar 2010 15:47:02 GMT

Hi,

I'm using QV 8.5 and I'm having a problem with the right() function.

This is what I'm writing:

LET V_File_Ext = right(text('ABC123567901xls'),12);

And it's returning 123567901xls.

It should returing xls since I have 12 chars before it.

Am I doing something wrong?

The QV file is attached.

Thanks,

Cassiano

Problem with Right() function!

Wed, 17 Mar 2010 15:56:45 GMT

The function is working as expected. Per the documentation, the Right() function returns the rightmost n characters. So, Right('somelongstring', 12) will return 'melongstring'.

The relevant portion of the documentation reads "Substring of the string s. The result is a string consisting of the last n characters of s."

Problem with Right() function!

Wed, 17 Mar 2010 16:11:49 GMT

Thanks, I didn't understand the function before.

Problem with Right() function!

rwunderlich — Wed, 17 Mar 2010 23:47:18 GMT

If you want to extract the extension from the filename a good function is subfield()

LET V_File_Ext = subfield('ABC12356790.xls', '.', -1);

-Rob