Forum Discussion

UrsulaLlaveria's avatar
UrsulaLlaveria
Qrew Assistant Captain
5 years ago

Formula Text field and forward slashes

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
------------------------------
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    Try
    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
    ------------------------------
    • UrsulaLlaveria's avatar
      UrsulaLlaveria
      Qrew Assistant Captain
      5 years ago
      Thanks Mark!!! I thought since this was a text field, it wouldn't identify it as a special character, but as the character itself. Much appreciated!

      ------------------------------
      Ursula
      ------------------------------