Create a workflow, trigger it with a keyword that requires an argument, connect it to run a script, choose Ruby as the script language, and paste this in:
path = "{query}"
unc = ""
if (path.start_with?('smb:'))
# smb://NetworkDrive.corp.YYYY.com/Files/Folder/Folder
parts = path.split('//') # ["smb:", "NetworkDrive.corp.YYYY.com/Files/Folder/Folder"]
path_parts = parts[1].split('/') # ["NetworkDrive.corp.YYYY.com", "Files", "Folder", "Folder"]
server_parts = path_parts[0].split('.') # ["NetworkDrive", "corp", "YYYY", "com"]
unc = "\\\\#{server_parts[0]}\\#{path_parts[1..-1].join('\\')}"
else
# afp://NetworkDrive/Folder/Folder/
parts = path.split('//') # ["afp:", "NetworkDrive/Folder/Folder"]
path_parts = parts[1].split('/') # ["NetworkDrive", "Files", "Folder", "Folder"]
unc = "\\\\#{path_parts.join('\\')}"
end
puts unc
Then connect a copy to clipboard output (or large type or whatever else you like) to the script.