Data change

[New-here1]

Hello, 

I have a field titled Name but the data in the field is all email addresses. Is there a way to change the email address to just the name so:

john smith at email address to show as John Smith,

jane doe at email address to show  to Jane Doe

ect

(for some reason it won’t let me put a dot between the names or an at sign for the email address)

is this possible please? And if so, how can I do this in the backend? 

thank you

[Lisa_P · Accepted solution]

I'm a little confused about the direction you are trying to go, is it from email address to name or vice versa ?

I will assume it is the first.

My assumption is that the email address example is john.smith@xyz.com

In the load script in the table you are loading this email address, the script would look something like this:

Load   Capitalize(Subfield(Name, '.', 1) & ' '&TextBetween(Name, '.', '@')) as NewName,

to do the reverse you would use:

Load  Subfield(Name, ' ', 1) & '.' & Subfield(Name, ' ', 2) & '@xyz.com' as Email,

[sidhiq91]

@New-here1  You can use the below code in your script Editor:

NoConcatenate
Temp:
Load Emailaddress,
Capitalize(SubField(Emailaddress,' ',1))&'.'&Capitalize(SubField(Emailaddress,' ',2))&'@abc.com' as New_Name

inline [
Emailaddress
john smith
jane doe
];

Exit Script;

If this resolves your issue, please like and accept it as a solution.

[New-here1]

This worked, thank you 🙂