Icon

extract dates and durations

There has been no description set for this workflow's metadata.

Sample datapatternspatterns are processed from top to bottom and it attempts to find them in the orderleft to right in the input dataNode 20Node 21get top most patternremainder gets used onnext recursionget regex patternas variablelook forpatternrename ascollected andtextrename the columnbeing translated to "text"removeold text columncollected goes to "collection"and text goes to recursion portif not foundretain full textfor next timeNode 37Node 38Node 39original rowidjoin back to originaltexttidy uptidy upmake collectedcolumn a String datatypemagic datehandlermerge date back to "collected"column if foundmerge "from dates"merge "to dates"Excel Reader Table Creator Recursive Loop End RecursiveLoop Start Row Splitter Table Rowto Variable Regex Split Column Rename Column Rename Column Filter Column Splitter Rule Engine Counter Generation Joiner Pivoting RowID Joiner RowID Column Resorter String Manipulation FlexibleDate Reader Column Merger Column Merger Column Merger Sample datapatternspatterns are processed from top to bottom and it attempts to find them in the orderleft to right in the input dataNode 20Node 21get top most patternremainder gets used onnext recursionget regex patternas variablelook forpatternrename ascollected andtextrename the columnbeing translated to "text"removeold text columncollected goes to "collection"and text goes to recursion portif not foundretain full textfor next timeNode 37Node 38Node 39original rowidjoin back to originaltexttidy uptidy upmake collectedcolumn a String datatypemagic datehandlermerge date back to "collected"column if foundmerge "from dates"merge "to dates"Excel Reader Table Creator Recursive Loop End RecursiveLoop Start Row Splitter Table Rowto Variable Regex Split Column Rename Column Rename Column Filter Column Splitter Rule Engine Counter Generation Joiner Pivoting RowID Joiner RowID Column Resorter String Manipulation FlexibleDate Reader Column Merger Column Merger Column Merger

Nodes

Extensions

Links