Filter Catches some, but not all matches

[Paul_Danyliuk]

You don’t need relatively expensive Regex replacement/matching — your problem was extra spaces after the email. Using Trim() removes these. This works:

[Lead Assignment].Filter(Email.Trim()=thisRow.Email.Trim()).First()

Oh, and don’t forget to .First() your filter result, otherwise you’ll get a list-of-one instead of just one item, which will result in issues down the road. That’s another mistake everyone makes. See here:

Here’s a riddle for the community

I have a table that’s a list of tasks for clients. Grouped by client. How come that I got two groups for the same client? [image] And no, those aren’t two different rows — it’s the same client. Hint: some tasks were entered manually with client being selected from a drop-down list. And the other tasks were created with a button, copying the value from the “Current client” field in a supporting table. (I know the answer. I just wonder if you can figure what went wrong. There’s a lesson in he…