Return the link from Link to Item field

Hi Jason,

Can you give us a bit more detail about what you are trying to accomplish? I know that you can assign the link to Item to a hyperlink control in Smartforms, but that doesn't seem like what you are wanting to do.

You could create a new control (data label for example) that isn't bound to a field and then add an expression to that field to maniplulate the value. The expression would look something like this:

I do a mid because I want to find your URL. The starting position I cheat in this example because I know that the Link to Item K2 Service Defined starts with <hyperlink><link>. Beginning < to ending > is 17 characters and I would need to add one to start with the first character of your URL. You have to remember this is zero based, so I used 17 as starting the count from zero I would have had 16.

I then use a Find to locate the closing tag for your url </link>. I am assuming that the find is going to give me the starting index location of the </link> string. I subtract the length of the original 17 characters from the index returned by find to give me the total length of the URL I should return.

I did something similar to this in InfoPath using Substring-Before with a nested Substring-After to return just the URL.

This may be not be the best way to do this, so the more detail you can proivde around your use case we can come up with a more appropriate solution.