Find and replace formula syntax

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • In Progress
I have this search and replace to accommodate  file paths for Mac users and PC users, which basically changes the forward slash to a back slash in the url.

SearchAndReplace([File Path Mac], "/",'"\\")

I also want to replace the prefix, is it possible to have two Search and Replaces in one formula?


Photo of Johnny DeVilla

Johnny DeVilla

  • 72 Points

Posted 2 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,448 Points 50k badge 2x thumb
Here is an exemple with 7 Search and Replaces in one formula.

https://community.quickbase.com/quick...