Generate hyperlink in Sharepoint

Question

I have to generate an hyperlink in sharepoint based on sql table like this:

+----+----------------------------+
| ID | path                       |
+----+----------------------------+
| 1  | file://test/9932323.pdf    |
+----+----------------------------+
| 2  | file://test/1653156423.pdf |
+----+----------------------------+

Actually there is this code to generate html link:

<a href="{$thisNode/@PATH}"><asp:Label runat="server" id="ff1{$ID}" text="{$thisNode/@PATH}" /></a>

I cannot modify SQL table (dinamically generated) but I have to substitute:

/test/ with /test.abc.local/

and

displayed text with filename only ("path" field substring after last '/')

How can I to that without creating new view or calculated fields?

I tried with:

<a href="{REPLACE($thisNode/@PATH),12,1,'.abc.local/')}"><asp:L ...

but with no success. (I'm really newbie in Sharepoint)

thanks

Dr. Sushi Dr. Sushi · Accepted Answer · 2017-07-26T09:08:56

I'm not going to remove the previous answer because it still valid and it is pretty handy if somebody comes across the same issue, so the RegEx() expression you will have something like this:

 /(file\:\/\/)/g

Using the expression above you can find the string you want, so the example below gives you all the LABELS on a page, and from there you can use the following:

.replace( new RegExp("/(file\:\/\/test)","gm"),"/test.abc.local")

Using the expression above you can find the string you want, so the example below gives you all the LABELS on a page, and from there you can use the following:

$('input[type=text]').each(
    function(index)
    {  
       console.log(' text: ' + $(this).val() +  ' replace: ' +  $(this).val().replace( new RegExp("(file\:\/\/test)","gm"),"/test.abc.local") );
    }
);

Generate hyperlink in Sharepoint

2 Answers