Page tree

Versions Compared

Key

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

...

D trans
RawWrangletrue
p03Value'removesymbols_source'
Typestep
WrangleTextderive type:single value: REMOVESYMBOLS(source) as: 'removesymbols_source'
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02ValueREMOVESYMBOLS(source)
p03NameNew column name
SearchTermNew formula

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