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("\",&nbsp; Part([MacPath],&nbsp; 3, "/"),&nbsp; Part([MacPath],&nbsp; 4, "/"),&nbsp; Part([MacPath],&nbsp; 5, "/"),&nbsp; Part([MacPath],&nbsp; 6, "/"),&nbsp; Part([MacPath],&nbsp; 7, "/"),&nbsp; Part([MacPath],&nbsp; 8, "/"),&nbsp; Part([MacPath],&nbsp; 9, "/"),&nbsp; Part([MacPath], 10, "/"),&nbsp; Part([MacPath], 11, "/"),&nbsp; Part([MacPath], 12, "/"))

Forum Discussion

I need a formula to change a / to \

Related Content

Changing/setting record owner

Historical Date Change Tracking

Delete Formula Button Error

Auto change record to 'Expired' when copied.

Formula Assistance