• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 382
  • Last Modified:

VB Script modificatin needed

Hi,

Had a script done by RSampson last week that stripped a file and created a new file whenever it found |2102| in the Years column.  Problem is it runs on all files in a directory but the Years column is not always in the same column.  Additionally a data value could be 2012 also as I found out.  Thus I need some tweaks.  You will see below that the 2nd row of data contains |2012| however that's Units and not Years.  Thus current script grabbed that row which is a problem I didn't forsee.  So is there a way I can define which column to search for 2012 for each file?  So somewhere in the script I can list out the filenames and which column to look for 2012 in?  

Style 01 7 75 756 03 01 899833|Fiscal Rcpt Feb|MdseTyp F|2012|1938|6143.46|445.74|25174.6200000000|0.00|651193

Style 01 7 75 756 03 01 899833|Fiscal Rcpt Jan|MdseTyp F|2011|2012|6378.04|462.76|26135.8800000000|0.00|651194
splice.vbs
0
elwayisgod
Asked:
elwayisgod
  • 5
1 Solution
 
elwayisgodAuthor Commented:
Here's the list of filenames and the column I need to search for 2012 in.
filenames-and-years-column.xlsx
0
 
elwayisgodAuthor Commented:
Sample files
Load.zip
0
 
tempor2001Commented:
try this script please. it uses additional file with filenames and columns definition (csv version of filenames-and-years-column.xlsx)
also I put found and not found result files in separate folder to prevent results scanning on second run.
splice.vbs
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
elwayisgodAuthor Commented:
I get an error:


D:\AppFiles\SDS\SDS_Retail_R3\Data\Working\DataFiles\Spliced\VB>cscript splice.v
bs > splice.log
D:\AppFiles\SDS\SDS_Retail_R3\Data\Working\DataFiles\Spliced\VB\splice.vbs(1, 15
) Microsoft VBScript compilation error: Expected end of statement


D:\AppFiles\SDS\SDS_Retail_R3\Data\Working\DataFiles\Spliced\VB>
0
 
elwayisgodAuthor Commented:
Never mind.. hold on a sec
0
 
elwayisgodAuthor Commented:
Perfect.  Both the DOS and VB results are identical.  Thanks much!!!!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now