Am 08.10.2015 um 19:46 schrieb Steve Edmonds:
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
Yes, and there are negative percents in braces with lots of spaces and
the % within the braces.
Calc has no problem with (20)% which correctly imports as -0.2. Calc it
does not interprete (20%).
I could not find a locale for currencies with leading "Rp". Indonesian
should work because it has such currency formats but Indonesian import
locale gives text.
And yes, a trivial sed script can fix this. But I'm not familiar with
sed and most users use Windows.
Since LO comes with Python, Python could provide a cross-platform solution.
--
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
Context
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.