Numbers & Text Within the Same Field

[ALewis06]

I pulled data from a server; one of the fields was Community Name but due to an internal glitch some of the fields have garbage in them--they have numbers in the Community Name field. Of course the data type for this field is Text. I need to be able to do some sort of delete query and remove every row that has a Community Name showing as a number. How do I do that when 80% of the rows are legitimate ie. Community Name as text?

 

[John Big Booty]

You could use the Replace() function in conjunction with a set of incrementing loops to cycle through each record and in turn cycle through the numbers zero to nine and replace them with a Zero Length string.

 

[plog]

John's solution won't delete your rows, it will update the fields to blanks. That may or may not what you want. To actually delete the entire rows, I would set up a DELETE query and use criteria to determine which rows. The IsNumeric (http://www.techonthenet.com/excel/formulas/isnumeric.php) function will determine if a field is a number and allow you to identify them that way.

 

[John Big Booty]

Good catch there plog I misread/understood what they where trying to do