Page 1 of 1

Problem storing network file path in Private Data

Posted: Fri Jun 13, 2025 5:02 pm
by wkopp
I'm using a database call to return a file path into a Private Data Key that I want to use in a Pitstop action. (I'm combining two pdf files)

Sample file path from SQL:
\\server01\server Attachments\Attachments\JOBS\58k\58654\TH58654_front end sheet 4pg_Code.pdf

Results when trying to call this Private Data Key:
\server01server AttachmentsAttachmentsJOBS8k8654TH58654_front end sheet 4pg_Code.pdf

I'm trying out possible workarounds but was wondering if there's a simple fix to getting Switch to see this as a path and not drop out the special "\" characters.

Re: Problem storing network file path in Private Data

Posted: Sat Jun 14, 2025 9:15 am
by jan_suhr
You have to escape the backslashes for Switch to see them as backslashes

\\\\server01\\server\\ and so on

Re: Problem storing network file path in Private Data

Posted: Sat Jun 14, 2025 4:22 pm
by wkopp
Thanks Jan. I'll try generating the link in SQL, then adding the extra character with a replace in SQL before returning the data.