|
Help in adding positive & negative values in a column
Hi Gurus,
In my file I have an amount field from position 74 to 87, which contains values starting with '+' as well as '-'. I want to add all positive values in a varible called "CREDIT" and all negative values in a variable "DEBIT". I know, we can use grep to identify values with positive and negative signs. But, don't know, how to add them in 2 separate variables in a script. Is there any way to do that on command line? Any help would be much appriciated. Thanks!
In my file Amount field has right justified values like,
+1345778500000
-327800000
+642307000000
-4300000
+2308007
These values look left justified here on the screen, but they are actually right justified in my file.
|