Dear Andreas, First of all.. thank you for your reply :-D Your 1st method doesn't work (turn on special number), you're right.. the datas are too bad.
Your 2nd method almost works.. but i think need some modification Search: ^\s*\(([[:digit:].]+)\s*%\s*\)\s*$ Replace: $1% I tested it, if the data is (25.24 % ) will replace it with 25.24% The problem is LibreOffice only recoqnize 25,24% instead 25.24% (so must use "," than ".") For example if i change the data into (25 % ), then your regular expression correct. Do you know how to replace . (dot) with , (comma) ? I already tried use English (UK) but can not Thanks! Best Regards, Yudi Best Regards, Yudi Wijaya On Thu, Oct 8, 2015 at 6:49 AM, Andreas Säger <ville...@t-online.de> wrote: > Am 08.10.2015 um 01:22 schrieb Andreas Säger: > > > > Always turn on "special numbers" option. This will also import correct > > dates. > > > > > > This is not enough. These data are too bad. > menu:Find&Replace... > Additional Options > [X] Regular Expressions > Search: ^\s*\(([[:digit:].]+)\s*%\s*\)\s*$ > Replace: $1% > [Replace All] > > And replace all Rp with nothing in order to get the numbers. > > > -- > To unsubscribe e-mail to: users+unsubscr...@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 > -- To unsubscribe e-mail to: users+unsubscr...@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