Solved

VBA Read Txt Files In A Folder And Delete First Line According To A Criteria

Posted on 2014-11-13
7
287 Views
Last Modified: 2014-11-13
I have put this question before and this is the code which has been kindly sent by the expert "@aikimark".

---------------------------------------------------------------------------------------------------------------------------
Public Sub Q_28550315()
    Dim strFile As String
    Const cPath As String = "C:\users\aikimark\downloads\"
    Const cDefault As String = "10      Session      2010      2010"
    Dim strLine As String
    Dim colLines As Collection
    Dim vItem As Variant
    Dim intFN As Integer
    strFile = Dir(cPath & "*.txt")
    Do Until Len(strFile) = 0
        Set colLines = Nothing
        Set colLines = New Collection
        intFN = FreeFile
        Open cPath & strFile For Input As #intFN
        Do Until EOF(intFN)
            Input #intFN, strLine
            If Right(strLine, 4) = ".exl" Then
            Else
                colLines.Add strLine
            End If
        Loop
        Close intFN
        Open cPath & strFile For Output As #intFN
        If colLInes.Count = 0 Then
            Print #intFN, cDefault
        Else
            For Each vItem In colLines
                Print #intFN, vItem
            Next
        End If
        Close intFN
        strFile = Dir
    Loop
End Sub
----------------------------------------------------------------------------------------------------------------------------------------------

After this question has been accepted (closed) I have spotted a problem which is:
- if the "txt" file contains "," then the "sub" above will generate a file which creates a new line after each of those ",".
Would it be possible to "ignore" the "," and keep the line as it is?

Thanks.
0
Comment
Question by:Duke001
  • 4
  • 3
7 Comments
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
ID: 40439908
Change the line starting

Input

to

Line Input
0
 

Author Comment

by:Duke001
ID: 40439958
Amazing stuff! It works perfectly.

I would like to ask you if you could help to understand why the following code doest work?
Please let me know if I need to open another question?

Thanks
0
 
LVL 24

Expert Comment

by:Phillip Burton
ID: 40439969
Another question is always nice, because it might not be in my expertise, and would advertise to other experts more.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:Duke001
ID: 40439991
hoops! forgot to paste the code

Line 1: Sub test()
Line 2: Dim WshShell As Object
Line 3: Set WshShell = CreateObject("WScript.Shell")
Line 4: WshShell.Run "cmd /K cscript C:\Test1\Make_L_JP.vbs"
Line 5: End Sub
0
 

Author Closing Comment

by:Duke001
ID: 40440001
Quick and efficient!
0
 
LVL 24

Expert Comment

by:Phillip Burton
ID: 40440008
Sorry - WScript not in my expertise.
0
 

Author Comment

by:Duke001
ID: 40440153
I understand.
Thanks any away
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
There is an easy way, in .NET, to centralize the treatment of all unexpected errors. First of all, instead of launching the application directly in a Form, you need first to write a Sub called Main, in a module. Then, set the Startup Object to th…
This video teaches viewers about errors in exception handling.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question