Remove special characters around the string

[surajap123]

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

[tresesco · Accepted solution]

Try like:

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

[surajap123]

Thank  you so much