#9628

Stefan
Participant

RAM wrote:
taking a column of dates (100,000s rows) like:
20110905

and separating the Y M and D using tabs, to result in:
2011 09 05

Or use an RegEx search&replace like


Find: (d{4})(d{2})(d{2})
Replace with: $1t$2t$3
[X] Use Regular Expressions

BTW: that way you can even reorder the YMD sequence.