topic Re: Process emails correctly for surname.name in Qlik Automate

Process emails correctly for surname.name

Alihan_02 — Fri, 04 Oct 2024 07:46:06 GMT

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.

Re: Process emails correctly for surname.name

MatheusC — Fri, 04 Oct 2024 17:54:59 GMT

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

You can try the solution below:

Result:

- Regards, Matheus

Re: Process emails correctly for surname.name

Alihan_02 — Wed, 09 Oct 2024 09:57:40 GMT

Hi Matheus,

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

Kind regards, Alihan