reading in tab delimited text into arraylist

[Guest]

I have code right now that reads in the file into an arraylist, but it reads
in each line of the text file as a single element rather than the separate
tab delimited strings in the line. Is there some way to split the text as
its being read in? The file is both tab delimited and has a carriage return
at the end of each line. Thanks!

using System;
using System.IO;
using System.Collections;

namespace try_again
{
class Class1
{
static void Main(string[] args)
{
StreamWriter swa = new StreamWriter ("c:\\afinal.txt");
StreamReader sra = new StreamReader ("c:\\ChristineWork\\test1.txt");
string aLine = "";

ArrayList aColumn = new ArrayList ();
while (aLine != null)
{
aLine = sra.ReadLine();

if (aLine != null)
{
string line = aLine.Split(new Char [] {' '});
aColumn.Add(aLine);

Console.WriteLine(">"+aLine+"<");

}
Console.ReadLine();
sra.Close();

 

[Dan =o\)]

string FileBuffer = sra.ReadToEnd().Replace ( "\r\n", "\t" );
string [] TokenBuffer = FileBuffer.split ( '\t' );

 

[Guest]

Ok, here is the code that I have now. The second console.writeline only
gives the type of TokenBuffer as opposed to the actual values. I have run
into this before, but my memory is failing me when it comes to how I cleared
this up.

StreamWriter swa = new StreamWriter ("c:\\afinal.txt");
StreamReader sra = new StreamReader ("c:\\ChristineWork\\test1.txt");

string aLine = sra.ReadToEnd();
Console.WriteLine(aLine);
string[] TokenBuffer = aLine.Split('\t', '\r');
Console.WriteLine(TokenBuffer);

Console.ReadLine();
sra.Close();

string FileBuffer = sra.ReadToEnd().Replace ( "\r\n", "\t" );
string [] TokenBuffer = FileBuffer.split ( '\t' );

I have code right now that reads in the file into an arraylist, but it
reads
in each line of the text file as a single element rather than the separate
tab delimited strings in the line. Is there some way to split the text as
its being read in? The file is both tab delimited and has a carriage
return
at the end of each line. Thanks!

using System;
using System.IO;
using System.Collections;

namespace try_again
{
class Class1
{
static void Main(string[] args)
{
StreamWriter swa = new StreamWriter ("c:\\afinal.txt");
StreamReader sra = new StreamReader ("c:\\ChristineWork\\test1.txt");
string aLine = "";

ArrayList aColumn = new ArrayList ();
while (aLine != null)
{
aLine = sra.ReadLine();

if (aLine != null)
{
string line = aLine.Split(new Char [] {' '});
aColumn.Add(aLine);

Console.WriteLine(">"+aLine+"<");

}
Console.ReadLine();
sra.Close();

 

[James Curran]

Replace

Console.WriteLine(TokenBuffer);

with

foreach(string token in TokenBuffer)
Console.WriteLine(token);

--
Truth,
James Curran
Home: www.noveltheory.com Work: www.njtheater.com
Blog: www.honestillusion.com Day Job: www.partsearch.com
(note new day job!)

Ok, here is the code that I have now. The second console.writeline only
gives the type of TokenBuffer as opposed to the actual values. I have run
into this before, but my memory is failing me when it comes to how I cleared
this up.

StreamWriter swa = new StreamWriter ("c:\\afinal.txt");
StreamReader sra = new StreamReader ("c:\\ChristineWork\\test1.txt");

string aLine = sra.ReadToEnd();
Console.WriteLine(aLine);
string[] TokenBuffer = aLine.Split('\t', '\r');
Console.WriteLine(TokenBuffer);

Console.ReadLine();
sra.Close();

string FileBuffer = sra.ReadToEnd().Replace ( "\r\n", "\t" );
string [] TokenBuffer = FileBuffer.split ( '\t' );

I have code right now that reads in the file into an arraylist, but it
reads
in each line of the text file as a single element rather than the separate
tab delimited strings in the line. Is there some way to split the text as
its being read in? The file is both tab delimited and has a carriage
return
at the end of each line. Thanks!

using System;
using System.IO;
using System.Collections;

namespace try_again
{
class Class1
{
static void Main(string[] args)
{
StreamWriter swa = new StreamWriter ("c:\\afinal.txt");
StreamReader sra = new StreamReader ("c:\\ChristineWork\\test1.txt");
string aLine = "";

ArrayList aColumn = new ArrayList ();
while (aLine != null)
{
aLine = sra.ReadLine();

if (aLine != null)
{
string line = aLine.Split(new Char [] {' '});
aColumn.Add(aLine);

Console.WriteLine(">"+aLine+"<");

}
Console.ReadLine();
sra.Close();

 

[Guest]

Ok this is working great except it is picking up spaces as elements now. I
only want the strings that are not null. How do I do this?

string aLine = sra.ReadToEnd();
string[] TokenBuffer = aLine.Split(new Char [] {' '});
foreach(string token in TokenBuffer)
{
Console.WriteLine(token);
}

Console.ReadLine();
sra.Close();

Console.WriteLine(TokenBuffer.Length);
Console.ReadLine();

Replace

Console.WriteLine(TokenBuffer);

with

foreach(string token in TokenBuffer)
Console.WriteLine(token);

--
Truth,
James Curran
Home: www.noveltheory.com Work: www.njtheater.com
Blog: www.honestillusion.com Day Job: www.partsearch.com
(note new day job!)

Ok, here is the code that I have now. The second console.writeline only
gives the type of TokenBuffer as opposed to the actual values. I have run
into this before, but my memory is failing me when it comes to how I cleared
this up.

StreamWriter swa = new StreamWriter ("c:\\afinal.txt");
StreamReader sra = new StreamReader ("c:\\ChristineWork\\test1.txt");

string aLine = sra.ReadToEnd();
Console.WriteLine(aLine);
string[] TokenBuffer = aLine.Split('\t', '\r');
Console.WriteLine(TokenBuffer);

Console.ReadLine();
sra.Close();

string FileBuffer = sra.ReadToEnd().Replace ( "\r\n", "\t" );
string [] TokenBuffer = FileBuffer.split ( '\t' );


I have code right now that reads in the file into an arraylist, but it
reads
in each line of the text file as a single element rather than the separate
tab delimited strings in the line. Is there some way to split the text as
its being read in? The file is both tab delimited and has a carriage
return
at the end of each line. Thanks!

using System;
using System.IO;
using System.Collections;

namespace try_again
{
class Class1
{
static void Main(string[] args)
{
StreamWriter swa = new StreamWriter ("c:\\afinal.txt");
StreamReader sra = new StreamReader ("c:\\ChristineWork\\test1.txt");
string aLine = "";

ArrayList aColumn = new ArrayList ();
while (aLine != null)
{
aLine = sra.ReadLine();

if (aLine != null)
{
string line = aLine.Split(new Char [] {' '});
aColumn.Add(aLine);

Console.WriteLine(">"+aLine+"<");

}
Console.ReadLine();
sra.Close();

 

[James Curran]

Ok this is working great except it is picking up spaces as elements now. I
only want the strings that are not null. How do I do this?

foreach(string token in TokenBuffer)
{
string token2 = token.Trim();
if (token2.Length > 0)
{
Console.WriteLine(token2);
}
}


--
Truth,
James Curran
Home: www.noveltheory.com Work: www.njtheater.com
Blog: www.honestillusion.com Day Job: www.partsearch.com
(note new day job!)