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:
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?
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.