September 7, 2011 at 6:43 am #9628
taking a column of dates (100,000s rows) like:
and separating the Y M and D using tabs, to result in:
2011 09 05
Or use an RegEx search&replace like
Replace with: $1t$2t$3
[X] Use Regular Expressions
BTW: that way you can even reorder the YMD sequence.