Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try like:
Trim(replace(field '$', ' ')) as Field
Thank you so much