topic Re: Trim problem in QlikView

Trim problem

enriquem — Tue, 04 Oct 2016 09:25:08 GMT

Hi everyone!

I want to get the "Comunidad Autónoma" without the space caracter from the ddbb to get the correct result. But the problem that i found is that the Trim function don't work or i don't know how works.

Hear i put one peace of my code whit the Trim function:

LOAD

AutoNumber(Trim([Comunidad Autonoma])) AS LINK_AUTONOMIA,

Trim(Provincia) AS Provincia,

...

Thank's you.

Re: Trim problem

enriquem — Tue, 04 Oct 2016 09:35:30 GMT

Hi everyone,

Finally i discover that the character was an "nbsp" character, and i resolve it with replace(Provincia,chr('160'),'')

Re: Trim problem

Anonymous — Fri, 04 Nov 2016 11:35:23 GMT

Hi my friend,

Indeed chr(160) is the "space character"

Good work champion!!

Re: Trim problem

Fri, 04 Nov 2016 11:37:28 GMT

Hi Enrique,

Thanks for shared it. It is very interesting.

Another option can be to use the Subfied() function: str SubField (text,delimiter [, field_no]). In your case, you can put the delimiter as " " and paste the two strings into a one.

Regards.