The fact is that there are several accounting applications (each group
company has a different system) which export data in different formats
and I am looking for an automation general enough so that I will not
have errors when running the code for each of them (the format is
consistent within each application though).
With respect to the data format the most common are, say for the first
account from the list below: "1011 account name","1011.number " and
"1011.txt" but I also found "txt 1011".
Below are all the account numbers which are compulsory and will be
found as such, uninterrupted, in the data exported, but more likely
will be followed by some other characters (or preceded) as explained
(they are not compulsory in the sense that all of them will be in the
exported data - depending on their activity, some companies do not use
certain categories from the list below - but if you have transactions
which falls into one account, then its number must be shown as a
single block, even if accompanied by other information.
So the first challenge would be to separate those numbers from the
rest of characters. The second challenge, already solved thanks to
your help, was to regroup them based on whether they begin or not with
some specific digits (the first digit indicates a class, the second a
category within the class and the third a group within the category).
Here are the account numbers:
Acc#
1011
1012
1015
108
1041
1042
1061
1063
1068
107
111
112
118
119
105
121
129
141
1511
1512
1513
1514
1518
161
1621
1622
1623
1624
1625
1626
1627
166
167
1681
1682
1686
1687
169
201
203
205
207
208
211
2111
2112
212
2121
2122
2123
2124
2125
2126
2127
2128
230
231
261
262
263
2671
2672
2673
2677
2678
269
280
2801
2803
2805
2807
2808
281
2810
2811
2812
2813
2814
2815
2816
2817
2818
290
291
293
296
300
3011
3012
3013
3014
3015
3016
3018
308
321
322
323
328
331
332
341
345
346
348
351
352
354
356
357
358
361
368
371
378
381
388
390
391
392
393
394
395
396
397
398
401
403
404
405
408
409
411
413
416
418
419
421
422
423
424
425
426
427
4281
4282
429
4311
4312
4371
4372
4381
4382
441
4423
4424
4426
4427
4428
444
445
446
447
4481
4482
4483
4484
4485
4511
4518
4551
4558
456
457
4581
4582
459
461
462
463
471
472
473
476
477
481
482
491
495
496
502
503
505
506
5081
5088
509
5112
5113
5114
5121
5122
5124
5125
5126
5129
5186
5187
5191
5192
5193
5194
5195
5196
5197
5198
5311
5314
5321
5322
5323
5328
5411
5412
542
581
590
600
6011
6012
6013
6014
6015
6016
6018
602
603
604
605
606
607
608
611
612
613
614
621
622
623
624
625
626
627
628
631
635
641
642
6451
6452
6458
651
654
658
663
664
665
666
667
668
6711
6712
6714
6718
6721
6728
681
6811
6812
6813
6814
686
6862
6863
6868
687
6871
6872
6873
6874
691
701
702
703
704
705
706
707
708
711
721
722
741
751
754
758
761
762
763
764
765
766
767
768
7711
7718
7721
7727
7728
781
7812
7813
7814
786
7862
7863
787
7872
7873
7874