Creating a variable file path

[James Gill]

I am trying to create a variable that contains a file path that is based upon an employer name. The problem is that occasionally an employer name will contain a "/" in it and I cannot save records as a PDF as it results in an invalid file path. I'm trying to find a way to set my file path variable to account for this but I haven't been able to wrap my head around using the substitute command to do this. I'm able to successfully change the "/" to a "-" but I can't get the calculation to retain the rest of my employer name, just to parts that I replace.

So basically, I want this to take;

"Barts Beeswax/Honey" and change it to "Barts Beeswax-Honey" any time an employer name contains the "/" character.

[bruceR]

Set Variable [ $path; "file:" & get( deskTopPath) & substitute( YourField; "/"; "-") & ".pdf" ]

[James Gill]

Wow...*facepalm

I knew I missing something easy...

Thanks a lot.

Edited July 14, 2010 by Guest