Hi,

I have large string. I want to parse it by delimeter and input to datatable. All lines in string are ended by "\n" (vbcrlf) character. The delimeter is specified by user (like comma, tab, space or something else).

So how can I do this?

Thank's
Alexei

to split a string, you can use string.Split method, for example:

string names = "John,Bill,Joy,Andy" ;

string[] elems = names.Split ( new char[] { ',' } ) ;

How you want your datatable like ?

hope this helps

Hi,

I want get the datatable with columns as maximum of tokens in the lines. I can scan all lines and get the maximum number of columns and after itscan the lines in secondand insert all data. But it is easily slow. I need another solution.

Thank's
Alexei

Can you provide some example of the strings and DataTable that you want ??? And also your current solution will be good

Thanks

Hi,

My data in string is like:
1,fsd,dsf34,dfsf,....\n
2,sdf,sdfsf324,sfs,sdfsf,sfs....\n
.....
Number of columns is not same in all rows!

The data must be parsed to datatable quickly. Columns in datatable must be: Column1, Column2, Column3,...

Thank's
Alexei

can you try this;

define and create a datatable

while parsing string
{
get the line and remove '\n'
split the string

create a row

loop thru the string array
{
if column[index] is null then insert a new column to the datatable
assign the string to the current column
}
}

Hi,

It's nice but it doesn't work becouse you can't add columns to datatable in .Net 1.1. I have tryed but got the error that to table with values can be added new column.

Thank's
Alexei

Actually, you can add column to a DataTable using DataTable.Columns.Add method, for example

hope that helps

Hi,

Try to read before. I know how to add columns!!! But I can't add columns when I have rows in datatable. This is my problem.

Thank's
Alexei