topic Remove/Replace characters after the string in QlikView

Remove/Replace characters after the string

bhaveshp90 — Sat, 16 Nov 2024 21:17:07 GMT

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

marcus_malinow — Thu, 07 Mar 2019 16:20:49 GMT

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

sergio0592 — Thu, 07 Mar 2019 16:22:53 GMT

try

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

Bionic — Fri, 20 May 2022 01:51:28 GMT

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.