miketurton

Need help to handle filename space in weblink

Discussion created by miketurton on May 2, 2013
Latest reply on May 6, 2013 by 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

 


Outcomes