source expression issue

I’m encountering an issue with the "Edit Source Expression" for the "Account" dimension mapping in PBCS.

Issue:

I want to set up an expression so that if the sixth column in a tab-delimited file corresponds to "Account" and contains "HRS," the record should be skipped or ignored.

I’m not sure how to implement the correct logic.

if (ACCOUNT == "HRS") return ?

ALTERNATE APPROACH

I also have an example from the documentation that demonstrates using RECORD. For instance, if the input file looks like this:

account,entity,icp,100

And the sample expression is:

if (split(RECORD, ",", 3) == "icp") return "icp 2022"

The resulting source value would be set to