C# Split CSV string

	string str = "Tom Cruise, Scott, ,Bob | at";
	IEnumerable<string> names = str
	.Split(new char[]{',', '|'})
	.Where(x=>x!=null && x.Trim().Length > 0)
	.Select(x=>x.Trim());

view raw SplitCsvString_Advanced hosted with ❤ by GitHub

Output

Tom
Cruise
Scott
Bob
at

Stackoverflow post:
https://stackoverflow.com/a/45799171/799593

C# String Extension & Helper Methods

I enjoyed spending some time after creating some very useful (at least to me 😛 ) C# helper functions for string operation. So here is the gist of it

C# String Perf Take # 2 ( Accused : IsNullOrEmpty() )

String is a reference type. The IsNullOrEmpty is used to check weather string reference is null (null) or contains any data (empty string). According to MSDN :

Quickly convert Comma Separated Values to Dictionary

If you are getting some sort of CSV let’s say some sort of configurations or data object or whatever the case may be, my strategy is : “If you can not deserialize ’em, structure ’em !”

And here is one of the possible scenario :

TIP :

If you’re dealing with more complex scenario, you might wanna consider using Tuple or Jagged Tuple ! ( What is it ? )

Remove strings between double quotes

How many times you have to bullet proof your application against some bad or junk data ? Sometimes we might not have anticipated some scenario until quite a while. And this can quite possible if your application relies on some other program ( data from web service, some sort of incoming XML or something like that )

Well LINQ is your friend !

Just a heads up :

Going forward I shall try to maintain all string manipulation related posts ALSO under ‘string-manipulation‘ tag, just if that helps you drill down the content better. Cheers ! 😉

Quickly Clean-up Blank lines from a multi-line String

Scenario : At the time of consuming data from another application or program, one of the frequent issue is data in and data out ! I was working for similar scenario the other day where a flat was generated and then another program had lexical parser and would generate tokens etc. Long story short, in a typical workflow we had blank lines and they were causing issue. Very simple issue … once this stupid thing is identified and verified being the actual culprit !

Let’s take a look :

C#

Below are some code snippets / recipes that I have had prepared for myself and I thought of sharing with ya’ll as a firs post in C# category. If you do not find one that you are looking for or want more, just drop me a request or comment below, I’d try to address the request.

Example	Description	Download
Global Variables in C#	Different scenarios as your requirement and need	zip
Text to SQL Server	Read a text file and insert all records in SQL Server.	zip
Update combobox items according to selection of column-name in other combobox		zip
MySQL(SQL Server) To MsAccess	Copy table of Ms-Access from the data of the MySQL	zip
(Basic) Reading Ms-Excel spreadsheets	Reading data from Excel sheets using C#	zip
Updating Ms-Excel spreadsheets	Updating data of Excel sheets using C#	zip
Accessing .config file	The app.config can be used to access some setings (like conn string) anywhere in the project	zip
MySQL (SQL Server) database to CSV	Convert record set from MySQL query to csv file	zip
String Delimiter	Various illustrations in a single project, demonstrating ways to use the String.Split() function	zip
Date – Times	Gets the beginning and ending dates of This Week Last Week This Month Last Month Last 6 Months This Year Last 3 Years	zip
Update/Delete CSV	Here is the work around for Updating / Deleting records from CSV, which usually is just a file IO operation otherwise	zip
json	json in C# using JSON .NET & LINQ	zip
json serialization	serialization/de-serialization of json	zip
Stateful iterations	By using yield keyword, difference b/w IEnumerable and IEnumerator	zip

ASP.NET

Below are some code snippets that I have prepared initially, if you do not find one that you are looking for, just [ drop me an E-mail ] or just a comment below would suffice. Also please note that a demo illustrated in SQL server should also work with MySQL & vice-versa.

Example	Description	Download
Populate gridview programmatically using MySQL	Loading the gridview programmatically using C# from database	zip
Gridview with a drop-down filter in the header	Filter your gridview with a drop down in the table header	zip
Adding controls on the fly in GridView	(Esp. with custom user control,) add hyper-link check-boxes dynamically	zip
Paging & Sorting in Gridview	Programmatically handle paging and sorting events of gridview	zip
Insert/Update/Delete	using Button field of the DataGridView(Accessing the cell values of the row containing the button clicked) if you want to retrieve the cell values of the row after the button from that row has clicked and to fire database queries	zip
Export Gridview to …	MS ACCESS / MS EXCEL / CSV	zip
Combobox hard-coded values & Database records to gather	Loading a combobox, with static items as well as items from database	zip
Sending plain text E-mail message from web app to Gmail	You can specify from, password, to, subject and message to send an email	zip
Caching 1	Simple Page Level Caching	zip
Caching 2	Caching SQL Server Caching for certain amount of time	zip
Caching 3	SQLServer Automated Caching and Updating Cached version at Regular Intervals and upon Create/Update/Delete operations	zip
Caching 4	Partial Page Caching, Multiple & Multi-Level Page caching and … Clearing the cache	zip
Shortening GUID	Sometimes we want to get the shortest GUID for building URLs or for dynamic file names, So I created a slight variant of GUID	zip
Parsing Uri (Query Params)	When one has the URL of the page from which QueryParams are wanted but can not use Request.QueryString (when the URL is not of current page, stored in a object in a memory etc)	zip
Nested GridViews	A basic example of how a grid can become a part of data row of some master table (master – grid )	zip
Nested GridViews + Conditional Formatting	Apply conditional formatting to your nested grid	zip
Filter DataGrid w/ LINQ	An example demonstrating how LINQ can be used to filter out the data from the Data Grid	zip
Gridview : JavaScript/jQuey to databing + filter	An example demonstrating how to bind data to Gridview using Client Side Script + filtering ( filter as you type )	zip
Nested GridVeiw	A gridview inside a gridview	zip
Nested Gridview	Nested Expandable & Collapsible Gridview (Same Row)	zip
Nested Gridview	Nested Expandable & Collapsible Gridview (Next Row)	zip
Signal R	Move Shape + Group Discussion / Chat + etc …	zip
G.Drive Spreadsheets	Access Google-SpreadSheet Via Gdata And C#	zip
Parameter Parsing	Parsing parameters from query string	zip
Short GUID	Get Short (& sweet) : unique strings, unique, not random chars as random may not be unique	zip
String Float Double InterConversion		zip
2D Array To-String And Vice-Versa		zip
Async GridView (Take # 1)	Loading the data for the gridview asynchronously from database Poll Approach Wait Approach	zip
CSV to Gridview	A sample web app demonstrating how to load gridview from multiple CSV dynamically (one at a time)	zip
Crystal Report : Dynamic Binding	Conditional Data-binding from multiple tables, after the report has been loaded	zip