> Gebruik awk (op SCO Unix) Ik heb geprobeerd om een samenvatting van een datafile


> De gebruikte code is:
> Awk '
> Filename \u003d\u003d "FLN" (saldo [substr ($ 0,14,3)] + \u003d substr ($ 0,17,13) (
> END (for (naam in evenwicht) printf ( "% 013s% 3s van% 8s \ n",
> Saldo [naam] / 100, naam, DT) | "sort") 'FLN
>
>
> Het resultaat krijg ik niet goed. Wanneer de bedragen zijn groot,
> Toont totaal in sommige oneven mode.
>
> Kan U kunt u zien waar ik ben fout maken.

waar de bedragen zijn niet groot is het juiste resultaat geeft
Alleen wanneer een groot bedrag gaat het ten onrechte
>
> Doshi
>

Misschien is het mogelijk op te lossen zonder, maar het zien van uw input file en dan die voldoen aan uw code zou maken voor een beter begrip van uw probleem.

de input file FLN leest als dit, en aan het eind wordt toegevoegd het resultaat
0000 180420082CR00000048201000000000000000018042008 0001
0000 180420082CR00000538523000000000000000018042008 0002
0000 180420082CR00000205134000000000000000018042008 0003
0000 180420082CR00000049114000000000000000018042008 0004
0000 180420082CR00000084695000000000000000018042008 0005
0000 180420082CR00000446500000000000000000018042008 0006
0000 180420082CR00000009249000000000000000018042008 0007
0000 180420082CR00000008588000000000000000018042008 0008
0000 180420082CR00000005455000000000000000018042008 0009
0000 180420082CR00000028276000000000000000018042008 0010
0000 180420082CR00000006000000000000000000018042008 0011
0000 180420082CR00000191520000000000000000018042008 0012
0000 180420082CR00000424548000000000000000018042008 0013
0000 180420082CR00000037822000000000000000018042008 0014
0000 180420082CR00004125616000000000000000018042008 0015
0000 180420082CR00000350855000000000000000018042008 0016
0000 180420082CR00000024629000000000000000018042008 0017
0000 180420082CR00000030846000000000000000018042008 0018
0000 180420082CR00000005098000000000000000018042008 0019
0000 180420082CR00000238180000000000000000018042008 0020
0000 180420082CR00000120089000000000000000018042008 0021
0000 180420082CR00000007061000000000000000018042008 0022
0000 180420082CR00001006775000000000000000018042008 0023
0000 180420082CR00000148528000000000000000018042008 0024
0000 180420082CR00000186099000000000000000018042008 0025
0000 180420082CR00000036106000000000000000018042008 0026
0000 180420082CR00000055062000000000000000018042008 0027
0000 180420082CR00000071755000000000000000018042008 0028
0000 180420082CR00000389249000000000000000018042008 0029
0000 180420082CR00000004845000000000000000018042008 0030
0000 180420082CR00002000000000000000000000018042008 0031
0000 180420082CR00000004568000000000000000018042008 0032
0000 180420082CR00000024784000000000000000018042008 0033
0000 180420082CR00000725673000000000000000018042008 0034
0000 180420082CR00000260800000000000000000018042008 0035
0000 180420082CR00000116708000000000000000018042008 0036
0000 180420082CR00000211000000000000000000018042008 0037
0000 180420082CR00000011050000000000000000018042008 0038
0000 180420082CR00000035066000000000000000018042008 0039
0000 180420082CR00000012000000000000000000018042008 0040
0000 180420082CR00000008051000000000000000018042008 0041
0000 180420082CR00000010000000000000000000018042008 0042
0000 180420082CR00000010000000000000000000018042008 0043
0000 180420082CR00000002817000000000000000018042008 0044
0000 180420082CR00000476184000000000000000018042008 0045
0000 180420082CR00000506501000000000000000018042008 0046
0000 180420082CR00000140193000000000000000018042008 0047
0000 180420082CR00000292180000000000000000018042008 0048
0000 180420082CR00000050000000000000000000018042008 0049
0000 180420082CR00000032250000000000000000018042008 0001
0000 180420082CR00000644993000000000000000018042008 0002
0000 180420082CR00000400854000000000000000018042008 0003
0000 180420085CR00000700000000000000000000018042008 0001
0000 180420085CR00000365456000000000000000018042008 0002
0000 180420084CR00000038060000000000000000018042008 0000
0000 180420084CR00000106413000000000000000018042008 0000
0000 180420084CR00000212356000000000000000018042008 0000
0000 180420084CR00000874424000000000000000018042008 0000
0000 180420084CR00001058138000000000000000018042008 0000
0000 180420084CR00000108000000000000000000018042008 0000
0000 180420084CR00001458073640000000000000018042008 0000
0000 180420084CR00000283554000000000000000018042008 0000
0000 180420084CR00003003764000000000000000018042008 0000
0000 180420084CR00000762164970000000000000018042008 0000
0000 180420084CR00001647245000000000000000018042008 0000
0000 180420084CR00008026033670000000000000018042008 0000
0000 180420084CR00003179317000000000000000018042008 0000
0000 180420084CR00001068219680000000000000018042008 0000
0000 180420084CR00014192728700000000000000018042008 0000
0000 180420084CR00003920838980000000000000018042008 0000
0000 180420084CR00002854753000000000000000018042008 0000
0000 180420084CR00000019375000000000000000018042008 0000
0000 180420084CR00001938039170000000000000018042008 0000
0000 180420084CR00001010474000000000000000018042008 0000
0000 180420084CR00000508523000000000000000018042008 0000
0000 180420084CR00010356863790000000000000018042008 0000
0000 180420084CR00005364091150000000000000018042008 0000
0000 180420084CR00005506019720000000000000018042008 0000
0000 180420084CR00001279528080000000000000018042008 0000
0000 180420084CR00003509381250000000000000018042008 0000
0000 180420084CR00002412247450000000000000018042008 0000
0000 180420084CR00001080116500000000000000018042008 0000
0000 180420084CR00011514142040000000000000018042008 0000
0000 180420084CR00014609633810000000000000018042008 0000
0000 180420084CR00002066569640000000000000018042008 0000
0000 180420084CR00007636272590000000000000018042008 0000
0000 180420084CR00001119729000000000000000018042008 0000
0000 180420084CR00003900167650000000000000018042008 0000
0000 180420084CR00011688465530000000000000018042008 0000
0000 180420084CR00001015444000000000000000018042008 0000
0000 180420084CR00004923281100000000000000018042008 0000
0000 180420084CR00002914455680000000000000018042008 0000
0000 180420084CR00007122991810000000000000018042008 0000
0000 180420084CR00003061124030000000000000018042008 0000
0000 180420084CR00001897931660000000000000018042008 0000
0000 180420084CR00003062921460000000000000018042008 0000
0000 180420084CR00002636119100000000000000018042008 0000
0000 180420084CR00001110350000000000000000018042008 0000
0000 180420084CR00001950032830000000000000018042008 0000
0000 180420084CR00005961239640000000000000018042008 0000
0000 180420084CR00003042605290000000000000018042008 0000
0000 180420084CR00005609221770000000000000018042008 0000
0000 180420084CR00000856006000000000000000018042008 0000
0000 180420084CR00001270921660000000000000018042008 0000
0000 180420084CR00008995088120000000000000018042008 0000
0000 180420084CR00003106567780000000000000018042008 0000
0000 180420084CR00000048342000000000000000018042008 0000
0000 180420084CR00002517039240000000000000018042008 0000
0000 180420084CR00000541334000000000000000018042008 0000
0000 180420084CR00000102791000000000000000018042008 0000
0000 180420084CR00002813990640000000000000018042008 0000
0000 180420084CR00000063356000000000000000018042008 0000
0000 180420084CR00017094497930000000000000018042008 0000
0000 180420084CR00001529886480000000000000018042008 0000
0000 180420084CR00000014360000000000000000018042008 0000
0000 180420084CR00000131256000000000000000018042008 0000
0000 180420084CR00000159879190000000000000018042008 0000
0000 180420084CR00000162246000000000000000018042008 0000
0000 180420084CR00000031657000000000000000018042008 0000
0000 180420084CR00000011699000000000000000018042008 0000
0000 180420084CR00000151299000000000000000018042008 0000
0000 180420084CR00000609265830000000000000018042008 0000
0000 180420084CR00002800360100000000000000018042008 0000
0000 180420084CR00002126564000000000000000018042008 0000
0000 180420084CR00001163615550000000000000018042008 0000
0000 180420084CR00000880902000000000000000018042008 0000
0000 180420084CR00002527627580000000000000018042008 0000
0000 180420084CR00006669189400000000000000018042008 0000
0000 180420084CR00000406798000000000000000018042008 0000
0000 180420084DR00000995608750000000000000018042008 0000
0000 180420084DR00002840936000000000000000018042008 0000
0000 180420084DR00003386276710000000000000018042008 0000
0000 180420084DR00005326658830000000000000018042008 0000
0000 180420084DR00002428998850000000000000018042008 0000
0000 180420084DR00001913823800000000000000018042008 0000
0000 180420084DR00002276874450000000000000018042008 0000
0000 180420084DR00009521528670000000000000018042008 0000
0000 180420084DR00004950775860000000000000018042008 0000
0000 180420084DR00001118254000000000000000018042008 0000
0000 180420084DR00003632090520000000000000018042008 0000
0000 180420084DR00002047859000000000000000018042008 0000
0000 180420084DR00011229892980000000000000018042008 0000
0000 180420084DR00000417190000000000000000018042008 0000
0000 180420084DR00006374762420000000000000018042008 0000
0000 180420084DR00002500928200000000000000018042008 0000
0000 180420084DR00005606889170000000000000018042008 0000
0000 180420084DR00010025221230000000000000018042008 0000
0000 180420084DR00001180129570000000000000018042008 0000
0000 180420084DR00000677346860000000000000018042008 0000
0000 180420084DR00008030161740000000000000018042008 0000
0000 180420084DR00003775929950000000000000018042008 0000
0000 180420084DR00005380261340000000000000018042008 0000
0000 180420084DR00006498677290000000000000018042008 0000
0000 180420084DR00004546728430000000000000018042008 0000
0000 180420084DR00032894618400000000000000018042008 0000
0000 180420084DR00004272195850000000000000018042008 0000
0000 180420084DR00002537824000000000000000018042008 0000
0000 180420084DR00001797231000000000000000018042008 0000
0000 180420084DR00004383393250000000000000018042008 0000
0000 180420084DR00009319440280000000000000018042008 0000
0000 180420084DR00001097371000000000000000018042008 0000
0000 180420084DR00003442109000000000000000018042008 0000
0000 180420084DR00002048443000000000000000018042008 0000
0000 180420084DR00008923282000000000000000018042008 0000
0000 180420084DR00000488785000000000000000018042008 0000
0000 180420084DR00004422317730000000000000018042008 0000
0000 180420084DR00001293916000000000000000018042008 0000
0000 180420084DR00001881750000000000000000018042008 0000
0000 180420084DR00000100744000000000000000018042008 0000
0000 180420084DR00000819105000000000000000018042008 0000
0000 180420084DR00000061694000000000000000018042008 0000
0000 180420084DR00000017003890000000000000018042008 0000
0000 180420084DR00011214051260000000000000018042008 0000
0000 180420084DR00010260409000000000000000018042008 0000
0000 180420084DR00005855284000000000000000018042008 0000
0000 180420084DR00003219244300000000000000018042008 0000
0000 180420084DR00001564051000000000000000018042008 0000
0000 180420084DR00003815381000000000000000018042008 0000
0000 180420084DR00003989542820000000000000018042008 0000
0000 180420084DR00004178648000000000000000018042008 0000
0000 180420084DR00002267136000000000000000018042008 0000
0000 180420084DR00000571813500000000000000018042008 0000
0000 180420084DR00000121151000000000000000018042008 0000
0000 180420084DR00000236170000000000000000018042008 0000
0000 180420084DR00000198780000000000000000018042008 0000
0000 180420084DR00000556553000000000000000018042008 0000
0000 180420084DR00000028454000000000000000018042008 0000
0000 180420084DR00001907397000000000000000018042008 0000
0000 180420082DR00000505656750000000000000018042008 0001
0000 180420082DR00000110253000000000000000018042008 0002
0000 180420082DR00000488108000000000000000018042008 0003
0000 180420082DR00000928733000000000000000018042008 0004
0000 180420082DR00000217962000000000000000018042008 0005
0000 180420082DR00000536552000000000000000018042008 0006
0000 180420082DR00000044314930000000000000018042008 0007
0000 180420082DR00000000000000000000000000018042008 0008
0000 180420082DR00000030900000000000000000018042008 0009
0000 180420082DR00000036750000000000000000018042008 0010
0000 180420082DR00000146235000000000000000018042008 0011
0000 180420082DR00000090000000000000000000018042008 0012
0000 180420082DR00000011885000000000000000018042008 0013
0000 180420082DR00000018000000000000000000018042008 0014
0000 180420082DR00000043864590000000000000018042008 0015
0000 180420082DR00000459566000000000000000018042008 0016
0000 180420082DR00000013200000000000000000018042008 0017
0000 180420082DR00000005510000000000000000018042008 0018
0000 180420082DR00001082289000000000000000018042008 0019
0000 180420082DR00000012295080000000000000018042008 0020
0000 180420082DR00000033400000000000000000018042008 0021
0000 180420082DR00000028047000000000000000018042008 0022
0000 180420082DR00000167024000000000000000018042008 0023
0000 180420082DR00001363141040000000000000018042008 0024
0000 180420082DR00000002871000000000000000018042008 0025
0000 180420082DR00000061889000000000000000018042008 0026
0000 180420082DR00000179613300000000000000018042008 0027
0000 180420082DR00000508740090000000000000018042008 0028
0000 180420082DR00000647901210000000000000018042008 0029
0000 180420082DR00000124113000000000000000018042008 0030
0000 180420082DR00000143452000000000000000018042008 0031
0000 180420082DR00000279891000000000000000018042008 0032
0000 180420082DR00000100000000000000000000018042008 0033
0000 180420082DR00000080825000000000000000018042008 0034
0000 180420082DR00000013000000000000000000018042008 0035
0000 180420082DR00004393302000000000000000018042008 0036
0000 180420082DR00000315000000000000000000018042008 0037
0000 180420082DR00000129610600000000000000018042008 0038
0000 180420082DR00000005000000000000000000018042008 0039
0000 180420082DR00000000448000000000000000018042008 0040
0000 180420082DR00000072800000000000000000018042008 0041
0000 180420082DR00000006000000000000000000018042008 0042
0000 180420082DR00000108724000000000000000018042008 0043
0000 180420082DR00000001920000000000000000018042008 0044
0000 180420082DR00000015000000000000000000018042008 0045
0000 180420082DR00000007300000000000000000018042008 0046
0000 180420083CR00000500000000000000000000018042008 0001
0000 180420083CR00002333156000000000000000018042008 0002
0000 180420083CR00006135710000000000000000018042008 0003
0000 180420083CR00001100000000000000000000018042008 0004
0000 180420083CR00007009466000000000000000018042008 0005
0000 180420083CR00014261147000000000000000018042008 0006
0000 180420083CR00004500000000000000000000018042008 0007
0000 180420083CR00004822898000000000000000018042008 0008
0000 180420083CR00001184242000000000000000018042008 0009
0000 180420083CR00060777856520000000000000018042008 0010
0000 180420083CR00007537981000000000000000018042008 0011
0000 180420083CR00003150000000000000000000018042008 0012
0000 180420083CR00002135273000000000000000018042008 0013
0000 180420083CR00012019274000000000000000018042008 0014
0000 180420083CR00014203539000000000000000018042008 0015
0000 180420083CR00001400000000000000000000018042008 0016
0000 180420083CR00000500000000000000000000018042008 0017
0000 180420083CR00002383831000000000000000018042008 0018
0000 180420083CR00001500000000000000000000018042008 0019
0000 180420083CR00002500000000000000000000018042008 0020
0000 180420083DR00002229964000000000000000018042008 0001
0000 180420083DR00003041551000000000000000018042008 0002
0000 180420083DR00011184026000000000000000018042008 0003
0000 180420083DR00008360645000000000000000018042008 0004
0000 180420083DR00002153911000000000000000018042008 0005
0000 180420083DR00000000000000000000000000018042008 0006
0000 180420083DR00000000000000000000000000018042008 0007
0000 180420083DR00000000000000000000000000018042008 0008
0000 180420083DR00000000000000000000000000018042008 0009
0000 180420082DR00000049000000000000000000018042008 0001
0000 180420082DR00000010920000000000000000018042008 0002
0000 180420082DR00000010000000000000000000018042008 0003
0000 180420083DR00000500000000000000000000018042008 0001
0000 180420083DR00003756347570000000000000018042008 0002
0000 180420083DR00015301410000000000000000018042008 0003
0000 180420083DR00021418465000000000000000018042008 0004
0000 180420084DR00000019327000000000000000018042008 0001
0000 180420084DR00000948959000000000000000018042008 0002
0000 180420084DR00000888964120000000000000018042008 0003
0000 180420084DR00000095858000000000000000018042008 0004
0000 180420084DR00000459017000000000000000018042008 0005
0000 180420084DR00000818621000000000000000018042008 0006
0000 180420084DR00000035000000000000000000018042008 0007
0000 180420084DR00001209783000000000000000018042008 0008
0000 180420084DR00000058000000000000000000018042008 0009
0000 180420084DR00000323673000000000000000018042008 0010
0000 180420084DR00000673196000000000000000018042008 0011
0000 180420084DR00000134583000000000000000018042008 0012
0000 180420084DR00000004288000000000000000018042008 0013
0000 180420084DR00000004900000000000000000018042008 0014
0000 180420084DR00000004856000000000000000018042008 0015
0000 180420084DR00000031016000000000000000018042008 0016
0000 180420084DR00000001256000000000000000018042008 0017
0000 180420084DR00000010628000000000000000018042008 0018
0000 180420084DR00000004293000000000000000018042008 0019
dit is de output:
0000001065456 5cr van 18042008
0000014860090 2CR van 18042008
0001.3641e +07 2DR van 18042008
001.49954e +08 3CR van 18042008
002.29408e +08 4CR van 18042008
002.42195e +08 4DR van 18042008awk '
FILENAME \u003d\u003d "all" (saldo [substr ($ 0,14,3)] + \u003d substr ($ 0,17,13)
dt \u003d substr ($ 0,6,8))
END (for (naam in balans)
printf ( "% 013s% 3s van% 8s \ n", balans [naam] / 100, naam, DT) | "Sorteren"
) 'All> sommering

006.79463e +07 3DR van 18042008
en de code uit te voeren was:

006.79463e +07 is een floating point getal. Getallen in awk zijn floating point getallen.
Je hoeft alleen maar te converteren naar een formulier dat u kunt gebruiken.

Ik ben afsluiting van deze draad als OP, met soortgelijke vraag in Shell Programmering en Scripting