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:
OK, this is what I can achieve with a simple text editor:
Replace all "Rp" with "Rp|"
Replace all " % " with "%"
Replace all %) with )%
Copy all and paste into a spreadsheet with English(UK) as import locale.
Both, space and | as column delimiters with "Merge" option and "special
numbers" option.
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
On 2015-10-09 06:35, Andreas Säger wrote:
OK, this is what I can achieve with a simple text editor:
Replace all "Rp" with "Rp|"
Replace all " % " with "%"
Replace all %) with )%
Copy all and paste into a spreadsheet with English(UK) as import locale.
Both, space and | as column delimiters with
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 |
>
>
>
Am 07.10.2015 um 19:49 schrieb Yudi Wijaya:
> Hi,
> I want to use feature Insert - Sheet from file and i have file.txt that
> contains like this:
> | 1|03/10/2015|14-1403837|SARIPAH | 24 |Rp
> 130,000,000 |Rp 3,799,530|Rp0|Rp 1,600,000|
> 0.0%|Rp
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
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
Additional Options
[X] Regular Expressions
Search: ^\s*\(([[:digit:].]+)\s*%\s*\)\s*$
Replace: $1%