Split text file by Fixed Length
-
Yeppp I've knowed how to read I use
using System.IO;
namespace WindowsApplication23
{
public partial class Form1 : Form
{
OpenFileDialog o;
FileInfo info;
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
o = new OpenFileDialog();
if (o.ShowDialog() == DialogResult.OK)
{
info = new FileInfo(o.FileName);
label1.Text = info.ToString();
}
}
private void button2_Click(object sender, EventArgs e)
{
StreamReader reader = info.OpenText();
textBox1.Text = reader.ReadToEnd().ToString();
reader.Close();
}
}
}but it read all of my file I just want it from ==lo12365=12/08/05 12.30 lo op ==lo12589=13/08/04 12.15 li oo ==lo89099=18/05/09 12.10 io io tobe lo12365 12/08/05 12.30 lo op lo12589 13/08/04 12.15 li oo lo89099 18/05/09 12.10 io io and insert it to my table thx in advance
Well as i suggested use ReadLine() you are using ReadToEnd() which is not what you want. in you button2_Click...
StreamReader reader = new StreamReader(info.Filname);
string line = reader.ReadLine();
while(line!= null)
{
string newLine = line.Replace("=", " ");
string[] vals = newLine.Split(' ');//use this if you need values seperate for table
//do something like add newLine to table, or add the string in the vals array
line = reader.ReadLine();
}reader.Close();
Life goes very fast. Tomorrow, today is already yesterday.
-
Well as i suggested use ReadLine() you are using ReadToEnd() which is not what you want. in you button2_Click...
StreamReader reader = new StreamReader(info.Filname);
string line = reader.ReadLine();
while(line!= null)
{
string newLine = line.Replace("=", " ");
string[] vals = newLine.Split(' ');//use this if you need values seperate for table
//do something like add newLine to table, or add the string in the vals array
line = reader.ReadLine();
}reader.Close();
Life goes very fast. Tomorrow, today is already yesterday.
-
Quoting Sean Hederman from http://social.msdn.microsoft.com/forums/en-US/csharpgeneral/thread/b0d4cba1-471a-4260-94c1-fddd4244fa23/[^]
string sourceFileName = @"C:\VS2005 SP1.exe";
string destFileLocation = @"C:\";
int index = 0;
long maxFileSize = 52428800;
byte[] buffer = new byte[65536];
using (Stream source = File.OpenRead(sourceFileName))
{
while (source.Position < source.Length) { index++; // Create a new sub File, and read into t string newFileName = Path.Combine(destFileLocation, Path.GetFileNameWithoutExtension(sourceFileName)); newFileName += index.ToString() + Path.GetExtension(sourceFileName); using (Stream destination = File.OpenWrite(newFileName)) { while (destination.Position < maxFileSize) { // Work out how many bytes to read int bytes = source.Read(buffer, 0, (int) Math.Min(maxFileSize, buffer.Length)); destination.Write(buffer, 0, bytes); // Are we at the end of the file? if (bytes < Math.Min(maxFileSize, buffer.Length)) { break; } } } }}
Vasudevan Deepak Kumar Personal Homepage
Tech Gossips
The woods are lovely, dark and deep, But I have promises to keep, And miles to go before I sleep, And miles to go before I sleep! -
It has error on
StreamReader reader = new StreamReader(info.Filname);
can I change it to b
StreamReader reader = new StreamReader(o.FileName);
and it can't run on Button2 I don't know why
yes you can change it to that. The parameter is just the full path of the file. And why cant it work it buttonClick? you get error message? You can put the code anywhere. you decide where is best for you
Life goes very fast. Tomorrow, today is already yesterday.
-
yes you can change it to that. The parameter is just the full path of the file. And why cant it work it buttonClick? you get error message? You can put the code anywhere. you decide where is best for you
Life goes very fast. Tomorrow, today is already yesterday.
I don't know why I add
string line = reader.ReadLine();
while (line != null)
{
string newLine = line.Replace("=", " ");
string[] vals = newLine.Split(' ');//use this if you need values seperate for table
//do something like add newLine to table, or add the string in the vals array
line = reader.ReadLine();
}
//I add this
textBox4.Text = reader.ReadLine();
reader.Close();and then when I click in button 2 it 's nothing but button 1 can use Thank in advance
-
I don't know why I add
string line = reader.ReadLine();
while (line != null)
{
string newLine = line.Replace("=", " ");
string[] vals = newLine.Split(' ');//use this if you need values seperate for table
//do something like add newLine to table, or add the string in the vals array
line = reader.ReadLine();
}
//I add this
textBox4.Text = reader.ReadLine();
reader.Close();and then when I click in button 2 it 's nothing but button 1 can use Thank in advance
well i would guess you problem is you have not assigned the event handler to button2. Go in design view, select button2, go to the events tab on the right and make sure 'Click' has been set to the handler.
Life goes very fast. Tomorrow, today is already yesterday.
-
well i would guess you problem is you have not assigned the event handler to button2. Go in design view, select button2, go to the events tab on the right and make sure 'Click' has been set to the handler.
Life goes very fast. Tomorrow, today is already yesterday.
Yepp I've done it but It still can't run The first I assign
textBox4.Text = reader.ReadLine.ToString();
but it said I used wrong method so I change it to be
textBox4.Text = reader.ReadLine.();
It's no error but can't use I don't know why TwT Message when it error http://www.uppicth.com/show.php?filex=e5d4b8cd0fec144f140ded8bcbcfe23a.JPG[^]
modified on Thursday, April 30, 2009 6:15 AM
-
Yepp I've done it but It still can't run The first I assign
textBox4.Text = reader.ReadLine.ToString();
but it said I used wrong method so I change it to be
textBox4.Text = reader.ReadLine.();
It's no error but can't use I don't know why TwT Message when it error http://www.uppicth.com/show.php?filex=e5d4b8cd0fec144f140ded8bcbcfe23a.JPG[^]
modified on Thursday, April 30, 2009 6:15 AM
-
I don't know why I add
string line = reader.ReadLine();
while (line != null)
{
string newLine = line.Replace("=", " ");
string[] vals = newLine.Split(' ');//use this if you need values seperate for table
//do something like add newLine to table, or add the string in the vals array
line = reader.ReadLine();
}
//I add this
textBox4.Text = reader.ReadLine();
reader.Close();and then when I click in button 2 it 's nothing but button 1 can use Thank in advance
If you look closely at the code segement you posted:
yueru wrote:
string line = reader.ReadLine();
while (line != null)
{
string newLine = line.Replace("=", " ");
string[] vals = newLine.Split(' ');
line = reader.ReadLine();
}
//I add this
textBox4.Text = reader.ReadLine();
reader.Close();The problem becomes obvious, no? When does it exit from the while loop? How much of the file is left to be read into textBox4? If you still can't see it, run it slowly through the debugger (sorry Luc) and it should be crystal clear. Before you ask, no I won't correct your code. This is a basic error and you will learn better finding it yourself - you have all the clues and tools you need.
No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced. This message is made of fully recyclable Zeros and Ones
-
I will try to resume all answers in the following steps 1. Open file that you want to parse 2. Use StreamReader to read the file 3. Read line using
StreamReader.ReadLine();4. If Step 3 has data, continue to next step, other wise go to step 9 5. from result in above step replace all unnecessary characters with space, in your sample data replace "==" and '=' to space 6. split result from step 5 using method[yourstring].splitin your sample use space as split character 7. post result from step 6 to database 8. repeat step 3 until 7 9. close your StreamReader 10. if there are errors occurred after you doing all steps, ask about them to this forum and read correlated documentations you need happy coding... :)dhaim ing ngarso sung tulodho, ing madyo mangun karso, tut wuri handayani. "Ki Hajar Dewantoro" in the front line gave a lead, in the middle line build goodwill, in the behind give power support
-
Forget about Fixed length it's not my point NOw I 've got the code
String inputfilename = "";
private void Add(){StreamReader reader = new StreamReader(inputfilename);
//MessageBox.Show(inputfilename);string line = reader.ReadLine(); while (line != null) { string Date = line.Substring(12, 8); if (line.Substring(11, 1) == "=") { string Time = line.Substring(21, 5); string Linein = line.Substring(27, 10); string Lineout = line.Substring(38, 1); if ((string.Compare(Lineout, "0") > 0 || string.Compare(Lineout, "0") == 0) && (string.Compare(Lineout, "9") < 0 || string.Compare(Lineout, "9") == 0)) { //int g = line.Length; //string Number = line.Substring(40, g - 40); string Number = line.Substring(40, 20); string Status = line.Substring(61, 3); string Duration = line.Substring(65, 9); string Cost = line.Substring(75, 3); string Detail = line.Substring(79, 2); string Network = line.Substring(82, 8); // trim whitespace from both ends of the elements string txtSQLQuery = "insert into par values('" + Date + "','" + Time + "','" + Linein + "','" + Lineout + "','" + Number + "','" + Status + "','" + Duration + "','" + Cost + "','" + Detail + "','" + Network + "')"; ExecuteQuery(txtSQLQuery); //MessageBox.Show(line); textBox6.Text = textBox6.Text + "\\r\\n" + Date + " " + Time + " " + Linein + " " + Lineout + " " + Number + " "; } else { textBox5.Text = line + "\\r\\n" + textBox5.Text; } } else { textBox5.Text = line + "\\r\\n" + textBox5.Text; } line = reader.ReadLine(); } MessageBox.Show("End while loop"); }thx for all comment +_! :)
