Never encountered this before. I have a long directory text field with many forward slashes. Trying to split this up on the forward slash. Thought this was really straight forward, but QB isn't letting me save the field, states that the syntax is incorrect. Not sure what to do here...
Do I need to escape out the forward slash? Seems pretty inconvenient?
Part([Location-Path],2,"\")
------------------------------
Ursula
------------------------------
Question
Formula Text field and forward slashes
This topic has been closed for replies.
+22Try
Part([Location-Path],2,"\\")
The \ is an escape character, so you need two of them for every one that you really need.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Part([Location-Path],2,"\\")
The \ is an escape character, so you need two of them for every one that you really need.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.