Discussions

Expand all | Collapse all

Find and replace formula syntax

  • 1.  Find and replace formula syntax

    Posted 03-22-2019 18:32
    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?




  • 2.  RE: Find and replace formula syntax

    Posted 03-22-2019 22:51
    Here is an exemple with 7 Search and Replaces in one formula.

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