You can use @regex to locate the invalid characters (I'm assuming you only want US/ASCII), do a distinct on the returned matching characters, then use the resulting array with @replace to clean them up.
You would have to loop, but only once for each invalid character, and not for each time that character appears in the resultset.
Is the result set unicode or just high ascii? There are conversion routines for the databases that would probably solve this better...
Regards,
Jason.
On 06/08/2004, at 9:32 AM, John Newsom wrote:
We have a resultset from a sql server query that contains foreign<x-tad-bigger>
letters such as umlauts, etc. These are fouling up our active
directory. We'd like to do a search and replace on the resultset. It
there a way to replace all occurances in an entire result at once
without doing iterations, or rows loops?
Thanks,
John Newsom
Lakeside School
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
</x-tad-bigger><x-tad-bigger>WITH IMAGINATION
</x-tad-bigger><x-tad-bigger>Planning, Implementation and Management of Web Applications
</x-tad-bigger><x-tad-bigger>
</x-tad-bigger><x-tad-bigger>160 Pacific Highway North Sydney NSW Australia 2060</x-tad-bigger><x-tad-bigger>
</x-tad-bigger><x-tad-bigger>phone +</x-tad-bigger><x-tad-bigger>�</x-tad-bigger><x-tad-bigger>612 9929 9229</x-tad-bigger><x-tad-bigger> </x-tad-bigger><x-tad-bigger>fax +</x-tad-bigger><x-tad-bigger> </x-tad-bigger><x-tad-bigger>612 9460 4770</x-tad-bigger><x-tad-bigger>�
</x-tad-bigger><x-tad-bigger>web -</x-tad-bigger><x-tad-bigger> </x-tad-bigger><x-tad-bigger> </x-tad-bigger><x-tad-bigger>email -</x-tad-bigger><x-tad-bigger> </x-tad-bigger><x-tad-bigger>[EMAIL PROTECTED]
</x-tad-bigger>
