Hi All,
I have this text file that I need to parse and put the parsed data in the database
Name Qty1 Qty2 Name Qty1 Qty2
ABC 1 2
BCD 2 3
EFG 7 9 PQR 56 97
DEF 3 18 RET 988 11
I have a table where I need to put the above data
The table structure is like this
Name, Qty1, Qty2,Col
so If I parse from left side then I can put the ABC,1,2, L in the table and if Parse from right side then I can put PQR, 56, 97, R in the same table.
My problem is how can I differentiate between left column and right columns. As soon as I start reading, I can read ABC,1,2 and then I don't know if there is a value in Right column and if I keep reading through my VB.net code then, I will start reading
BCD,2,3 and at that point I don't know if BCD belongs to Right Column or left column. I am trying to ...
Go to the complete details ...