Need to load a text file and parse 4 fields from each line and place into 4 separate listboxes
Posted on 2007-12-04
Creating a Visual basic project that contains a load buton and 4 listboxes. When load button is clicked, need to prompt user for file location and load file. Once file is loaded, need to parse out 4 fields from each row and place in respective listboxes. The fields needed are MDEntryPx and MDEntrySize to provide price and size. Then MDEntrytype to determine whether it is 0 or 1. If it is 0 the price and size go to the two left listboxes lbbidprice and lbbidsize and if 1 the price and size goe to the two right listboxes lbaskprice and lbasksize. We also need the MDPriceLevel to determine which level to insert into listboxes.
The fields are separated by the ' | ', below is one line from file
-I 10-12 14:08:42.629 3936 4 null Received IR MessageID=100|MsgType=X|MsgSeqNum=2057577|SendingTime=20071009-13:32:33.230|NoMDEntries=1|MDUpdateAction=Change|MDEntryType=Bid|Symbol=MGMAT|CFICode=OC|MaturityMonthYear=20080119|StrikePrice=100|SecurityDesc=MGM|MDEntryPx=7.9|MDEntrySize=60|MDPriceLevel=2|QuantityCustomer=0|Customer=False