Recent content by annethorne

I think I have found my answer: private static string RedactCC(string stringToRedact) { const string pattern = @"(?:4[0-9]{12}(?:[0-9]{3})?|5[1-5][0-9]{14}|6(?:011|5[0-9][0-9])[0-9]{12}|3[47][0-9]{13}|3(?:0[0-5]|[68][0-9])[0-9]{11}|(?:2131|1800|35\d{3})\d{11})"; stringToRedact...

I have found this reference: http://foobook.org/erbere/scraps/find-and-replace-text-with-regex/ :)

Hi everyone, I need a function to redact possible SSNs and CCs from a string. This is for an application that receives messages from customers, which may contain SSNs or CCs. Instead of passing on that message, we want to redact it of the sensitive information. We do have some SQL...

Hi Fellow Developers, After some searching, we found the solution. I simply had my brother install the following: http://www.microsoft.com/en-us/download/details.aspx?id=13518 ProPhotoTools.msi His system did not have Microsoft.ImageMetadata references in it. All...

Hi Fellow Developers, I have created a Dot Net Windows application for my brother. It reads .jpg files and extracts exif information from them and then saves that information into a .csv file. I have written it on a 64 bit machine. He either has a 64 bit, or a 32 bit machine. I'm not...

Hi SQL Developer Friends, I would like implement the following techniques in some SQL scripts: 1) Before updating a table, copy it into a new table that has the same table name, appended with an underscore and the datetime. For example if the name of the table was Browsers then I would copy...

Yes... Thank you so much!!! :) Anne

Thank you so very much! This is a very useful technique. I changed it only very slightly as follows: BEGIN TRANSACTION BEGIN Declare @Lookup Table(LookupName VarChar(50), LookupValue VarChar(5000)) Insert Into @Lookup Values('Shelternet_IsActive','true') Insert Into @Lookup...

Hi, I want to write a script for our Release Engineers to run that does the following (which doesn't even work :( though this is the general idea ... and doesn't require my cutting and pasting so much). I think I need to perhaps create some arrays, and use a while statement? But, there may be...

Hi, We are currently building a Windows Application with Visual Studio, C# and SQL. Exceptions are caught and logged. Is there a way for us to determine the exact spot in the code where the error occurred, that is the CLASS and the METHOD? Here is the code we use now: catch (Exception error)...

Thank you so much George :) Yes it is for the zip code thing :) I really appreciate your help :) Anne

Hi, I have never written a trigger before. This is probably very simply, but I need some assistance: The basic concept is as follows. When user puts values into Table One, a TRIGGER occurs and values are automatically put into Table Two: Table One has 3 basic columns, and Table Two has 2...

Thank you George. What you showed us is very valuable!!! Have a great day! Anne

Thank You, Thank You, Thank You, SQLDenis!!! Have a Great Day! Anne

Hi, I know this is very easy... I just don't know how to do it: We have the following table named Wzip_Detail [Wzip_Detail_ID] [int] IDENTITY (1, 1) NOT NULL , [PostalCode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [CountryCode] [varchar] (3) COLLATE...