in a txt file, how do you check for duplicates, and ignore the ones that are?
Printable View
in a txt file, how do you check for duplicates, and ignore the ones that are?
Duplicates what ? words or lines or letters ?? btw , you have very bad way to present your question .:D
In the txt file, i have product numbers, product names, and prices. I want to check for duplicate product numbers. When a duplicate is found, I want to ignore it so that the duplicate won't appear in the combo box that i'm presenting the information in.
i'm sorry if my questions are ambiguous. it's hard for me to put into words what i wanna ask.
Regular expression is what you're looking for . There are couple of links on this forum , check them out by searching the forum .
You're looking at instring function
instr()
Search for it.