Worked perfectly thanks, uri, and same technique works perfectly in postgresql regexp_replace for info
On 29 June 2018 at 16:18, Mike Martin <redt...@gmail.com> wrote: > Thanks > > > On Fri, 29 Jun 2018, 15:48 Uri Guttman, <u...@stemsystems.com> wrote: > >> On 06/29/2018 10:41 AM, Mike Martin wrote: >> >> sorry >> yyyy-mm-dd hh:mm:ss.dddddd >> eg: >> 2018-01-01 12-45-10-456789 to >> 2018-01-01 12:45:10.456789 >> >> >> >> please reply to the list and not to me! >> >> then why did you want lookbehind? this is very easy if you just grab the >> time parts and reassemble them as you want. <untested> >> >> $stamp =~ s/\s(\d\d)-(\d\d)-(\d\d)-/ $1:$2:$3./ ; >> >> it uses the space to mark where the time part starts. >> >> uri >> >> >>
