----- Original Message -----
From: Neil Robertson-Ravo [Team Macromedia]
To: SQL
Sent: Tuesday, March 09, 2004 3:46 PM
Subject: Re: DTS script question
Is this in the data itself? This can be done in T-SQL easily....let me
know if this is what you mean and we can work out a script.
stas wrote:
>I have a list of names and some of them have illegal (to my application)
>characters. For example, I may have a first name as 'Stas Jr.", while I am
>only looking for 'Stas' - however, I'd settle for just 'StasJR' as well. How
>would I go about writing a script that would basically strip out any
>non-alpha chars from any given script? I know how to do basic transformation
>within a DTS transformation, is it just a matter of me picking up some
>VBscript fast? I know this is a Regex job...
>
>Thanks
>
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
