Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a field
Name
& Lucky
& Sagar
I want to remove '& ' and i want output like
Name
Lucky
Sagar
How to do that
LOAD
Replace(Name,'& ','') as Name
...
I found solution
Trim(mid(Name,Index(Name,'& ') + 1)) as Name
In case your Names always start with '& ', you could just use
Mid(Name,3) as Name
as well
Only some names start with '& '