[tavo2k4]

Hello,

I have a DataSet of rows, I have a field or a column in each row that I wish to split. The string in this column is separated by special symbols, for example "Name - Tampa/FL - 43188". I want to split this string extracting "Name", "City", "Sate" and "Zip" into different strings.

Here is an example of the row and field:

string clientName = dataRow["Client Location"].ToString();

[Jayman]

Use the Split method of the String class to return an array. The following will split on the hyphen symbol.

string[] clientName = dataRow["Client Location"].ToString().Split('-');

Any particular reason the data is stored in a single column in the dataset, instead of each piece of data being stored in its own column?

[tavo2k4]

Jayman, on 19 Nov, 2008 - 08:10 PM, said:

Use the Split method of the String class to return an array. The following will split on the hyphen symbol.

string[] clientName = dataRow["Client Location"].ToString().Split('-');

Any particular reason the data is stored in a single column in the dataset, instead of each piece of data being stored in its own column?

Well, I applied to a company that gave me a project to read a CSV file and save it into a SQL table. One of the requirements is to split this column.

[eclipsed4utoo]

string[] array = dataRow["Client Location"].ToString().Split(new char[]{'-'});
string name = array[0];
string zip = array[2];

string[] secondArray = array[1].Split(new char[]{'/'});

string city = secondArray[0];
string state = secondArray[1];

[Jayman]

@eclipsed4utoo: If you need to split on several different characters. Then this will work equally well and is easier to maintain and more readable. This way you only need one array.

string[] array = dataRow["Client Location"].ToString().Split(new char[] { '-', '/' });

string name = array[0];
string city = array[1];
string state = array[2];
string zip = array[3];

tavo2k4, on 19 Nov, 2008 - 07:17 PM, said:

Well, I applied to a company that gave me a project to read a CSV file and save it into a SQL table. One of the requirements is to split this column.

I see.

[tavo2k4]

Thank you Jayman, this will work

[tavo2k4]

Ok, now I have a string that has the zip code and some text at the end, for example "76065 warranty". I need to clean this string, do I put it in array and do a "for each" or trim it. I just want the first five numbers.

[tavo2k4]

Ok, now I have a string that has the zip code and some text at the end, for example "76065 warranty". I need to clean this string, do I put it in array and do a "for each" or trim it. I just want the first five numbers.

[PsychoCoder]

I would use the Substring Method passing in where to start and how many characters you want, like this

string zipInfo = "76065 warranty";
string zip = zipInfo.Substring(0, 5)

Hope that helps

[n8wxs]

see http://msdn.microsof...y/aka44szs.aspx

[zakary]

if array[3] is your zip code you can do this

// this will remove all characters start at position 5
// so 54321 test will be 54321
string zip = array[3].Remove(5);

[Jayman]

Topics merged.

[tavo2k4]

I am new to this Forum, but I can tell you that so far I got great answers for all my questions.

You guys rule, you are better than http://forums.asp.net/. I feel like no matter how dumb my question is I get quick and great response.

Keep up the good job, and many thanks to every body who answered me.

[eclipsed4utoo]

tavo2k4, on 20 Nov, 2008 - 01:45 PM, said:

I am new to this Forum, but I can tell you that so far I got great answers for all my questions.

You guys rule, you are better than http://forums.asp.net/. I feel like no matter how dumb my question is I get quick and great response.

Keep up the good job, and many thanks to every body who answered me.

We were all noobs at one time or another.