Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi everyone,
Finally i discover that the character was an "nbsp" character, and i resolve it with replace(Provincia,chr('160'),'')
Hi everyone,
Finally i discover that the character was an "nbsp" character, and i resolve it with replace(Provincia,chr('160'),'')
Hi my friend,
Indeed chr(160) is the "space character"
Good work champion!!
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.