You might be saved by the new feature in staging, Split Text.
I tried it, and it does work.
So I added some space before the email in the Sheet here.
I added a split by a space character.
Then make a relation using that split column to a properly formatted email column.
It works.
I added an EmailBasicRel using the wrongly formatted column and there’s the difference.