www.webdeveloper.com
Results 1 to 2 of 2

Thread: trouble with filestream

  1. #1
    Join Date
    Mar 2006
    Posts
    146

    trouble with filestream

    Hello everyone,

    I am having trouble with some code that I am working to format txt files. I am trying to split the file everytime there is "," and put a tab instead and save a the file


    HTML Code:
    <html>
    
    <head>
    
    <style type="text/javascript">
    
    
    
    </style>
    
    <script type="text/javascript">
    
    function txt_format()
    
    {
    
    var ForReading = 1, ForWriting = 2, ForAppending = 8;
    
    var fso = new ActiveXObject("Scripting.FileSystemObject");
    
    var filename = document.getElementById("filepath").value;
    
    var f = fso.OpenTextFile(filename, ForReading, true);
    var f2 = fso.CreateTextFile(document.getElementById("convert_location").value, true);
    var fline = new Array();
    
    var line_count=0
    var r
    
    while (!f.AtEndOfStream)
        {
        r = f.ReadLine();
        r = r.split(" \",\" ")
        
        fline = ""
    	
        for (i=0;i<r.length;i++)
    	{
    
    	r[i] += "\t ";
    
    	fline += r[i]
    
    	}
        f2.WriteLine(fline);	    
        line_count += 1 	
        
        
        }
    f.Close();
    f2.Close();
    
    }
    
    function saveReport()
    {
       var fso, f; 
       var ForReading = 1, ForWriting = 2;
       fso = new ActiveXObject("Scripting.FileSystemObject")
       f = fso.OpenTextFile(document.getElementById("template_location").value, ForWriting, true)
       f.Write(document.getElementsByTagName('html')[0].innerHTML);
       f.Close();
    }
    
    
    
    </script>
    
    
    </head>
    
    
    <body>
    
    
    
    <table>
    
    <tr>
    <td>Click Browse to find the desired file</td><td><input type="file" id="filepath"/></td>
    </tr>
    
    <tr>
    <td>File Path for converted report</td><td><input type="text" id="convert_location"/> <input type="button" value="convert file" onclick="txt_format()"><td>
    </tr>
    
    <tr>
    <td>File Path to save template</td><td><input type="text" id="template_location"/><input type="button" value="save template" onclick="saveReport()"></td>
    </tr>
    </table>
    
    </body>
    
    
    </html>
    
    text before formating
    
    "ST70739","Nadeem, Sarah","70739","STT","6200","STT","PROJECT",07/15/2010,17:58:14,07/15/2010,17:59:16,H,0:00:01:02,"SALES",0,2024,""
    "ST70728","Caven, Ashley","70728","STT","6225","STT","PROJECT",07/15/2010,15:55:54,07/15/2010,15:58:08,H,0:00:02:14,"SALES",0,2024,""
    

  2. #2
    Join Date
    Aug 2007
    Posts
    3,767
    You want to replace all commas with tabs (or "," with tabs by the look of your split function)?
    Code:
    r = f.ReadLine();
    f2.WriteLine(r.replace(/\s+","\s+/g,"\t"));
    I know no ActiveX, so I presume that your reading and writing code is correct.

    I can't recommend regular expressions highly enough.
    Great wit and madness are near allied, and fine a line their bounds divide.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles