Jeff,
Thanks for the suggestions! I will use the replacetext and compare the
speed with the loop and see which is quicker.
Much appreciated!
Warren
On Wed, Jan 19, 2011 at 12:40 PM, Jeff Massung wrote:
> On Wed, Jan 19, 2011 at 11:34 AM, Warren Kuhl
> wrote:
>
> > What would be the most ef
On Wed, Jan 19, 2011 at 11:34 AM, Warren Kuhl wrote:
> What would be the most efficient way to check a variable and replace any of
> the characters with empty if the character is not a alpha (upper or lower),
> numeric (0-9) or a '-'?
>
> The only way I can think of doing this is a repeat loop an
What would be the most efficient way to check a variable and replace any of
the characters with empty if the character is not a alpha (upper or lower),
numeric (0-9) or a '-'?
The only way I can think of doing this is a repeat loop and checking the
value of each character and replacing with empty
