Click to See Complete Forum and Search --> : Ignore Commas


August 18th, 1999, 10:31 AM
Using Visual Basic 6, I'm trying to import a non comma separated text file to a database and I'm inputting("Input #1") the lines line by line and then I test it with a series of If statements using "mid(integer, 1, 10)" (this is an example). Now this is all fine but if one of those (1+10)characters is a comma (like "Long, Mike") then it goes to the next field and throws the hole thing off.
Can someone help me?

Harmon Wood