When developing programs that interoperate with external systems, it’s often necessary to process data in a common format. For example, a program may wish to process data from an Excel spreadsheet. Excel has the capability to export a worksheet in Comma Separated Value (CSV) format. Let’s delve deeper into C# split string.
Using the C# string Split() method allows you to extract the values from in between the commas. Similarly, the string Join()method will take individual values from an array and combine them with a separator, such as a comma. The listing below shows how to use the string Split() and Join() methods:
Listing 1: Joining and Splitting Strings: StringJoinSplit.cs
using System; namespace csharp_station.howto { class StringJoinSplit { static void Main(string[] args) { // comma delimited string string commaDelimited = "Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec"; Console.WriteLine("Original Comma Delimited String: \n{0}\n", commaDelimited); // separate individual items between commas string[] year = commaDelimited.Split(new char[] {','}); Console.WriteLine("Each individual item: "); foreach(string month in year) { Console.Write("{0} ", month); } Console.WriteLine("\n"); // combine array elements with a new separator string colonDelimeted = String.Join(":", year); Console.WriteLine("New Colon Delimited String: \n{0}\n", colonDelimeted); string[] quarter = commaDelimited.Split(new Char[] {','}, 3); Console.WriteLine("The First Three Items: "); foreach(string month in quarter) { Console.Write("{0} ", month); } Console.WriteLine("\n"); string thirdQuarter = String.Join("/", year, 6, 3); Console.WriteLine("The Third Quarter: \n{0}\n", thirdQuarter); } } }
And here’s the output:
Original Comma Delimited String: Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec Each individual item: Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec New Colon Delimited String: Jan:Feb:Mar:Apr:May:Jun:Jul:Aug:Sep:Oct:Nov:Dec The First Three Items: Jan Feb Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec The Third Quarter: Jul/Aug/Sep
In the listing above, there is a CSV string named commaDelimited, which holds the twelve months of the year, separated by commas. It splits this string, joins it into another string, performs a three element split, and finally does a selective join of the 6th through 8th elements of a zero-based array.
The simplest syntax of the Split() method accepts a character array as it’s only parameter, listing the characters to use in determining where splitting of the string should occur. It returns an array of strings, with each element of the array corresponding to the value between the specified delimiter(s). The line below is from the first split operation in the listing:
string[] year = commaDelimited.Split(new char[] {','});
In a similar manner, elements of an array may be combined into a delimited string by using the Join() method. The simplest overload of the Join() method accepts two parameters: a string, which separates each array element, and the array of elements to be combined. TheJoin() method is static, requiring the String type identifier, rather than a string instance, to implement the command. The following line from the listing creates a string with all year elements in a sequence and separated by colons:
string colonDelimeted = String.Join(":", year);
Overloads
Those were the simple implementations of these methods and probably the most likely to be used. Now, let’s take a peek at a couple of their overloads to see how to implement more specialized behavior.
The Split() method has an overload with a second parameter, specifying the number of separations to implement. The next line will separate the commaDelimited string into three array elements:
string[] quarter = commaDelimited.Split(new Char[] {','}, 3);
At first thought, one may think that the three array elements could be Jan, Feb, and Mar, but this is not so. The first array element is Jan, the second is Feb, and the last is the rest of the string. To see for yourself, here’s the output string with each array element separated by a space:
Jan Feb Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec
The Join() method has an overload that allows you to extract a subset of an array. The first two parameters are the same as previously described, and the third and fourth parameters specify the position in the array to begin reading and the number of elements to read, respectively. The following line from the listing creates a string with a forward slash between the sixth through eighth elements of the year array:
string thirdQuarter = String.Join("/", year, 6, 3);
Final Thoughts About C# Split String and Join
The string Split() and Join() methods provide the functionality to work with delimited strings. The Split() method allows you to gather a delimited set of values from a string into an array and the C# string Join() method lets you create a delimited string from an array. This supports both custom data formats, as well as information interchange with other programs.
.