Returning various parts of the same string

[rhythmz]

I am developing an audit report in which I want to obtain the folder path to a report. However, the best result set that I can get to is something similar to:

/content/folder[@name='Credit Group']/folder[@name='Account Management']/folder[@name='Loan Officer Portfolios']/report[@name='Credit Line Approvals']

I greatly desire to achieve an output like:

Credit Group/Account Management/Loan Officer Portfolios/Credit Line Approvals

However, I am literally  :-\ brain dead :-\ on how to accomplish this...SUBSTR comes to mind, however, the length of the string and occurrences of "']/folder[@name='" can vary according to the actual folder path. I am trying to determine those reports in my catalog that are NOT getting used regularly to archive....I can see 'last run date' but cannot determine the frequency of use with the current given RS parameters. BTW, I have no admin panel access.

Thank so much for any help provided,
Dennis

[New_Guy]

Hi,
You can try using position and substring get the desired output. I will find the actual sql that I got it to work.
Good luck
New guy


Sent from my iPhone using Tapatalk

[Lynn]

I am developing an audit report in which I want to obtain the folder path to a report. However, the best result set that I can get to is something similar to:

/content/folder[@name='Credit Group']/folder[@name='Account Management']/folder[@name='Loan Officer Portfolios']/report[@name='Credit Line Approvals']

I greatly desire to achieve an output like:

Credit Group/Account Management/Loan Officer Portfolios/Credit Line Approvals

However, I am literally  :-\ brain dead :-\ on how to accomplish this...SUBSTR comes to mind, however, the length of the string and occurrences of "']/folder[@name='" can vary according to the actual folder path. I am trying to determine those reports in my catalog that are NOT getting used regularly to archive....I can see 'last run date' but cannot determine the frequency of use with the current given RS parameters. BTW, I have no admin panel access.

Thank so much for any help provided,
Dennis

This post is a duplicate of this post. I provided an answer already in the other post.

[rhythmz]

Honestly, I was looking for a previous post before I posted mine :o ....I swear... ;D

Thank you immensely for directing me to it!!!

Dennis