Skip to Content
avatar image
Former Member

Link Editor - need to parse contents of a URL

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Aug 25, 2011 at 07:21 PM

    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

    Add comment
    10|10000 characters needed characters exceeded