topic Remove special characters around the string in QlikView

Remove special characters around the string

surajap123 — Tue, 29 Jun 2021 09:42:39 GMT

Hi There,

I wanted to remove $ character in the below string. The $ character within the string represent space.
When I use purgechar() function it is removing $ across the string which is good, but I want to keep the space within the string.

$London$city$

Table:
LOAD * INLINE [
purgechar(field,'$') as field
];

eg-
from-
$London$city$

to-
London city

Please help

Re: Remove special characters around the string

tresB — Tue, 29 Jun 2021 09:51:07 GMT

Try like:

Trim(replace(field '$', ' ')) as Field

Re: Remove special characters around the string

surajap123 — Tue, 29 Jun 2021 10:26:09 GMT

Thank you so much