I'm creating a hyperlink in a Workflow token that will take an end user to a folder in the WebLink repository.
The folder path contains a "Company Name" variable that may or may not contain an apostrophe.
If the "Company Name" variable does not contain an apostrophe, the hyperlink works without issue.
If there is an apostrophe in the "Company Name", the hyperlink cuts off just before the apostrophe and errors out.
How do I encode an apostrophe in a variable that is used in a WebLink repository hyperlink?
FOLDER PATH
myrepositoryname\Development Services\11 DS Administration\06 Pre-Development Meeting Requests\2019\JOHN DOE'S COMPANY - JOHN DOE - 619
HYPERLINK TOKEN SETUP my favorite URL Encoder / Decoder website
%3Ca+href%3D%22http%3A%2F%2Fax1dis01%2FWebLink%2FSearch.aspx%3Fdbid%3D0%26searchcommand%3D%7BLF%3ALOOKIN%3D%26quot%3Bmyrepositoryname%5CDevelopment+Services%5C11+DS+Administration%5C06+Pre-Development+Meeting+Requests%5C%(Year)%5C%(EscapedCompany#@EncodeURL@#)%20-%20%(RetrieveBusinessProcessVariablesfromMeetingRequestForm_Applicant_Name#@EncodeURL@#)%20-%20%(BP Instance ID)%26quot%3B%7D%22%3EMEETING%20FILE%3C%2Fa%3E
TRACKED WORKFLOW TOKEN
%3Ca+href%3D%22http%3A%2F%2Fax1dis01%2FWebLink%2FSearch.aspx%3Fdbid%3D0%26searchcommand%3D%7BLF%3ALOOKIN%3D%26quot%3Bmyrepositoryname%5CDevelopment+Services%5C11+DS+Administration%5C06+Pre-Development+Meeting+Requests%5C2019%5CJOHN%2520DOE'S%2520COMPANY%20-%20JOHN%20DOE%20-%20620%26quot%3B%7D%22%3EMEETING%20FILE%3C%2Fa%3E
RENDERED HYPERLINK CUTS OFF AT APOSTROPHE IN "DOE'S"
ALL THE WAYS I AM CURRENTLY TRYING TO ENCODE THIS APOSTROPHE
- Custom script activity to force escaping suggested in this fabulous post (working for everything except apostrophes)
- "EncodeURL" function applied to the "Company Name" variable in the Token Editor (does not encode apostrophes)
I appreciate your help! Thanks so much!