Re: [libreoffice-users] Re: Percentage with bracket as negative

On 2015-10-09 06:10, Andreas Säger wrote:
> Am 08.10.2015 um 03:24 schrieb Yudi Wijaya:
> > 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,
> The currency comes with comma as thousands separator. This would be in
> conflict with any comma as decimal separator.
> I would not handle this mess with spreadsheets. First I would blame the
> creator of this ugly shit. Ask for clean text data with no leading and
> trailing spaces, currency symbols "Rp" in extra columns and proper
> numerals. If this is not an option, I would write a simple script to
> clean up the mess.
Coming in late here, but this looks like reports I import from our 
accounting system up to 4 times an hour.

|     1|02/10/2015|17-2202200|MAKMUR                   |  24 |
|     1|03/10/2015|14-1403837|SARIPAH                  |  24 |


I think Andreas regexp is good and could be used with a little tweek. 
Part of your problem may be to do with locale.
The report uses point as decimal and comma as thousands separator. I 
think you are saying your locale uses comma as decimal and point as 
thousands separator.
Do you have to import these often.
Steve

--
To unsubscribe e-mail to: users+unsubscribe@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