Trim whitespace on email address fields when ingesting data

Hi team

I have a rule that’s failing to ingest data because one of the email addresses in the source CSV file is formatted as “name@example.com “ with a trailing whitespace rather than “name@example.com”.

In an ideal world, all of our source data would be perfectly clean, but that’s not realistic for us and probably isn’t for many other people.

It would be great if Rules Engine could trim whitespace around email addresses before ingesting them to avoid errors like this

I found a request for a similar thing in JO too but this is specifically for Rules Engine ingest:

Thanks

Jon