Hi All i have this file which i want to to read and convert to csv.
Attach is the file.
I need only three columns but third column is a bit difficult one.
1. I need DATE AND TIME from the top right.
2. I need PRODUCT
4. FREE and ORder Bal column.
Now in this column there are 2 rows the top one is Free stock and under it has Bal on order. I want Bal on order value as 5 column.
Product Code Description FREE
100560 ABC 8
Product Code Description FREE Bal Ord
100560 ABC 8 2