Process emails correctly for surname.name

[Alihan_02]

Hi guys,

I have connected to Outlook and there is a dimension called: =[EventsForCalendar.attendees]. this shows the attendees with their emails. The structure in this dataset is like this: surname.name@outllok.com,surname.name@outllok.com, surname.name@outllok.com. My colleague wants the emails to be processed like this: last_name.name, last_name.name, last_name.name. I have tried this: =SubField(SubField([EventsForCalendar.attendees], ',', 1), '@', 1), but then the other names in the line are not displayed anymore and it always varies and turns out to be more complicated than expected, if anyone has any ideas, I would be very grateful.

[MatheusC]

Do you want to extract the names, keeping the values ​​on the same line?

You can try the solution below:

Result:

- Regards, Matheus

[Alihan_02]

Hi Matheus,

Unfortunately that didn't help me, but thank you for your efforts.

Kind regards, Alihan