Trim problem

[enriquem]

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.

[enriquem · Accepted solution]

Hi everyone,

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

[Anonymous]

Hi my friend,

Indeed chr(160) is the "space character"

Good work champion!!

[#4]

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.