Guest User

Untitled

a guest
Jan 10th, 2017
168
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
R 0.62 KB | None | 0 0
  1. x <- "id,Price
  2. 1,Total:$164 (164+0)
  3. 2,Total:$449 (449+0)
  4. 3,Total:$910 (910+0)
  5. 4,Total:$477 (377+100)"
  6.  
  7. DF <- read.csv(textConnection(x), stringsAsFactors = FALSE)
  8.  
  9. library(stringr)
  10. str_match_all(DF$Price, "Total:\\$\\d+ \\((\\d+)\\+(\\d+)\\)")
  11. # [[1]]
  12. #      [,1]                 [,2]  [,3]
  13. # [1,] "Total:$164 (164+0)" "164" "0"
  14. #
  15. # [[2]]
  16. #      [,1]                 [,2]  [,3]
  17. # [1,] "Total:$449 (449+0)" "449" "0"
  18. #
  19. # [[3]]
  20. #      [,1]                 [,2]  [,3]
  21. # [1,] "Total:$910 (910+0)" "910" "0"
  22. #
  23. # [[4]]
  24. #      [,1]                   [,2]  [,3]
  25. # [1,] "Total:$477 (377+100)" "377" "100"
  26. #
Advertisement
Add Comment
Please, Sign In to add comment