I have an index which has documents of all the commits of my repo.
There is a field in the document which has different format therefore while aggregating on that field yields different result.
The field name is Author.
Different format example
Since they are both the same author with different format in the document field.
Is there any way I can only extract the email from this field and update this field. I have 1.5 Million documents having this field.