TRIM

[nareshthavidishetty]

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]

The string you get is this?

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

[nareshthavidishetty]

yes..

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

Thanks..

TRIM

'

[Anonymous · Accepted solution]

Try this:

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

[nareshthavidishetty]

Can i have explanation..

[Anonymous]

You want me to explain?

[m_woolf]

This might be a little simpler:

subfield(YourField,'>',2)