Ignoring rows based on multiple conditions using OR statement

[azfersaeed]

Hi,

I am trying to remove "-0" from the end of URLs in a column BUT want to skip two rows. One contains the string "marketing-transit-map-0" and the other contains "representative-use-cases-0".

IF !Contains([landingPagePath],"marketing-transit-map-0") OR
   !Contains([landingPagePath], "representative-use-cases-0")
THEN Trim([landingPagePath],"-0")
ELSE([landingPagePath])
ENDIF

For some reason, however, the "-0" is getting removed from both of these rows.

Reason I want to skip those specific rows is because "-0" in those two cases is not an error whereas in other URLs, it is an error.

Thanks for your help!

[Hugo · Accepted solution]

Hi Azfersaeed,

the reason it is getting removed is the that the string "marketing-transit-map-0" triggers the !Contains([landingPagePath], "representative-use-cases-0") clause. Since you have an OR statement, the first condition is true, so it is trimming the URL.

If you make the statement an AND statement it should work

[azfersaeed]

Thanks, it's always the little stuff!