On Aug 31, 2009, at 3:53 PM, John wrote: > I have some stuff where I just run a strtran(myfield, 'this > value','') for > removing bad data, and put the value in for replacements. > It seems to work fine.
Well, I had a bunch of those, too. I just did it with a combination of Word (to get each command on one line), appended that into a temp table, and used getwordnum() on the " to parse the values. Turns out I had ~350 REPLACE commands, and about 50 new ones to add from the latest batch of data. Thanks for stimulating my brain to get it done.... Ken _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/152383b2-9551-4a66-be15-8aae0a2ef...@information-architecture.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
