Forum Discussion

JohnnyDeVilla1's avatar
JohnnyDeVilla1
Qrew Trainee
6 years ago

I need a formula to change a / to \

I have urls for various file paths for our assets that I would like to have an automatic way to feed another file path for pc users. Our Mac file paths look like this smb://WLVISILONCIFS/XXXXXXXXX/_X...
Tables and fields
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
6 years ago
Try this:

List("\",
  Part([MacPath],  3, "/"),
  Part([MacPath],  4, "/"),
  Part([MacPath],  5, "/"),
  Part([MacPath],  6, "/"),
  Part([MacPath],  7, "/"),
  Part([MacPath],  8, "/"),
  Part([MacPath],  9, "/"),
  Part([MacPath], 10, "/"),
  Part([MacPath], 11, "/"),
  Part([MacPath], 12, "/")
)