Shell Programming and Scripting

Could you help please.

Thanks

help please

Thanks

Please don't bump up your post, read the rules.

If you want to totalize this line with the previous series you should use another approach.
To totalize this line with the next series the code should be:

Code:

awk '
(/^5/ || /^7/) && t && n > 1 {printf("%s%010d%s\n",substr(s,1,20),t,substr(s,31));t=0;n=0}
/^6/ {t+=substr($0,21,10);s=$0;n++;next}
{print}' file

Hi
Sorry abt the post. The line in red is not being included in the total of first group 6 lines. It should be processed as first group total as it is before second 5 line. In the new script it is not including this line. Could u please help. Thanks very much.

In ur script it is including this line in the 2nd group total but it should be in the first group total. I want to totalize with the previous series as it is occuring before 2nd 5 group line.

101 3234344443433230430021170810060810A094101CITIZEN AMERICAN
5200AMERICAN 144892 4333332117CCDOCT06 2008
62201100123409-1960 000167231560000526 AMERICAN
705RMR*11*379426274762004*0000852630\
705RMR*11*378531408781001*0000259602\
705RMR*11*378538061761006*0000093900\
705RMR*11*379424325743008*0000286610\
62201100123409-1960 000013337960000526 AMERICAN EXP
5200AMERICAND 144892 3232302117CCDOCT07 2008
62201100123409-1960 000157231560000526 AMERICAN
705RMR*11*379477306771000*0000133379\
820000018601023114390000000000000000139365873043002117
9000001000020000001860102311439000000000000000013936587
9999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999$

Hi
Can you please let me know how to do with the previous series approach. I also have another question. Didn't knew if this should be a new thread? If I want to to pick a field from the line starting with 90 and replace field at position 21-30 on first line 6 and delete remaining 6 lines for that 5 group line. This should happen for each 5 group lines.

The fields in red should be replaced with the Bold on line 6

101 3234344443433230430021170810060810A094101CITIZEN AMERICAN
5200AMERICAN 144892 4333332117CCDOCT06 2008
62201100123409-1960 000013768460000526 AMERICAN
62201100123409-1960 000085263060000526 AMERICAN
705RMR*11*379426274762004*0000852630\
705RMR*11*378531408781001*0000259602\
705RMR*11*378538061761006*0000093900\
705RMR*11*379424325743008*0000286610\
62201100123409-1960 000013337960000526 AMERICAN EXP
820000018601023114390000000000000000139365873043002117
9000001000020000001440102311439000000000000000013936587
5200AMERICAND 144892 3232302117CCDOCT07 2008
62201100123409-1960 000023768460000526 AMERICAN
62201100123409-1960 000025263060000526 AMERICAN
705RMR*11*379477306771000*0000133379\
62201100123409-1960 000024188960000526 AMERICAN
820000018601023114390000000000000000139365873043002117
90000010000200000018601023114390000000000000000143936587
9999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999

so the required output will be

101 3234344443433230430021170810060810A094101CITIZEN AMERICAN
5200AMERICAN 144892 4333332117CCDOCT06 2008
62201100123409-1960 013936560000526 AMERICAN
705RMR*11*379426274762004*0000852630\
705RMR*11*378531408781001*0000259602\
705RMR*11*378538061761006*0000093900\
705RMR*11*379424325743008*0000286610\
820000018601023114390000000000000000139365873043002117
9000001000020000001440102311439000000000000000013936587
5200AMERICAND 144892 3232302117CCDOCT07 2008
62201100123409-1960 014393660000526 AMERICAN
705RMR*11*379477306771000*0000133379\
820000018601023114390000000000000000139365873043002117
90000010000200000018601023114390000000000000000143936587

Hi
Could you help please. I know i am not supposed to bump up the post but i am in a urgent situation.

help please.