...
| Excerpt |
|---|
This example demonstrates functions that can be used to clean up strings. |
...
Functions:
...
| D generate list excerpts |
|---|
| pages | TRIM Function,REMOVEWHITESPACE Function,REMOVESYMBOLS Function |
|---|
|
Source:
In the following (space) and (tab) indicate space keys and tabs, respectively. Carriage return and newline characters are also supported by whitespace functions.
...
| D trans |
|---|
| RawWrangle | true |
|---|
| p03Value | 'removesymbols_source' |
|---|
| Type | step |
|---|
| WrangleText | derive type:single value: REMOVESYMBOLS(source) as: 'removesymbols_source' |
|---|
| p01Name | Formula type |
|---|
| p01Value | Single row formula |
|---|
| p02Name | Formula |
|---|
| p02Value | REMOVESYMBOLS(source) |
|---|
| p03Name | New column name |
|---|
| SearchTerm | New formula |
|---|
|
Results:
| Strings | source | removesymbols_source | removewhitespace_source | trim_source |
|---|
| String01 | this source(space)(space) | this source(space)(space) | thissource | this source |
| String02 | (tab)(tab)this source | (tab)(tab)this source | thissource | this source |
| String03 | (tab)(tab)this source(space)(space) | (tab)(tab)this source(space)(space) | thissource | this source |
| String04 | this source's? | this sources | thissource's? | this source's? |
| String05 | "Why, you @#$%^&*()!" | Why you | Why,you@#$%^&*()! | Why, you @#$%^&*()! |
| String06 | this |
söurce surcethissöurce söurce| söurce |
| String07 | (space)this |
söurce surcethissöurce söurce| söurce |
| String08 | à mañana | à mañana | àmañana | à mañana |
maana | à ma ñana | à ma ñana| D s also |
|---|
| label | example_string_cleanup_functions |
|---|
|
