EPS 2019JUL17

> eps_year_xts["2019::"]
             [,1]
2019-01-01 134.39
2019-04-01 136.78
2019-07-01 139.10
2019-10-01 150.00
2020-01-01 153.31
2020-04-01 157.90
2020-07-01 162.84
2020-10-01 167.92

で、


~$cat eps.txt 
12/31/2020 $49.06 $45.22 16.34 17.74 $183.63 $169.14
9/30/2020 $47.36 $44.00 16.83 18.29 $178.22 $164.01
6/30/2020 $45.00 $41.28 17.33 18.86 $173.11 $159.06
3/31/2020 $42.21 $38.65 17.91 19.46 $167.48 $154.18
12/31/2019 $43.65 $40.09 18.38 19.93 $163.26 $150.55
9/30/2019 $42.25 $39.05 19.40 21.52 $154.64 $139.42
6/30/2019 (5.1%) 2941.76 $39.37 $36.39 19.51 21.94 $153.77 $136.73
3/31/2019 2834.40 $37.99 $35.02 18.76 21.30 $153.05 $134.39

のとき

$tac eps.txt | awk '{gsub("\\$","",$NF);print "eps_year_xts[\"2019::\"]["NR"] <- "$NF}'

eps_year_xts["2019::"][1] <- 134.39
eps_year_xts["2019::"][2] <- 136.73
eps_year_xts["2019::"][3] <- 139.42
eps_year_xts["2019::"][4] <- 150.55
eps_year_xts["2019::"][5] <- 154.18
eps_year_xts["2019::"][6] <- 159.06
eps_year_xts["2019::"][7] <- 164.01
eps_year_xts["2019::"][8] <- 169.14