topic Re: TRIM in QlikView

TRIM

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I need to show the below link in the qvw.I have used the pivot table.

When i import the field into table it gives full as below

Retail Employee GAP Report<URL>\\test.com\public\Scorecard Backups\Retail Employee GAP Report

But here i need only the link \test.com\public\Scorecard Backups\Retail Employee GAP Report

Let me know how to get this.

Thanks..

Anonymous — Tue, 13 Dec 2016 18:41:01 GMT

The string you get is this?

Retail Employee GAP Report<URL>\\test.com\public\Scorecard Backups\Retail Employee GAP Report

nareshthavidishetty — Tue, 13 Dec 2016 18:44:12 GMT

yes..

I need only this '\\test.com\public\Scorecard Backups\Retail Employee GAP Report

Thanks..

Anonymous — Tue, 13 Dec 2016 18:52:38 GMT

Try this:

Right([YourField],len([YourField]) - len(SubField([YourField],'\\',1)))

nareshthavidishetty — Tue, 13 Dec 2016 18:57:09 GMT

Can i have explanation..

Anonymous — Tue, 13 Dec 2016 19:33:08 GMT

You want me to explain?

m_woolf — Tue, 13 Dec 2016 20:34:13 GMT

This might be a little simpler:

subfield(YourField,'>',2)