Lookup & return data from ascii text file
 

I'm trying to figure out the following:

1) Take the Lookup Value in Cell B2, i.e. "*0001324*"

2) Find the match in a text file with PSV laid out thusly over 1.
million lines-- PartNumber may, or may not, be in ascending order:
PartNumber|ItemName|SoS|Unit|Price|Core
9999999|Fluid, Brake,Silicon|E|GAL|$56.00|N
0000001|Gadget,Widget|A|DZ|$99.99|N
*0001324*_|Starter,_Pre-Lubed|A|EA|$1500.00|Y_
0001322|Starter,Standard|B|EA|$3570.00|Y

3) Return the matching line across Cells that may or may not match th
text file order.
i.e: _ItemName_ to D2, _SoS_ to C2, _Unit_ to E2, _Price_ to G2
_Core_ to F2

-Bonus: ensure that there is only one space after each comma-.

4) Loop until there are no more Lookup Values in Column B.
Note: Since the Invoice could be one page or 20, it would involv
using
the PrintArea to establish the length of Col B and backin
off "x"
number of Rows to get to the actual last row of the invoic
table,
or simply determing the last cell of worksheet.

TIA

And

--
AH·
-----------------------------------------------------------------------
AH·C's Profile: http://www.excelforum.com/member.php...fo&userid=2910
View this thread: http://www.excelforum.com/showthread.php?threadid=48828