using find in notepad
Wednesday, January 28, 2004 at 8:00 pm
Posted by Jerry
(1 messages posted)
At the place I work we enter in a lot of barcodes into an SQL based program. We then
send a manifest (in notepad format) to our customer. Who in return enters it into
another program for verification reasons. Sometimes there is a glitch, and one or
several of the numbers that were scanned in are too short in length. That makes there
program spit it back out. Is there any way to search for say any characters less
than 16 digits in length? There are thousands of numbers to search through, and this
takes forever.
[Reply or follow-up to this message]
|
re: using find in notepad
Thursday, January 29, 2004 at 3:00 pm
Posted by rmoore
(210 messages posted)
Can you imoprt your lists to Excel? If so, you could use the LEN formula which will
return the number of characters in a text string.
On Wednesday, January 28, 2004 at 8:00 pm, Jerry wrote:
>At the place I work we enter in a lot of barcodes into an SQL based program. We
then
>send a manifest (in notepad format) to our customer. Who in return enters it into
>another program for verification reasons. Sometimes there is a glitch, and one or
>several of the numbers that were scanned in are too short in length. That makes
there
>program spit it back out. Is there any way to search for say any characters less
>than 16 digits in length? There are thousands of numbers to search through, and
this
>takes forever.
[Reply or follow-up to this message]
|
