Parsing a text file

[JJ]

Whats the best way for me to pull out records from a tab delimited text
file?

Or rather HOW do I parse the text, knowing that the tabs are field
delimiters and a return (I image) signifies a new record
?
JJ

[Alexey Smirnov]

On Jun 6, 4:31 pm, "JJ" <[e-mail] ote:

Whats the best way for me to pull out records from a tab delimited text
file?

Or rather HOW do I parse the text, knowing that the tabs are field
delimiters and a return (I image) signifies a new record
?
JJ

something like this

DataTable dt = new DataTable();

dt.Columns.Add( new DataColumn("col umn1"));
dt.Columns.Add( new DataColumn("col umn2"));

string[] lines = TextBox1.Text.T rim().Split('\r ');
string[] s = null;

foreach (string line in lines)
{
DataRow row = dt.NewRow();

string[] fields = line.Split('\t' );

s[0] = fields[0];
s[1] = fields[1];

row.ItemArray = s;
dt.Rows.Add(row );
}

GridView1.DataS ource = dt;
GridView1.DataB ind();

[Alexey Smirnov]

On Jun 6, 4:40 pm, Alexey Smirnov <alexey.smir... @gmail.comwrote :

>
string[] fields = line.Split('\t' );

s[0] = fields[0];
s[1] = fields[1];

row.ItemArray = s;
dt.Rows.Add(row );

Well... this should be optimized:

string[] fields = line.Split('\t' );
row.ItemArray = fields;
dt.Rows.Add(row );

[JJ]

Great - thanks.
JJ
"Alexey Smirnov" <al************ @gmail.comwrote in message
news:11******** *************@q 66g2000hsg.goog legroups.com...

On Jun 6, 4:31 pm, "JJ" <[e-mail] ote:

>Whats the best way for me to pull out records from a tab delimited text
file?

Or rather HOW do I parse the text, knowing that the tabs are field
delimiters and a return (I image) signifies a new record
?
JJ

something like this

DataTable dt = new DataTable();

dt.Columns.Add( new DataColumn("col umn1"));
dt.Columns.Add( new DataColumn("col umn2"));

string[] lines = TextBox1.Text.T rim().Split('\r ');
string[] s = null;

foreach (string line in lines)
{
DataRow row = dt.NewRow();

string[] fields = line.Split('\t' );

s[0] = fields[0];
s[1] = fields[1];

row.ItemArray = s;
dt.Rows.Add(row );
}

GridView1.DataS ource = dt;
GridView1.DataB ind();

[JJ]

Actually, another question:
Could I open the text file from a path to the users file on their computer,
or do I have to (or is it best to) upload the text file first?
JJ
"Alexey Smirnov" <al************ @gmail.comwrote in message
news:11******** *************@g 4g2000hsf.googl egroups.com...

On Jun 6, 4:40 pm, Alexey Smirnov <alexey.smir... @gmail.comwrote :

>>
string[] fields = line.Split('\t' );

s[0] = fields[0];
s[1] = fields[1];

row.ItemArra y = s;
dt.Rows.Add(ro w);

Well... this should be optimized:

string[] fields = line.Split('\t' );
row.ItemArray = fields;
dt.Rows.Add(row );

[Alexey Smirnov]

On Jun 6, 4:49 pm, "JJ" <[e-mail] ote:

or do I have to (or is it best to) upload the text file first?

Yes, user should upload the file.

Another way is to use a TextBox Control where user could copy/paste an
entire content of the file

[JJ]

I'd prefer it if they could paste as I'd not have to worry about storage
space, but the files in question will have around 3000 lines, so I'm not
sure if that is going to be possible/practical...?
JJ
"Alexey Smirnov" <al************ @gmail.comwrote in message
news:11******** **************@ i38g2000prf.goo glegroups.com.. .

On Jun 6, 4:49 pm, "JJ" <[e-mail] ote:

>or do I have to (or is it best to) upload the text file first?

Yes, user should upload the file.

Another way is to use a TextBox Control where user could copy/paste an
entire content of the file

[Alexey Smirnov]

On Jun 6, 8:31 pm, "JJ" <[e-mail] ote:

possible

yes

practical...?

don't know :-) but it can be a good option, I think.

[JJ]

I guess to avoid my worry of too many files being uploaded, I could just get
them to choose the file on their computer, then read the file and store it
in a static filename (so it keeps over-writing the old one); as I won't need
the file after I've parsed it (and input the fields into a database), that
should be ok.

Hang on though - that wouldn't work if someone else tried to do another
upload at exactly the same time.

I'm not sure their going to like copying and pasting such large files. I
agree though, I'd much rather copying and pasting myself - a lot simpler.
It looks like its either that or an ever growing number of files that I
haven't given them permission to delete.

JJ

"Alexey Smirnov" <al************ @gmail.comwrote in message
news:11******** **************@ i38g2000prf.goo glegroups.com.. .

On Jun 6, 8:31 pm, "JJ" <[e-mail] ote:

>possible

yes

>practical... ?

don't know :-) but it can be a good option, I think.

[Alexey Smirnov]

On Jun 6, 9:00 pm, "JJ" <[e-mail] ote:

I guess to avoid my worry of too many files being uploaded, I could just get
them to choose the file on their computer, then read the file and store it
in a static filename (so it keeps over-writing the old one); as I won't need
the file after I've parsed it (and input the fields into a database), that
should be ok.

Hang on though - that wouldn't work if someone else tried to do another
upload at exactly the same time.

I'm not sure their going to like copying and pasting such large files. I
agree though, I'd much rather copying and pasting myself - a lot simpler.
It looks like its either that or an ever growing number of files that I
haven't given them permission to delete.

A copy/paste approach is good when you have an Excel file and you can
open it, modify and copy the entire contents directly from Excel to
the web site (with a TextBox) without saving the file as a tab-
delimeted (or CSV) export and doing an upload.

But if you already have such file the way with upload is fast and
secure...