Cleaning Function

M.Lambert

Hi there, does anyone know a function to clean whitespaces but leave one space between names? The equivalent of TRIM in excel.

Thanks 😉

Josh Boxer

Hello

There are two functions likely useful:

• Trim - remove character from either start or end of value (use twice for both start and end)
• Compact Spaces - replace mulitple spaces with a single space

https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/get-started/create-functions/#text-transform~native-functions

param test;

Trim(

Trim(

CompactSpaces([p:test]),

false,

`Space`

),

true,

`Space`

)

M.Lambert

Hi Josh, I will try that one. Thanks a lot