Need to replace a line in an Array list

Awesome man!  It worked and fixed the problem.  I had to add a replace statement in the StreamReader looking for :

tmpLine = tmpLine.Replace("", "");

I couldnt get it to work without adding these in addition to following your sugesstions for the StreamWriter function.

I also had to add 2 if statement in the StremWriter statement as follows:

if (items[i].ToString() != "

Thanks for the update.  Im not quite sure I understand.  The first using statement is ended, and the second using statement was started.  I tried your suggestion the best I understood how, and got this error:  Object reference not set to an instance of an object

What I changed from your suggestion is in red:

private void btnImportFile_Click(object sender, ImageClickEventArgs e)
  {
  try
  {
  IImportModule handler = this.GetImportModule();
  string documentPath = this.Server.MapPath(this.ResolveUrl(this.UploadFile.PathLocation));

 
  string destinationDocPath = documentPath;

  if (handler.GetType().FullName == "MySite.ReportImporter.MyCreditReportType")
  {
 
  destinationDocPath = documentPath.Replace(".htm", "_r.htm");
 
  System.Collections.ArrayList items = new  System.Collections.ArrayList();
  string tmpLine;
 
  //READ
  string search = "

The entire second using statement is below:


using (StreamWriter writer = new StreamWriter(destinationDocPath))
                {
                    for (int i = 0; i < items.Count; i++)
                    {                     
                               {

                                    {
                                        writer.WriteLine(items[i].ToString());
                                    }
                                   
                                  }
                        
                            ImportResult importResult = handler.Import(destinationDocPath, this.fldDefaultRoundSpin.Value.ToString() );
                            if (importResult.Success)
                            {
                                this.ImportAccounts = importResult.Item;
                                this.CurrentPage = 0;
                                this.BindReviewAccounts();
                                this.mv.SetActiveView(this.vwReviewImport);
                                if (!CommonUtility.IsNullOrEmpty(importResult.FailedRecords))
                                {
                                    this.grdRecordErrors.DataSource = importResult.FailedRecords;
                                    this.grdRecordErrors.DataBind();
                                }
                            }
                            else
                            {
                                this.SetError(importResult.FriendlyMessage);
                            }
                        }
                    }
                }
        catch (Exception ex)
        {
            SiteLog.LogError(ex);
            this.SetError("An error occurred importing your file.  Please ensure the file is complete and try again.");
        }
    }



Thanks!

Shane, 

The error message suggests that you've opened that file in another program, perhaps in an HTML viewer or editor.

However, from the code you've posted, I can't see the end of the second 'using' statement, so it's possible that you might be doing something in there - before the file is closed - that is causing the error. 

You are not using the DOM to parse the HTML. I just got through writing a reply to another thread about using the DOM; it might help you too (look at the other thread). In that thread I linked to my article on the subject.

Using the DOM might make your code immune to minor changes such as you are plagued with.

Note that the reason I am not saying more is that you obviously have a lot of time invested in the solution you have and I assume you are not inerested in doing it another way.

Thanks.  I replace the code, and now am getting the following error:

Method Name: WinIOError

Declaring Type: System.IO.__Error

Message:

The process cannot access the file 'C:\Directory\Site\Files\Uploads\uniquecustid\SAMPLE REPORT_r.htm' because it is being used by another process.

Could this be because the importer is already running the following function? destinationDocPath = documentPath.Replace(".htm", "_r.htm");


thanks

OK, in that case I'd try:

 System.Collections.ArrayList items = new System.Collections.ArrayList();
 string tmpLine;
 //READ

 string search = "

Thanks for the reply.  The reason is because the credit report source file no longer has the following line in the source file which makes the credit report importer function correctly:

"  ---If this line is in the source code of the report, the importer works.  (THE CREDIT REPORT PROVIDER REMOVED THIS LINE SEVERAL MONTH AGO.  WE ADDED THE STREAMREADER FUNCTION TO ADD THE ABOVE LINE BACK IN THE SOURCE FILE BEFORE IMPORTING THE REPORTS)   This technique worked up until the credit report provider added the below new line to their report source files.


The new line of source that the credit report provider added to their reports is

"  ---The importer will not import the reports since this line has been added to their source file.  When removed from the source file, the importer will import the report successfully. 

I am trying to have the reader look for

"

and then replace it with either the line

" which works,

or it could just remove the line that doesn't work,

".


The importer will work with

"  added, but if the

" is also appearing in the credit report source file, it has to be removed to make the importer work.

thanks

I'm not entirely clear what you're doing here but one thing I've noticed is that the following lines are not actually doing anything:

Sorry, the code piece I uploaded did not upload for some reason.  The piece of code that handles this import click is:

private void btnImportFile_Click(object sender, ImageClickEventArgs e)
    {
        try
        {
            IImportModule handler = this.GetImportModule();
            string documentPath = this.Server.MapPath(this.ResolveUrl(this.UploadFile.PathLocation));

            //modified 8/3/2011
            string destinationDocPath = documentPath;

            //DO THIS ONLY IF TRUECREDIT
            if (handler.GetType().FullName == "MySite.ReportImporter.ReportModel")
            {
                //modified 8/1/2011 - modify source document prior to load
                destinationDocPath = documentPath.Replace(".htm", "_r.htm");
                //StringBuilder lineToWrite = new StringBuilder();
                System.Collections.ArrayList items = new System.Collections.ArrayList();
                string tmpLine;
                int numLines = 0;
                //READ
                using (StreamReader reader = new StreamReader(documentPath))
                {
                    //MODIFY LINE BY LINE WHILE READING
                    while ((tmpLine = reader.ReadLine()) != null)
                    {
                        tmpLine.Replace("", "");
                      
                        //lineToWrite.Append(tmpLine);
                        items.Add(tmpLine);
                        numLines++;
                    }


                }

                int finalLines = numLines;

                //WRITE
                using (StreamWriter writer = new StreamWriter(destinationDocPath))
                {
                    for (int i = 0; i < items.Count; i++)
                    {
                        if (items[i].ToString() != "

Shane,

You've omitted to upload the code so we can have a look at this.