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

...

Column reference example:

D code

derive type:single value:REMOVESYMBOLS(MyName)

Output:

...

Returns the value

...

in the MyName column value with all non-alphanumeric characters removed. 

String literal example:

D code

derive type:single value:REMOVESYMBOLS('Héllõ, Wõrlds!?!?')

...

Output: Returns the string: Héllõ Wõrlds

...

.

Wildcard example:

D code

set col:* value:REMOVESYMBOLS($col)

Output: Strips all non-alphanumeric or space characters from all columns in the dataset.

D s
snippetSyntax

D code

derive type:single value:REMOVESYMBOLS(column_string)


ArgumentRequired?Data TypeDescription
column_stringYstringName of the column or string literal to be applied to the function

...