I need a formula to change a / to \

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • In Progress
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/_XXXXXXXXX/2018/_XXXXXXXXX/08-Aug/XXXXXXXXX/Promo/XXXXXXXXX

Can someone help with a formula that would change the above to

WLVISILONCIFS\XXXXXXXXX\_XXXXXXXXX\2018\_XXXXXXXXX\08-Aug\XXXXXXXXX\Promo\XXXXXXXXX





Photo of Johnny DeVilla

Johnny DeVilla

  • 142 Points 100 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,322 Points 20k badge 2x thumb
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, "/")
)