How do I split a string in column in a dataset row

Spliting a column in a dataset row

Posted 19 November 2008 - 09:01 PM

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.

Re: Spliting a column in a dataset row

Re: Spliting a column in a dataset row

Posted 19 November 2008 - 11:07 PM

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.

Re: Spliting a column in a dataset row

Posted 19 November 2008 - 11:25 PM

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.