Readline Problem

[jedicks]

Hi

I am new to c#. I hava a problem which i am struggling to solve. Please look at code below:

StreamReader sr = new StreamReader(sFilename);
string line = sr.ReadLine();
// line = "a,b,c"
while (line != null)
{
if (line.Trim() != "")
{
string[] split = line.Split(',');
// split[0] = "a";
// split[1] = "b";
// split[2] = "c";
foreach (string item in split)
{

result += "%" + item + '\n';



}

}
line = sr.ReadLine();
}

StreamWriter sw = new StreamWriter(sfd.FileName);
sw.Write(result + "%%%%%");
sw.Close();
MessageBox.Show("File has been converted");
textBox1.Text = "";
}
else{
MessageBox.Show("Please Select a File to Convert");
}
}

I am trying to read in a file and get a result looking like this

%SEARCH=LOGIN_ID
%LOGIN_ID=22441794
%ANALYST_ID=22441794
%LAST_NAME=Andrews
%FIRST_NAME=Benedict
%BEEPER_PHONE=0828570239
%PHONE_NUMBER=38528
%ALT_PHONE_NUMBER=
%FAX_NUMBER=
%LOCATION=78 Fox Street
%EMAIL_ADDRESS=[e-mail]
%ZFLOOR=Floor 5
%ADMINISTRATIVE_BUSINESS=Gauteng Shared Services Center
%FUNCTIONAL_BUSINESS=Customer Management Services
%POSITION=Team Leader
%%%%%
%SEARCH=LOGIN_ID
%LOGIN_ID=22441794
%ANALYST_ID=22441794
%LAST_NAME=Andrews
%FIRST_NAME=Benedict
%BEEPER_PHONE=0828570239
%PHONE_NUMBER=38528
%ALT_PHONE_NUMBER=
%FAX_NUMBER=
%LOCATION=78 Fox Street
%EMAIL_ADDRESS=[e-mail]
%ZFLOOR=Floor 5
%ADMINISTRATIVE_BUSINESS=Gauteng Shared Services Center
%FUNCTIONAL_BUSINESS=Customer Management Services
%POSITION=Team Leader
%%%%%

But instead I get something like this

%SEARCH=LOGIN_ID
%LOGIN_ID=22441794
%ANALYST_ID=22441794
%LAST_NAME=Andrews
%FIRST_NAME=Benedict
%BEEPER_PHONE=0828570239
%PHONE_NUMBER=38528
%ALT_PHONE_NUMBER=
%FAX_NUMBER=
%LOCATION=78 Fox Street
%EMAIL_ADDRESS=[e-mail]
%ZFLOOR=Floor 5
%ADMINISTRATIVE_BUSINESS=Gauteng Shared Services Center
%FUNCTIONAL_BUSINESS=Customer Management Services
%POSITION=Team Leader
%SEARCH=LOGIN_ID
%LOGIN_ID=22441794
%ANALYST_ID=22441794
%LAST_NAME=Andrews
%FIRST_NAME=Benedict
%BEEPER_PHONE=0828570239
%PHONE_NUMBER=38528
%ALT_PHONE_NUMBER=
%FAX_NUMBER=
%LOCATION=78 Fox Street
%EMAIL_ADDRESS=[e-mail]
%ZFLOOR=Floor 5
%ADMINISTRATIVE_BUSINESS=Gauteng Shared Services Center
%FUNCTIONAL_BUSINESS=Customer Management Services
%POSITION=Team Leader
%%%%%

I want to break every new line by 5 %%%%% percentages. After it has been read.

Please help.

[kenobewan]

Welcome to TSDN. One way would check the item for POSITION and add the %%%%% afterwards.

[Plater]

Hi, you are only telling the "%%%%%" to be added at the END of result, after it has already read in the entire file.
I believe I have made the correct changes to your code:

StreamReader sr = new StreamReader(sFilename);
string line = sr.ReadLine();
// line = "a,b,c"
while (line != null)
{
    if (line.Trim() != "")
    {
        string[] split = line.Split(',');
        // split[0] = "a";
        // split[1] = "b";
        // split[2] = "c";
        foreach (string item in split)
        {
 
         result += "%" + item + '\n';
         result+="%%%%%\n";// <-- Added this line
 
        }
 
    }
    line = sr.ReadLine();
}
 
StreamWriter sw = new StreamWriter(sfd.FileName);
sw.Write(result);// <-- Removed the "%%%%%" from here
sw.Close();
MessageBox.Show("File has been converted");
textBox1.Text = "";
    }
  else
  {
      MessageBox.Show("Please Select a File to Convert");
    }
}