<div>
HI,<br />
Use Loop to copy specific line into different Text file, per the date captured, inside the file.
</div>


HI,
Use Loop to copy specific line into different Text file, per the date captured, inside the file.

IT Professional

Albert Widjaja

<div>
Hi HuaMin,<br />
<br />
What do you mean?<br />
<br />
Thank you.
</div>


Hi HuaMin,

What do you mean?

Thank you.

<div>
Hi,<br />
You can write to different text file like<br />

<pre><code id="code-20-42892493-1">    Dim fso As Object
    Set fso = CreateObject(&quot;Scripting.FileSystemObject&quot;)

    Dim Fileout As Object
    Set Fileout = fso.CreateTextFile(&quot;C:\your_path\vba.txt&quot;, True, True)
    Fileout.Write &quot;your string goes here&quot;
    Fileout.Close</code></pre>
<br />
per different date you can see from original csv file.
</div>


Hi,
You can write to different text file like


    Dim fso As Object
    Set fso = CreateObject("Scripting.FileSystemObject")

    Dim Fileout As Object
    Set Fileout = fso.CreateTextFile("C:\your_path\vba.txt", True, True)
    Fileout.Write "your string goes here"
    Fileout.Close


per different date you can see from original csv file.

<div>
HI Huamin,<br />
<br />
But's not a txt file it's CSV, as per my request how do I split a CSV into two files based on specific date value.<br />
<br />
Thank you.
</div>


HI Huamin,

But's not a txt file it's CSV, as per my request how do I split a CSV into two files based on specific date value.

Thank you.

<div>
CSV file is definitely Text file and you could use VBA code to tackle with it.<br />
<br />

<blockquote>
4. Add the following code line:<br />
<br />
Open myFile For Input As #1<br />
Note: this statement allows the file to be read. We can refer to the file as #1 during the rest of our code.<br />
<br />
5. Add the following code lines:<br />
<br />
Do Until EOF(1)<br />
&nbsp; &nbsp; Line Input #1, textline<br />
&nbsp; &nbsp; text = text &amp;&nbsp;textline<br />
Loop<br />

</blockquote>
</div>


CSV file is definitely Text file and you could use VBA code to tackle with it.



> 4. Add the following code line:
> 
> Open myFile For Input As #1
> Note: this statement allows the file to be read. We can refer to the file as #1 during the rest of our code.
> 
> 5. Add the following code lines:
> 
> Do Until EOF(1)
>     Line Input #1, textline
>     text = text & textline
> Loop

General IT Goto Guy

Zack

<div>
Hi Guys ,<br />
<br />
Cheers, this has given something for me to play around with many thanks.
</div>


Hi Guys ,

Cheers, this has given something for me to play around with many thanks.

<div>
<div class="content wysiwyg-content">
Hi EE,<br />
<br />
Can you split a CSV file using PowerShell by specific date range, e.g split csv file into two everything before may 30 2018 on the first file and everything after on the second file?<br />
<br />
2019-04-30 08:15:34.607 - This is date time format of the file I have and it's the first column of the CSV file.<br />
<br />
Any assistance is welcome.<br />
<br />
Thank you.
</div>
</div>


Hi EE,

Can you split a CSV file using PowerShell by specific date range, e.g split csv file into two everything before may 30 2018 on the first file and everything after on the second file?

2019-04-30 08:15:34.607 - This is date time format of the file I have and it's the first column of the CSV file.

Any assistance is welcome.

Thank you.

Split a CSV file into 2 files based on date.

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

A programming language is a formal constructed language designed to communicate instructions to a machine, particularly a computer. Thousands of different programming languages have been created, mainly in the computer field, and many more still are being created every year. The description of a programming language is usually split into the two components of syntax (form) and semantics (meaning). Some languages are defined by a specification document (for example, the C programming language is specified by an ISO Standard), while other languages (such as Perl) have a dominant implementation that is treated as a reference. Some languages have both, with the basic language defined by a standard and extensions taken from the dominant implementation being common.

Programming Languages-Other

A scripting language is a programming language that supports scripts, programs written for a special run-time environment that automate the execution of tasks that could alternatively be executed one-by-one by a human operator. Scripting languages are often interpreted (rather than compiled). Primitives are usually the elementary tasks or API calls, and the language allows them to be combined into more complex programs. Environments that can be automated through scripting include software applications, web pages within a web browser, the shells of operating systems (OS), embedded systems, as well as numerous games. A scripting language can be viewed as a domain-specific language for a particular environment; in the case of scripting an application, this is also known as an extension language.