Hyperlink broken in Sharepoint calculated column

Question

Hi All,

I have created one calculated column name "Album Details page Link" like :

=CONCATENATE("<a target='_blank' href='","",Title,"http://servername:42153/Pages/Photo%20Gallery.aspx?RootFolder=",Title,"'>",Title,"</a>")

I have appended the "Title" column after link. but when my title is like : "Test's Title" then i will get the result link like below :

http://servername:42153/Pages/Photo%20Gallery.aspx?RootFolder=Test that means the link is broken after Apostrophe.

Any Idea ??

Thanks in advance to all.

Regards,
Chandresh

Answer 1

It's correct. I suppose you should use something

=CONCATENATE("<a target='_blank' href='","",Title,"http://servername:42153/Pages/Photo%20Gallery.aspx?RootFolder=",replace(B1,SEARCH("'", B1),1,"%27"),Title),"'>",Title,"</a>")

It means that yous should relace quote to url code of that symbol. Otherwise you href attr end on qoute.

Answer 2

Hi ,

Thanks for your reply.

What is the "B1" in that link ? i have tried this to put in calculated column but it is noe working..

Thanks,

Chandresh

Answer 3

oh, pardon.

I tested this in Excel. Formulas in Excel and in SharePoint are equal).

Try to put Title against B1.