Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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?

Former Member
Former Member replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question