Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Lucky1
Creator
Creator

Remove & in field value

Hi

I have a field 

Name

& Lucky

& Sagar

I want to remove '& ' and i want output like

Name

Lucky

Sagar

How to do that

 

 

 

 

Labels (3)
1 Solution

Accepted Solutions
Lucky1
Creator
Creator
Author

I found solution

Trim(mid(Name,Index(Name,'& ') + 1)) as Name

View solution in original post

4 Replies
MarcoWedel

LOAD 

Replace(Name,'& ','') as Name

...

 

Lucky1
Creator
Creator
Author

I found solution

Trim(mid(Name,Index(Name,'& ') + 1)) as Name

MarcoWedel

In case your Names always start with '& ', you could just use

Mid(Name,3) as Name

as well

Lucky1
Creator
Creator
Author

Only some names start with '& '