Discussions

Expand all | Collapse all

I need a formula to change a / to \

  • 1.  I need a formula to change a / to \

    Posted 08-15-2018 15:57
    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







  • 2.  RE: I need a formula to change a / to \

    Posted 08-16-2018 07:54
    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, "/")
    )