topic Re: Can't load content containing ampersands ("&") in QlikView

Can't load content containing ampersands ("&")

Mon, 24 Jun 2013 14:40:05 GMT

I am trying to load customer names that contain ampersands ("&" symbol) and possibly other special characters. I've found that when loading customer names that contain an ampersand, all text before the "&" symbol (and the symbol itself) is not loaded.

To resolve this, I've tried using the TEXT() function, but this doesn't work. I don't want to replace the symbol with text, e.g. "and".

If anyone can help me I'd very much appreciate it!

Re: Can't load content containing ampersands ("&")

Anonymous — Mon, 24 Jun 2013 14:47:52 GMT

Use "replace" twice, e.g. from '&" to 'and' on reload, and than back to '&'

Re: Can't load content containing ampersands ("&")

Mon, 24 Jun 2013 14:52:24 GMT

Wow, that's quick! Thanks

Followup question: if I do this, won't I also be replacing existing "and" in the names of other customers?

I wouldn't want the situation to arise where "Customer A & Co." and "Customer A and Co." would be 'merged' into a single "Customer A & Co."...

Re: Can't load content containing ampersands ("&")

Mon, 24 Jun 2013 15:16:50 GMT

Use some unique string like REPLACE(name, '&', 'zzzANDzzz') and then replace it back.

Re: Can't load content containing ampersands ("&")

Anonymous — Mon, 24 Jun 2013 15:16:54 GMT

You're right. I just was using your example. In reality, you better use something less likely, e.g. "Mickey Mouse"

Re: Can't load content containing ampersands ("&")

Tue, 25 Jun 2013 07:24:03 GMT

Thanks both; works like a charm

In the end I had to perform the first replace in my (MS Access) staging script as Replace(Name,Chr(38), 'zzzANDzzz'), then run the next one in my QV load script Replace(Name, 'zzzANDzzz',Chr(38))

Re: Can't load content containing ampersands ("&")

vijetas42 — Tue, 18 Sep 2018 15:00:02 GMT

I am facing same issue for date like, Kirl & Elle and it's loading only Elle. can you help me on this. I have tried replace but not working.