Calculated Column Issue with Special character [‘]

Recently one of my good friend was working with Calculated Column
He wanted to perform few actions based on this column. The formula for calculated column is as below which he entered:

=CONCATENATE(“<a target='_blank' href=‘”,”http://mysharepointserver:1234/Pages/Sample.aspx?RootFolder=&#8221;,Title,“‘>”,Title,”“)

Issue:
When Title=Test’s (with special character – Apostrophe).
URL returns like :
http://mysharepointserver:1234/Pages/Sample.aspx?RootFolder=Test (actual value for Title was “Test’s”)

URL should returns like :
http://mysharepointserver:1234/Pages/Sample.aspx?RootFolder=Test’s

It was a silly mistake only. The correct formula is :
=CONCATENATE(“<a target='_blank' href=“””,”http://myserver:1234/Pages/Photo%20Gallery.aspx?RootFolder=&#8221;,Title,“””>”,Title,”“)

See below snap :
https://mysharepointsolution.files.wordpress.com/2012/03/calculatedcolumn1.jpg

Hope this will help others also!!!

3 comments

Leave a Reply to zee Cancel reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s