Deepankar's profile.NET Rocks!!!PhotosBlogListsMore  |  Tools Help |
Strip HTML Tags from a StringThe function below will strip the passed string of all HTML Tags. Usage string StrippedString = StripHTML ( HTMLString ) Public static string StripHTML ( string value ) { // Strip the html tag string pattern = "<(.|\n)+?>"; string strOutput = string.Empty; Regex regex = new Regex ( pattern, RegexOptions.IgnoreCase ); // Replace all HTML tag matches with an empty string strOutput = regex.Replace(value, string.Empty); // Replace all < and > with < and > strOutput = strOutput.Replace("<", "<"); strOutput = strOutput.Replace ( ">", ">"); return strOutput; } Code SnippetsI will over the next week keep posting a code snippets which are very useful in development of web applications
Keep watching this space. Reading Excel SheetsSo, I've been writing a little app to combine some Excel spreadsheets. These sheets all have header rows, so I cand open them up with an OleDbConnection, do a "SELECT * FROM [Sheet1$]" and go along my merry way. The problem is, two of the columns I need to work with just aren't there. They're on the excel sheet just fine, but my OleDbDataReader finds nothing in those columns on any row. Looking at the sheet, I see that in those columns, there isn't any data for about 12 rows. So, I put in zeros at the top of those columns, and then it works fine.
Is the OleDbConnection really making assumptions about the dataset based on the first row? After much googling and little success, I try to find a definition of the connectionstring, hoping there's some attribute like "rows to scan for schema" I can set, to tell it to actually read my data. Nathan points me to an excellent resource, Connectionstrings.com, and they kindly let me know that I can specify
HDR=Yes; to indicate that I have a header row in my sheets, and IMEX=1; which, according to Connectionstrings.com: tells the driver to always read "intermixed" data columns as text.Apparently, the two columns in question were, in fact "intermixed" data columns, and once I set that in my connectionstring, all worked fine.
If you have, for instance, both strings and numerics in one external data column, you can get unexpected results - like some of your data doesn’t show up and the above solution doesn't work for you, then again after a lot of googling and research, i tried to change the registry keys as mentioned in this article External Data - Mixed Data Types
The mixed use of "1" and "Yes" aside, why the hell would your database driver just silently ignore data? I mean, if "intermixed" data columns is an error condition, then have the balls to throw a exception, warning, event log entry, anything. Don't just not work and expect me to magically know where the problem is. I almost reimplemented the whole damn thing using Excel objects and the Office API, and that would've taken me another couple of days. A pox on the Excel team! Status UpdateIn case your guys are wondering, I'm still alive and will now start posting to this blog regularly. I've been upto some few cool things.. here is a status update www.earlylearning.co.nz, www.distributoys.co.nz are live and kicking Beta version of www.cityfind.co.nz will be going live by the 15th of this month And most importantly I have been working hard on Sid's new site which will have his own blog and photo gallery. Where are the devs hanging outWhen I don't know something I'll ask. So, software developers - where is your favorite place to learn about new techniques?
Where? Where do your colleagues go and you don't? |
|
|
