stas wrote:
>Neil, yes, that's in the source data. I would appreciate your help. I never have enough time to learn more advanced TSQL. Thanks!
> ----- 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]
