Is there a way I can search for a pattern in rows of data and then store them in separate columns of a new table? For example, if I need to extract amount, bills and coins from the body below, do you think it’s possible to achieve the desired result on R
user_id | ts | body | address |
3633| 2016-09-29| A wallet with amount = $ 100 has been found with 4 bills and 5 coins| TEST |
4266| 2016-07-20| A purse having amount = $ 150 has been found with 40 bills and 15 coins| NAME |
7566| 2016-07-20| A pocket having amount = $ 200 has been found with 4 bills and 5 coins| HELLO |
(This is the desired result)
user_id | Amount | Bills| Coins|
3633 | $100 | 4 | 5|
4266 | $150 | 40 | 15|
7566 | $200 | 10 | 10|