I want a way to look for any number over 6 digets and replace it any one got any ideas.
If len(Yournumber) > 6 Then<BR>DO REPLACE <BR>End If
If isNumeric(intNumber) & len(intNumber) > 6 Then<BR> 'replace it<BR>else<BR> 'not over 6 or not a number<BR>end if<BR><BR>IsNumeric isn't perfect, but it'll get you started.
I'm retarded<BR><BR>If isNumeric(intNumber) AND len(intNumber) > 6 Then<BR>'replace it<BR>else<BR>'not over 6 or not a number<BR>end if<BR>
If IsNumeric(MyVar) And Len(MyVar) = 6 Then<BR> MyVar = MyNewNumber<BR>End If
I am too :(
What about if the number is part of a larger string and could contain more than one number
Try split() to turn the string into an array and then loop through the array replacing the >6 digit numbers before putting it all back together again.
So I dunno if that'll work unless he has it converted to a string... no?<BR><BR>I already forget what the poster posted... this is what's wrong with Hungarian Notation!