Viewing 15 posts - 46 through 60 (of 164 total)
one of the ways to do this kind of replacements is to go one level deeper in regex matching using Capturing Groups of a Match:
consider this input string;
string MySrtToClean =...
April 25, 2008 at 11:33 am
GSquared (4/24/2008)
Now, can that be added into Matt's regex easily, to deal with removing all other non-numeric symbols, but leaving complex numbers intact?
GSquared,
please tell me which Matt's regex you have...
April 24, 2008 at 3:22 pm
GSquared (4/21/2008)
April 23, 2008 at 5:39 pm
Jeff,
i agree in this simple replace it would be an overkill. But replace pattern can change by the minute. Wouldn't it be more convenient to have one [or more] replace...
March 26, 2008 at 4:13 pm
these days you can easily perform this kind of string processing by means of CLR Regular Expression functions:
http://www.sqlservercentral.com/articles/Development/clrintegration/1967/
You need to create a UDF CLR function that would match...
March 26, 2008 at 10:28 am
2 hrs is still too long time; u probably consumed all the memory in your box by now.
I think u r still taking too big leaps: i'd try to...
March 24, 2008 at 4:44 pm
b4 facing 40 M recs, I'd probably create a small (100k recs) test dataset, run the sp vs it and gather some performance stats. Then proceed further.
U should terminate the...
March 21, 2008 at 11:47 am
--You don't need temp table and multiple inserts to remove dublicates. Consider this scenario:
--A tbl with some dublicates:
CREATE TABLE [dbo].del_dublicates(
[RowID] [int] NULL,
[CustID] [smallint] NULL,
[CustName] [nchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AcctMngr] [nvarchar](50) COLLATE...
March 20, 2008 at 4:23 pm
;)...for your regex needs, consider the best regex site:
regexadvice.com
We've got a regex construction forum there, including .NET, C# and VB versions.
everyone is welcome to stop by.
March 20, 2008 at 10:55 am
GSquared (3/20/2008)
Matt Miller (3/19/2008)
...Knowing the pattern allows you to come up with something better.
Yeah.
Of course, as in my prior example, turning "235 dogs, 5 cats", into "2355", is probably not...
March 20, 2008 at 10:25 am
thank you for explaining this, really appreciated.
Sergei
March 20, 2008 at 6:00 am
antonio.collins (3/18/2008)
if you open a word, excel, or even a text file and then click file>save, the file will...
March 19, 2008 at 1:33 pm
Jeff,
thank you for explaining this. You are a big help as usual. I'll test and get back with results.
Sergei
March 18, 2008 at 7:34 pm
Hi, Jeff...it's good to hear from you again ;=)
I'm beng told that Update will constitute actual change in at least one [ or more] of the fields within a row....
March 18, 2008 at 4:04 pm
Thanks a lot, Adam, square brackets work.
Sergei
March 18, 2008 at 1:51 pm
Viewing 15 posts - 46 through 60 (of 164 total)