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: [email protected]
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
