<div>
Can you submit a sample csv file?
</div>


<div>
Batch can be tricky when handling text files containing special characters.<br />
Powershell is safer (and not as nineties as VB Script).<br />
If the csv has no header line, you need to provide at least the number of columns in the file.<br />
Assuming the csv has a header line, and the column is called &quot;J&quot;:<br />

<pre><code class="code-1 nolinks" id="code-20-41850866-1"><span>$ColumnHeader = &quot;J&quot;</span>
<span>Get-Content C:\Temp\Input.csv | % {$_.$ColumnHeader = ($_.$ColumnHeader).Split('/')[2]; $_} | Export-Csv C:\Temp\Output.csv -NoTypeInformation</span>
</code></pre>
And you'd lose the first 6 characters ...
</div>


<div>
<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/10_w43/1123103/sample.csv" target="_blank" class="file-inline" title="this is a sample file.  colum J has the enrollment year, would like it just to be the year, not day and month. (71 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>sample.csv</a>
</div>


this is a sample file.  colum J has the enrollment year, would like it just to be the year, not day and month.

sample.csv

<div>
This will add quotes around the fields as well; is that a problem?<br />

<pre><code class="code-1 nolinks" id="code-20-41850904-1"><span>Import-Csv -Path C:\Temp\Input.csv -Header (1..17 | % {&quot;Col_$($_)&quot;}) |</span>
<span>	ForEach-Object {$_.Col_10 = ($_.Col_10).Split('/')[2]; $_} | </span>
<span>	Export-Csv C:\Temp\Output.csv -NoTypeInformation</span>
</code></pre>
</div>


<div>
with ps script get &quot;You cannot call a method on a null-valued expression.&quot;<br />
<br />
script i'm running is:<br />
$ColumnHeader = &quot;m&quot;<br />
Get-Content d:\ioeducation\iostudent.c<wbr />sv | % {$_.$ColumnHeader = ($_.$ColumnHeader).Split('<wbr />/')[2]; $_} | Export-Csv D:\ioeducation\student1.cs<wbr />v -NoTypeInformation<br />
<br />
quotes would be a problem
</div>


<div>
Perfect, <br />
<br />
Thank you
</div>


<div>
<div class="content wysiwyg-content">
I have a csv that is an export from a student information system. Lets say field J is the student enrollment date. it comes out as 09/02/2012 i need to change it to just read 2012 (essentially losing the first four characters) for each line of J in the CSV file ?<br />
<br />
Does anyone have a quick batch or VB script that would do something like that ?
</div>
</div>


I have a csv that is an export from a student information system. Lets say field J is the student enrollment date. it comes out as 09/02/2012 i need to change it to just read 2012 (essentially losing the first four characters) for each line of J in the CSV file ?

Does anyone have a quick batch or VB script that would do something like that ?

Removing first 4 characters from date field in csv file

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

Batch files are text files containing a script of commands that are executed by the command interpreter on DOS, OS/2 and Windows systems. Most commonly, they are used to perform a series of functions that are repeated -- copying a set of files created daily with one step, for example.