<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="https://www.infopathdev.com:443/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>SharePoint Integration</title><link>https://www.infopathdev.com:443/forums/46.aspx</link><description> For questions concerning issues in the integration of SharePoint and Microsoft InfoPath.</description><dc:language>en</dc:language><generator>CommunityServer 2007 SP3 (Build: 31118.962)</generator><item><title>Re: Retrieving Hyperlinks from a "Link" List in MOSS 2007</title><link>https://www.infopathdev.com:443/forums/thread/30598.aspx</link><pubDate>Sat, 19 Jul 2008 04:39:28 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:30598</guid><dc:creator>Clay Fox</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/30598.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&amp;PostID=30598</wfw:commentRss><description>&lt;p&gt;In Hyperlink control properties, if each is a seperate field in the secondary data, then you should be able to set one as the vale and one as the label.&lt;/p&gt;
&lt;p&gt;Another trick is to use a substring function to remove the extra.&lt;/p&gt;
&lt;p&gt;substring-before(link, %)&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;</description></item><item><title>Retrieving Hyperlinks from a "Link" List in MOSS 2007</title><link>https://www.infopathdev.com:443/forums/thread/30558.aspx</link><pubDate>Fri, 18 Jul 2008 01:39:20 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:30558</guid><dc:creator>tplaisted</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/30558.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&amp;PostID=30558</wfw:commentRss><description>&lt;p&gt;I&amp;#39;ve created a Links List in MOSS 2007 and am trying to use an IP 2003 form to retrieve the items from this list into the Form. That isn&amp;#39;t a problem but what I encounter is the Hyperlink attached to the List Item containst both the URL and the&amp;nbsp;&amp;quot;Description&amp;quot; from the original List Item in MOSS (see below). What then happens is in the IP 2003 Form the Hyperlink concatenates both the URL and Description into a single URL which now doesn&amp;#39;t&amp;nbsp;have the correct address.&amp;nbsp; Is there something I&amp;#39;m overlooking when Retrieving the List data from&amp;nbsp;my Sharepoint list or is this something I&amp;#39;m stuck with in the absence of custom code?&amp;nbsp;Here&amp;#39;s an Example:&lt;/p&gt;
&lt;p&gt;&amp;nbsp;SharePoint Item in a &amp;quot;Links&amp;quot; list:&lt;/p&gt;
&lt;p&gt;URL: http://www.anysite.com, Description: An interesting site showing nothing important&lt;/p&gt;
&lt;p&gt;InfoPath Display of above mentioned List Item: http://www.anysite.com,%20an%20interesting%20site%20showing%20nothing%20important/&lt;/p&gt;
&lt;p&gt;&amp;nbsp;This is real frustrating because now every time the user of the Form wants to view the link he must click on the hyperlink, get annoyed with the error message on the screen, then manually erase the appended URL extension of the &amp;quot;Correct&amp;quot; address before the hyperlink launches&amp;nbsp;correctly. What am I missing here? and how can I get this to work properly.&lt;/p&gt;</description></item></channel></rss>