"IF contains" on file path

yesitsmeoffical
yesitsmeoffical Registered Posts: 15
  • File_Path: \USER\FOLDER_A\ABC\FILE_A
  • Formula: if(contains(toUppercase(File_Path),"\ABC\"), "yes", "no")
  • This returns "Invalid Formula" message: Unexpected 'yes' (Paring error at offset )

I tested the formula using "ABC" instead "\ABC\" and it works as intended, however for my project retaining the slash symbols around "ABC" is a must, what will be a workaround? TIA!


Operating system used: win 11

Best Answer

Setup Info
    Tags
      Help me…