sheetimj: -------------------------------------------------------------------------------- Apologies if this is already covered, I searched but failed to find.
I have numbers in this format 000000 000005 000010 . date change 235955 000000 e.g. time in hhmmss format incrementing by 5 secnds in one column of data amongst many. I need t change this to 00:00:00 00:00:05 00:00:10 e.g. time in hh:mm:ss format. I know there are tools to do this outside of PSPAD, are there any ways to do it inside PSPAD? Thanks in advance if you can help -------------------------------------------------------------------------------- If this is at the beginning of the lines and no other line starts with (at least) six digits, you can use regular expressions: Just replace: ^(\d\d)(\d\d)(\d\d) with $1:$2:$3 with [x] regular expression checked. hth, vbr -- <http://forum.pspad.com/read.php?2,57534,57536> PSPad freeware editor http://www.pspad.com
