"IF contains" on file path

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.