Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The following transforms generate new columns using each of the string cleanup functions:

D code

derive type:single value: TRIM(source) as: 'trim_source'


D code

derive type:single value: REMOVEWHITESPACE(source) as: 'removewhitespace_source'


D code

derive type:single value: REMOVESYMBOLS(source) as: 'removesymbols_source'

 Results:

Stringssourceremovesymbols_sourceremovewhitespace_sourcetrim_source
String01this source(space)(space)  this source(space)(space)  thissourcethis source
String02(tab)(tab)this source(tab)(tab)this sourcethissourcethis source
String03(tab)(tab)this source(space)(space)(tab)(tab)this source(space)(space)thissourcethis source
String04this source's?this sourcesthissource's?this source's?
String05"Why, you @#$%^&*()!"Why you Why,you@#$%^&*()!Why, you @#$%^&*()!
String06this
söurce
söurcethis
surce
söurce
thissöurce
thissöurcethis
söurce
söurce
String07(space)this
söurce
söurce(space)this
surce
söurce
thissöurce
thissöurcethis
söurce
söurce
String08à mañana
 maanaà ma ñanaà  ma ñana
à mañanaàmañanaà  mañana