|
|
|
Wednesday, 14 December 2011 01:31 |
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. Using the 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:
using System;
namespace CSharpSample
{
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);
/*
OUTPUT
Original Comma Delimited String:
Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec
*/
// 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");
/*
OUTPUT
Each individual item:
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
*/
// combine array elements with a new separator
string colonDelimeted = String.Join(":", year);
Console.WriteLine("New Colon Delimited String: \n{0}\n", colonDelimeted);
/*
OUTPUT
New Colon Delimited String:
Jan:Feb:Mar:Apr:May:Jun:Jul:Aug:Sep:Oct:Nov:Dec
*/
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");
/*
OUTPUT
The First Three Items:
Jan Feb Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec
*/
string thirdQuarter = String.Join("/", year, 6, 3);
Console.WriteLine("The Third Quarter: \n{0}\n", thirdQuarter);
/*
OUTPUT
The Third Quarter:
Jul/Aug/Sep
*/
}
}
}
 Read more: |
|
|
Monday, 01 November 2010 04:00 |
 | About MDR: Make Diffs Readable
Sometimes diff output can be a pain to read. MDR is a simple tool that reads unified diff output from your favorite version control system or straight from the diff program itself and displays a graphical version of the same information complete with colored highlights of the changes and line numbers. |
Read more: |
|
|
Monday, 31 May 2010 06:43 |
Esempio utilizzo usermacro per effetti di hover su link con javascript...
Creare user macro chiamata es. link, no body, output html:
onmouseout="this.style.textDecoration='none' " >$paramalias
Usage:
{link:url=http://www.atlassian.com|alias=Confluence is cool!}
Reference Read more: |
|
Friday, 07 May 2010 07:00 |
 | About DropImageURL
An application which images a whole web page into a single graphic file, such as a JPEG or TIFF image.
In other words it makes a screen capture of the page, including the portions which may not be viewable in your web browser due to its width or size. The program provides the option to output in various image formats, and to scale the output image by a given percentage. You can invoke this functionality in several ways.
Generated images are placed in the default output folder and named using the title of the web page being imaged. The URL of the imaged file is placed in the files comment. |
Read more: |
|
|
|
|
|
|
|
