Link Editor - need to parse contents of a URL

[Former Member]

I am receiving an xml document in a transaction that is all one string, such as:

"db://MyLibrary/WEB/Work/12345.xsl"

And I need to be able to parse it out to retrieve the part of it after the last "/" - 12345.xsl.

How do you find the last occurrence of a character (or count them) in the Assign action in MII?

[Former Member · Accepted solution]

Hi Scatham,

Try using the String List To XML Parser action in the XML Functions category. Your input string will be "db://MyLibrary/WEB/Work/12345.xsl" and the Delimeter will be "/". The output will be an xml document, in MII format, with each piece inbetween the / (forward slashes) in its own row. The file name will always be in the last row.

Kind Regards,

Diana Hoppe

[Former Member · Accepted solution]

Much easier than how I had been trying to do so! Thank you very much!

[Former Member · Accepted solution]

Glad to help