<div>
Didn't work.. &nbsp;It's one field thus not sure...
</div>


Didn't work..  It's one field thus not sure...

<div>
I think I would want to see the script before you changed it, and what the input file looks like.<br />
<br />
~bp
</div>


I think I would want to see the script before you changed it, and what the input file looks like.

~bp

<div>
Script just had &nbsp;'2012', '2013' etc.. &nbsp;for array. &nbsp;That's only change.
</div>


Script just had  '2012', '2013' etc..  for array.  That's only change.

<div>
That new string to look for is in a different column which is ok as the text files controls it.... Nt really sure how to proceed......
</div>


That new string to look for is in a different column which is ok as the text files controls it.... Nt really sure how to proceed......

<div>
Splitting points as it's dead question....Sorry.
</div>


Splitting points as it's dead question....Sorry.

<div>
<div class="content wysiwyg-content">
I have a vb script that looks for a number in some files. &nbsp;However now I need it altered to look at column 3 of the files in the 'data_files_to_splice.txt'<wbr /> file. &nbsp;I updated this file to point to Column 3. &nbsp;However when I put the string around quotes in the array line, it doesn't return any rows. &nbsp;I suspect that line needs tweaked? &nbsp;Attached is the current script.<br />
<a href="https://filedb.experts-exchange.com/incoming/2013/01_w03/628729/splice-years.vbs" target="_blank" class="file-inline" title="script (2 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>splice-years.vbs</a>
</div>
</div>


splice-years.vbs

I have a vb script that looks for a number in some files.  However now I need it altered to look at column 3 of the files in the 'data_files_to_splice.txt' file.  I updated this file to point to Column 3.  However when I put the string around quotes in the array line, it doesn't return any rows.  I suspect that line needs tweaked?  Attached is the current script.

VB Script - Need altered a bit

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

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

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.