I need a formula to change a / to \

Question

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

anomDiebolt · Answer

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, "/"))

Sign up

Login to the community