Ask Your Question
0

Cannot have a reference in recursive expresion greater than 9 [closed]

asked 2012-05-29 18:50:00 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Hello,

I have been trying to parse the output of the lightning calendar using libre office calc. I have a cell with the following content:

20120522T130000 and I have to make it look like this 22-May-2012 13:00:00

so I used search and replace with recursive expressions selected and wrote Search: ([:digit:])([:digit:])([:digit:])([:digit:])([:digit:])([:digit:])([:digit:])([:digit:])T([:digit:])([:digit:])([:digit:])([:digit:])([:digit:])([:digit:]) Replace $1$2$3$4/$5$6/$7$8 $9$10:$11$12:$13$14

And I get 2012/05/22 120:20:2122:2324

so I try the obvious choices of grouping the 1? with parenthesis, braces and brakets but I get 2012/05/22 1$(10):$[11]${12}:$(13)$[14]

Is there any way to pass references higher than 9? (I would assume so)

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-16 04:48:04.944089

2 Answers

Sort by » oldest newest most voted
0

answered 2012-05-30 12:37:56 +0200

mahfiaz gravatar image

([:digit:]{4})([:digit:]{2})([:digit:]{2})([:alpha:])([:digit:]{2})([:digit:]{2})([:digit:]{2})

$1/$2/$3 $5:$6:$7

edit flag offensive delete link more
0

answered 2012-05-29 23:03:28 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Try with:

search: (....)(..)(..)T(..)(..)(..)

replace: $3/$2/$1 $4:$5:$6

edit flag offensive delete link more

Question Tools

Stats

Asked: 2012-05-29 18:50:00 +0200

Seen: 156 times

Last updated: May 30 '12