Parse text strings Excel or Access
Budget: $30 – $250 USD
We need text strings to be parsed/split and formatted in a specific way. MS Access would be great, but we can use excel also.
In the Excel file attached, the data to be parsed is in A1. Further down is the desired output - again, this can be either in Excel or Access columns. There are 4 rows, but is variable and could be up to 20+.
* Note in output, there is a second set of rows. These are duplicates, bur with Bought/Sold swapped.
In the Excel file attached, the data to be parsed is in A1. Further down is the desired output - again, this can be either in Excel or Access columns. There are 4 rows, but is variable and could be up to 20+.
* Note in output, there is a second set of rows. These are duplicates, bur with Bought/Sold swapped.