Hi
I would like to parse a string field obtained from transaction statement into various components. For example the following string: "Bought Woolworths Holdings Limited 14.9276 @ 6,699.00 With Price Limit <= 6,700.00"
Output should give me the following additional fields:
1) Stock
2) Number of shares
3) Price per a unit
Date | Description | Value | Stock | Number of shares | Price per unit |
2022/11/18 | Bought Woolworths Holdings Limited 14.9276 @ 6,699.00 With Price Limit <= 6,700.00 | -1000 | Woolworths Holdings Limited | 14.9276 | 6,699.00 |
hi @AdenJAlt this is a perfect job for the regex tool.
Hi @AdenJAlt
Will all the inputs for huge data set will follow the same format?
Many thanks
Shanker V
Yes, the data set would just be "Bought" transactions. The data set includes the following fields:
Date | Description | Value |
The syntax of Description field will consistently follow as: "Bought [Stock xx] [Units bought xx] @ [Price]". There is often additional text after the price if a specific buy instruction was included, however I am not too interested in that.