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

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?
>
>
> > " (\d\d)(\d\d)(\d\d)"
> This regex will find text like " 123456", not numbers (as numbers are numbers
> and do not contain blanks)
>
>
> > ie. space + six digits in pairs.
> what do you mean by "pairs"? The above regex does not find any kind of
> "pairs".
>
> So, I'm a bit clueless, what you want to search really.
>
> Nino
>
>   
Hi. Is the object to then paste the new number from $1 $2 $3 to get the 
new formatting? Is there always white space at the front

"\s(\d\d)(\d\d)(\d\d)"
steve


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted