Survey banner
The Dataiku Community is moving to a new home! We are temporary in read only mode: LEARN MORE

"IF contains" on file path

Solved!
yesitsmeoffical
Level 3
"IF contains" on file path
  • 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

0 Kudos
1 Solution
Turribeach

In Java the \ is a special character so you have to escape it.

Screenshot 2024-05-22 at 20.25.36.png

View solution in original post

1 Reply
Turribeach

In Java the \ is a special character so you have to escape it.

Screenshot 2024-05-22 at 20.25.36.png