Extract name from email address

[anuraag_msg]

Hi guys,
I need help extracting name from email address in Blue Prism.
input: xyz.abc@gmail.com
output: xyz<space>abc

Please suggest a solution

 

[anuraag_msg]

1. First fetch the name, anything works, for testing just store in a data item or via looping through a collection of data.
Data Item : Email, contain the entire email. example: xyz.abc@gmail.com

2. To remove the mail domain:
Use a calculation stage to manipulate the text data.
Implement the formula :
Trim(Upper((Mid(,1, InStr([Email], "@")-1)))) --> saved inside a new data item : Name

3. Use another calculation stage.
To remove the dot between the name and split the vorname and nachname:
Implement the formula :
Replace([Name], ".", " ")