Remove unwanted characters in Data Manager build

[SynexusStuart]

Hi all,

I have a column in a table with large amount sof messy string data. We often find that it contains many unwanted characters such as % ^
$ " { } etc.

Is there an in-built way of using Data Manager to replace any of the above characters in that column?

Hope there is.
Stuart

[S2000]

You could try making a funtion that strips them all out.
Take a look at the "replace" command.

It's common to create a custom user defined funtion that will trim leading and trailing spaces and replace those sorts of chars with spaces.
Then you can use the custom 'clean' function on any fields that need it.