title: Generate hyperlink in Sharepoint
body: <p>I have to generate an hyperlink in sharepoint based on sql table like this:</p>
  
  <pre><code>+----+----------------------------+
  | ID | path                       |
  +----+----------------------------+
  | 1  | file://test/9932323.pdf    |
  +----+----------------------------+
  | 2  | file://test/1653156423.pdf |
  +----+----------------------------+
  </code></pre>
  
  <p>Actually there is this code to generate html link:</p>
  
  <pre><code>&lt;a href="{$thisNode/@PATH}"&gt;&lt;asp:Label runat="server" id="ff1{$ID}" text="{$thisNode/@PATH}" /&gt;&lt;/a&gt;
  </code></pre>
  
  <p>I cannot modify SQL table (dinamically generated) but I have to substitute:</p>
  
  <pre><code>/test/ with /test.abc.local/
  </code></pre>
  
  <p>and </p>
  
  <p>displayed text with filename only ("path" field substring after last '/')</p>
  
  <p>How can I to that without creating new view or calculated fields?</p>
  
  <p>I tried with:</p>
  
  <pre><code>&lt;a href="{REPLACE($thisNode/@PATH),12,1,'.abc.local/')}"&gt;&lt;asp:L ...
  </code></pre>
  
  <p>but with no success. (I'm really newbie in Sharepoint)</p>
  
  <p>thanks</p>