Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

...

Stringssource
String01this source(space)(space)
String02(tab)(tab)this source
String03(tab)(tab)this source(space)(space)
String04this source's?
String05Why, you @#$%^&*()!
String06this söurce
String07(space)this söurce
String08à mañana

TransformTransformation:

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

d-

...

trans
RawWrangletrue
p03Value'trim_source'
Typestep
WrangleTextderive type:single value: TRIM(source) as: 'trim_source'
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02ValueTRIM(source)

...

p03NameNew column name
SearchTermNew formula

D trans
RawWrangletrue
p03Value'removewhitespace_source'
Typestep
WrangleTextderive type:single value: REMOVEWHITESPACE(source) as: 'removewhitespace_source'
p01NameFormula type
p01Value

...

Single row formula
p02NameFormula
p02ValueREMOVEWHITESPACE(source)
p03NameNew column name
SearchTermNew formula

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?
String05Why, you @#$%^&*()!Why you Why,you@#$%^&*()!Why, you @#$%^&*()!
String06this söurcethis surcethissöurcethis söurce
String07(space)this söurce(space)this surcethissöurcethis söurce
String08à mañana maanaà ma ñanaà  ma ñana