Sponsored Content
Top Forums Shell Programming and Scripting awk saving field of first file into array Post 302742285 by rdcwayx on Monday 10th of December 2012 11:05:56 PM
Old 12-11-2012
How about it?
Code:
awk '{sub(/\$/,"",$2)}/paid/{a[$1]+=$2}/due/{a[$1]-=$2}
    END{for (i in a) printf "%s balance:$%.2f \n",i,a[i]}' infile

CoCo balance:$5.40
Euda balance:$45.00

This User Gave Thanks to rdcwayx For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

saving awk value in a bash array variable

hi all i am trying to save an awk value into an array in bash: total=`awk '{sum+=$3} END {print sum}' "$count".txt"` ((count++)) the above statement is in a while loop.. $count is to keep track of file numbers (1.txt,2.txt,3.txt,etc.) i get the following error: ./lines1:... (1 Reply)
Discussion started by: npatwardhan
1 Replies

2. Shell Programming and Scripting

saving values from awk expression into shell array

hi i am trying to save the values i extract from a file with the help of awk in a bash shell array. i have: exec 10<file2 while read LINE <&10; do ARRAY1=$(awk '{print $1}' file2) ((count++)) done echo ${ARRAY1} it prints just blank lines. file1 has two columns and i... (4 Replies)
Discussion started by: npatwardhan
4 Replies

3. Shell Programming and Scripting

saving values in file in an array in awk

hi i am trying to save values in a file in an array in awk..the file is as follows: 0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0, so far i have this: awk 'BEGIN {RS="\n";FS=","} { for(i=1;i<=NR;i++) { for(j=1;j<=NF;j++) { a=$j; } } (4 Replies)
Discussion started by: npatwardhan
4 Replies

4. Shell Programming and Scripting

perl, put one array into many array when field is equal to sth

Hi Everyone, #!/usr/bin/perl use strict; use warnings; my @test=("a;b;qqq;c;d","a;b;ggg;c;d","a;b;qqq;c;d"); would like to split the @test array into two array: @test1=(("a;b;qqq;c;d","a;b;qqq;c;d"); and @test2=("a;b;ggg;c;d"); means search for 3rd filed. Thanks find the... (0 Replies)
Discussion started by: jimmy_y
0 Replies

5. Shell Programming and Scripting

Saving file content in arrays using AWK

Hi, im new to shell scripting. i have a query for which i have searched your forums but coulndt get what i need. i have a file that has two records of exactly the same length and format and they are comma seperated. i need to save the first and the second columns of the input file to 2 different... (11 Replies)
Discussion started by: atikan
11 Replies

6. Shell Programming and Scripting

awk assign output of array to specific field-number

With this script i want to print the output to a specific field-number . Can anybody help? awk 'NR=FNR{split(FILENAME,fn,"_");nr=$2;f = $1} END{for (i=1;i<=f;i++) print i,$fn=nr}' input_5.csv input_6.csvinput_5.csv 4 135 5 185 6 85 11 30input_6.csv 1 90 3 58 4 135 7 60 8 55 10... (1 Reply)
Discussion started by: sdf
1 Replies

7. Shell Programming and Scripting

How to split file into multiple files using awk based on 1 field in the file?

Good day all I need some helps, say that I have data like below, each field separated by a tab DATE NAME ADDRESS 15/7/2012 LX a.b.c 15/7/2012 LX1 a.b.c 16/7/2012 AB a.b.c 16/7/2012 AB2 a.b.c 15/7/2012 LX2 a.b.c... (2 Replies)
Discussion started by: alexyyw
2 Replies

8. Shell Programming and Scripting

Perl - use search keywords from array and search a file and print 3rd field when matched

Hi , I have been trying to write a perl script to do this job. But i am not able to achieve the desired result. Below is my code. my $current_value=12345; my @users=("bob","ben","tom","harry"); open DBLIST,"<","/var/tmp/DBinfo"; my @input = <DBLIST>; foreach (@users) { my... (11 Replies)
Discussion started by: chidori
11 Replies

9. Shell Programming and Scripting

awk to print array that occurs the most with matching value in another field

In the below awk I am splitting $7 on the : and then counting each line or NM_xxxx. If the $1 value is the same for each line then print the $7 that occurs the most with the matching $1 value. The awk seems close but I am not sure what is going on. I included a description as well as to what I... (1 Reply)
Discussion started by: cmccabe
1 Replies

10. UNIX for Beginners Questions & Answers

awk Associative Array and/or Referring to Field by String (Nonconstant String Value)

I will start with an example of what I'm trying to do and then describe how I am approaching the issue. File PS028,005 Lexeme HRS # M # PhraseType 1(1:1) 7(7) PhraseLab 501 503 ClauseType ZYq0 PS028,005 Lexeme W # L> # BNH # M #... (17 Replies)
Discussion started by: jvoot
17 Replies
Xfontcache(3)						     Library Functions Manual						     Xfontcache(3)

NAME
Xfontcache - X-TrueType font cache extension client library SYNOPSIS
#include <X11/extensions/FontCache.h> typedef struct { long himark; long lowmark; long balance; } FontCacheSettings, *FontCacheSettingsPtr; struct cacheinfo { long hits; long misshits; long purged; long usage; }; typedef struct { long purge_runs; long purge_stat; long balance; struct cacheinfof; struct cacheinfov; } FontCacheStatistics, *FontCacheStatisticsPtr; Bool FontCacheQueryExtension(Display *dpy, int *event_basep, int *error_basep); Status FontCacheQueryVersion(Display *dpy, int *major_versionp, int *minor_versionp); Status FontCacheGetCacheSettings(Display *dpy, FontCacheSettings *cache info); Status FontCacheChangeCacheSettings(Display *dpy, FontCacheSettings *cache info); Status FontCacheGetCacheStatistics(Display *dpy, FontCacheStatistics *cache statistics info); DESCRIPTION
FontCache is an extension that is used by X-TrueType to cache informations about fonts. FontCacheQueryExtension returns True if the FontCache extension is available on the given display. A client must call FontCacheQueryExten- sion before calling any other Xfontcache function in order to negotiate a compatible protocol version; otherwise the client will get unde- fined behavior (Xfontcache may or may not work). FontCacheQueryVersion returns True if the request succeeded; the values of the major and minor protocol versions supported by the server are returned in major_versionp and minor_versionp . FontCacheGetCacheSettings should be documented here. Returns True on success or False on failure. FontCacheChangeCacheSettings should be documented here. Returns True on success or False on failure. FontCacheGetCacheStatistics should be documented here. Returns True on success or False on failure. ERRORS
FontCacheChangeCacheSettings will return BadValue if passed an illegal parameters for lowmark, himark or balance fields. SEE ALSO
X(7) AUTHOR
Akio Morita, X-TrueType team, Nozomi Ytow. STABILITY
This API is considered as experimental. The Xfontcache library major revision may be incremented whenever incompatible changes are done to the API without notice. Use with care. X Version 11 libXfontcache 1.0.4 Xfontcache(3)
All times are GMT -4. The time now is 12:54 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy