[libreoffice-users] [3.5.1.2/Calc/XP] Regex to find/replace numbers?

2012-05-02 Thread Gilles
Hello I need to search and reformat toll-free numbers in a spreadsheet, but I can't find how to do this in Calc: (\d\d)(\d\d)(\d\d) ie. space + six digits in pairs. In the Find Replace dialog, even with the default Regular expression option checked and Search in=Values, this triggers Search

Re: [libreoffice-users] [3.5.1.2/Calc/XP] Regex to find/replace numbers?

2012-05-02 Thread Nino Novak
Hi, On Wednesday 02 May 2012, 04:18:20 Gilles wrote: I need to search and reformat toll-free numbers in a spreadsheet, but I can't find how to do this in Calc: Sorry, could you elaborate a bit, what you mean by toll-free numbers? Some examples? (\d\d)(\d\d)(\d\d) This regex will find

Re: [libreoffice-users] [3.5.1.2/Calc/XP] Regex to find/replace numbers?

2012-05-02 Thread Nino Novak
Am Mittwoch, 2. Mai 2012, 14:05:21 schrieb Nino Novak: Hi, On Wednesday 02 May 2012, 04:18:20 Gilles wrote: I need to search and reformat toll-free numbers in a spreadsheet, but I can't find how to do this in Calc: Sorry, could you elaborate a bit, what you mean by toll-free numbers?

Re: [libreoffice-users] [3.5.1.2/Calc/XP] Regex to find/replace numbers?

2012-05-02 Thread Steve Edmonds
On 2012-05-03 00:05, Nino Novak wrote: Hi, On Wednesday 02 May 2012, 04:18:20 Gilles wrote: I need to search and reformat toll-free numbers in a spreadsheet, but I can't find how to do this in Calc: Sorry, could you elaborate a bit, what you mean by toll-free numbers? Some examples?

Re: [libreoffice-users] [3.5.1.2/Calc/XP] Regex to find/replace numbers?

2012-05-02 Thread e-letter
On 02/05/2012, Gilles codecompl...@free.fr wrote: Hello I need to search and reformat toll-free numbers in a spreadsheet, but I can't find how to do this in Calc: (\d\d)(\d\d)(\d\d) ie. space + six digits in pairs. Do not understand the logic to search for numbers as pairs, but the