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
Excerpt

This example shows how to use

...

parsing functions for evaluating input values against the function-specific data type.

Functions:

...

D generate list excerpts
pagesPARSEBOOL Function,PARSEDATE Function,PARSEFLOAT Function,PARSEINT Function

Source:

The following table contains data on a series of races. 

...

Tip

Tip: For the PARSEDATE function, it's useful to use the Preview to verify that all of the dates in the column are represented in the array of output formats. You can see the available output formats through the data type menu at the top of a column . See Choose Datetime Format Dialogin the Transformer Page.

D trans
RawWrangletrue
Typestep
WrangleTextset col: date value: PARSEDATE($col, ['yyyy-MM-dd','yyyy\/MM\/dd','M\/d\/yyy hh:mm','MMMM d, yyyy','MMM d, yyyy'])
p01NameColumns
p01Valuedate
p02NameFormula
p02ValuePARSEDATE($col, ['yyyy-MM-dd','yyyy\/MM\/dd','M\/d\/yyy hh:mm','MMMM d, yyyy','MMM d, yyyy'])
SearchTermEdit column with formula

...

  • All values are written in the standardized format: yyyy-MM-dd HH:mm:ss. Time data has been stripped.

D s also
labelexample_type_parsing_functions