8 Replies Latest reply on May 6, 2013 5:36 AM by miketurton

    Need help to handle filename space in weblink

    miketurton

      Hi there,

       

      This seems like such a simple thing but I can not get it right.

       

      I am concatenating fields to place links to hosted files into an email body. I pick up a Label and link if the link is not empty using the following line example:

       

      If(not IsEmpty(clients_CHURCH::PR email Link 2);clients_CHURCH::PR email Link 2 Label&" www.domain.com/PR/"&clients_CHURCH::PR email Link 2&"¶¶";"")

       

       

      The field 'clients_CHURCH::PR email Link 2' contains the filename of the file and I have to tolerate a space.

       

      I get this:

      Endorsement 1: www.domain.com/PR/Endorsement 1.jpg

       

       

      My attempts to add quotations around the filename have not produced the result. I get things like:

       

      If(not IsEmpty(clients_CHURCH::PR email Link 2);clients_CHURCH::PR email Link 2 Label&" www.domain.com/PR/"&"""&clients_CHURCH::PR email Link 2&"""&"¶¶";"")

       

      gives me this:

       

       

      Endorsement 1: www.domain.com/PR/"Endorsement 1.jpg"

       

       

      I would appreciate some help. I have searched the KB but cant seem to get it right.

       

      Thanks in advance

      Mike