fork(1) download
  1. match($0,/[-[:blank:]]([0-9][0-9,.]*)-[^-]+$/){val=substr($0,RSTART,RLENGTH);sub(/^ +/,"",val);sub(/ +.*$/,"",val);num=split(val,arr,"-");print $1,arr[num-1];val=""}
Success #stdin #stdout 0s 4360KB
stdin
Client No.   Client Name                     O/S Balance        Ledger1      Ledger2      Ledger3        Ledger4      Ledger5      Ledger6      Ledger7 Comments
  C00716427.1  Queensview Ohio LLC.              888,924.35           0.00         0.00         0.00     888,924.35     1,803.21         0.00     2,499.96-admin fee
  C00716576.3  0140-8487 Quebec Inc            6,260,987.91           0.00         0.00         0.00   6,260,987.91    18,418.34         0.00        20.99-May 01/20 w/c
  C00716868.1  0328-2400 Quebec Inc.           1,183,948.05           0.00         0.00         0.00   1,183,948.05     2,155.69     5,211.35-1,198,846.32-April 29/20 p/o
  C00617231.3  Ricky Baker Enterprise         49,593,446.91           0.00         0.00         0.00  49,593,446.91    83,220.21   442,202.51-      105.14-May 01/20 w/c
  C00617316.3  101287388 Sarasota LLC.         3,089,599.64           0.00         0.00         0.00   3,089,599.64     2,604.15    27,134.56-        6.08-May 01/20 w/c
  C00617447.2  AmeriUnion Trade 123            6,088,229.78           0.00         0.00         0.00   6,088,229.78    24,921.06         0.00       325.26-surplus funds
stdout
C00716427.1 2,499.96
C00716576.3 20.99
C00716868.1 1,198,846.32
C00617231.3 105.14
C00617316.3 6.08
C00617447.2 325.26