Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bhaveshp90
Creator III
Creator III

Remove/Replace characters after the string

Hello, 

I have a string like "Tim.Kimball@amazon.com". How to remove the string (email id) to show only First Name and Last Name.

"Tim.Kimball@amazon.com" into "Tim Kimball" (removing the string from @ and replacing the period with a space character)

 

thanks

Labels (4)
2 Solutions

Accepted Solutions
marcus_malinow
Partner - Specialist III
Partner - Specialist III

replace(subfield('Tim.Kimball@amazon.com', '@', 1), '.', ' ')

View solution in original post

sergio0592
Specialist III
Specialist III

try

=subfield('Tim.Kimball@amazon.com','@',1)

View solution in original post

3 Replies
marcus_malinow
Partner - Specialist III
Partner - Specialist III

replace(subfield('Tim.Kimball@amazon.com', '@', 1), '.', ' ')

sergio0592
Specialist III
Specialist III

try

=subfield('Tim.Kimball@amazon.com','@',1)
Bionic
Contributor
Contributor

Hi, What if I need to keep rest text after the email e.g.

Orpigina Text : My Email is Tim.Kimball@amazon.com. Please Contact.

Desire Replace Text: My Email is Tim.Kimball****. Please Contact.