Re: sql select

Here you are The awk: awk ' BEGIN {FS="|"} {A[NR]=$1; B[NR]=$2; C[NR]=$3; D[NR]=$4;} \\ END {printf(" Type "); for(i=1;i<=NR;i++) {printf("%d/98 ", A[i]);}; printf("\\n"); printf("--------- --------- --------- ---------\\n") printf("a)CASH INFLOW "); for(i=1;i<=NR;i++) {printf("%d ", B[i]);}; printf("\\n"); printf("b)CASH OUTLOW "); for(i=1;i<=NR;i++) {printf("%d ", C[i]);}; printf("\\n"); printf("----------------------------------------------\\n") printf("NET FLOW(a-b) "); for(i=1;i<=NR;i++) {printf("%d ", D[i]);}; printf("\\n");} ' oper.unl Regards Alexander Leites