Icon

Different date formats in one column

Node 1Add a sortingcolumnKeeping only thesys_updated_oncolumnSeparate thedate formatsSplit byslashSplit byspaceSplit bycolonjoin the splitvalues backtogetherTidy upFor dash format,just keep as isNode 11Sort back inoriginal orderRemovesortcolumnNode 14CSV Reader Counter Generation Column Filter Row Splitter Cell Splitter Cell Splitter Cell Splitter String Manipulation Column Filter Rule Engine Concatenate Sorter Column Filter String to Date&Time Node 1Add a sortingcolumnKeeping only thesys_updated_oncolumnSeparate thedate formatsSplit byslashSplit byspaceSplit bycolonjoin the splitvalues backtogetherTidy upFor dash format,just keep as isNode 11Sort back inoriginal orderRemovesortcolumnNode 14CSV Reader Counter Generation Column Filter Row Splitter Cell Splitter Cell Splitter Cell Splitter String Manipulation Column Filter Rule Engine Concatenate Sorter Column Filter String to Date&Time

Nodes

Extensions

Links