fork download
  1. library(stringr)
  2. companies=c(
  3. "612. Grt. Am. Mgt. & Inv. 7.33",
  4. "77. Wickes 4.61",
  5. "265. Wang Labs 8.75",
  6. "9. CrossLand Savings 6.32",
  7. "228. JPS Textile Group 2.00"
  8. )
  9.  
  10. pattern="([^.]+)\\.\\s+(\\D+)\\s+(\\d\\.\\d{2})"
  11. str_match(companies, pattern)
Success #stdin #stdout 0.22s 190592KB
stdin
Standard input is empty
stdout
     [,1]                             [,2]  [,3]                   [,4]  
[1,] "612. Grt. Am. Mgt. & Inv. 7.33" "612" "Grt. Am. Mgt. & Inv." "7.33"
[2,] "77. Wickes 4.61"                "77"  "Wickes"               "4.61"
[3,] "265. Wang Labs 8.75"            "265" "Wang Labs"            "8.75"
[4,] "9. CrossLand Savings 6.32"      "9"   "CrossLand Savings"    "6.32"
[5,] "228. JPS Textile Group 2.00"    "228" "JPS Textile Group"    "2.00"