read text file

[earlrainer]

Hi ,

i am new to VB so please help.

i have a fixed length text file with the following format
itemnumber price
itemnumber length 13
price length 9

can you show me how to write a function that accepts as input a itemno
then it searches for the itemno in the file
if found it returns the price
else if item not found then it returns -1

also is there a faster way to read the text file by converting it into binary file maybe?

 

[SkipVought]

earl,

Have you looked at VB help? Look for Input, Input # and Line Input #.

Basically you'll open the file, input a line, test the input, when your test is true, close the file and return the value.

Hope this helps

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com