Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!
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
Style 01 7 75 756 03 01 899833|Fiscal Rcpt Jan|MdseTyp F|2011|2012|6378.04|462.76|26135.8800
splice.vbs
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
Style 01 7 75 756 03 01 899833|Fiscal Rcpt Jan|MdseTyp F|2011|2012|6378.04|462.76|26135.8800
splice.vbs
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Here's the list of filenames and the column I need to search for 2012 in.
filenames-and-years-column.xlsx
filenames-and-years-column.xlsx
try this script please. it uses additional file with filenames and columns definition (csv version of filenames-and-years-column
also I put found and not found result files in separate folder to prevent results scanning on second run.
splice.vbs
also I put found and not found result files in separate folder to prevent results scanning on second run.
splice.vbs
I get an error:
D:\AppFiles\SDS\SDS_Retail
bs > splice.log
D:\AppFiles\SDS\SDS_Retail
) Microsoft VBScript compilation error: Expected end of statement
D:\AppFiles\SDS\SDS_Retail
D:\AppFiles\SDS\SDS_Retail
bs > splice.log
D:\AppFiles\SDS\SDS_Retail
) Microsoft VBScript compilation error: Expected end of statement
D:\AppFiles\SDS\SDS_Retail
Premium Content
You need an Expert Office subscription to comment.Start Free Trial