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 \

1 Reply

Related Content

Formula URL - Edit then Add

Create a formula duration over 5 years

Pipeline trigger(s) based on formula field changes

Looking for State abbreviation to full spelling formula

Changed To / Changed From

Recent Discussions

Summary Table Question

Google Search is back

Can I use quickbase actions within the same table?

Looking for Consultant: Add time tracking to existing task management app.

Share your feedback on the new Qrew Discussions