/z command line question (with an Excel filter)

Get help with installation and running here.

Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators

Post Reply
interceptor3

/z command line question (with an Excel filter)

Post by interceptor3 »

I am having trouble creating a command file using the /z option: I want to do something like this:

/f=ceacaan1.xls ; filter file
ceacaan1.htm ; <wildcard> (filter only to be applied to this file)
/g
/f=noname26.xls ; next filter file
noname26.htm ; next file to be searched & replaced
/g
/f=favimco1ml.xls
favimco1ml.htm
/g
...

to input an Excel search and replace list, open an .htm file and apply the search and replace rules to that particular .htm file, then open the next Excel filter and apply it to the next .htm file. I have 340 Excel filter and 340 .htm files.

It would appear that: 1) may the /f command cannot take an Excel file as input and 2) the <wildcard> cannot be a single file.

Please help me determine if I am using the right approach to apply 340 unique search and replace filters to 340 unique .htm text files. Maybe there is another way (I am not an experienced VBScipt coder).

Many thanks,
-Mark
interceptor3

Alternative /z command line question (with an Excel filter)

Post by interceptor3 »

Well, I decided to do it a different way, without using Excel filters. Just put the filters in the command file directly and run it on the 340 files:

/S=***item0***
/R=afpa
/S=***item1***
/R=110-01
/S=***item2***
/R=110-13
/S=***item3***
/R=110-16
/S=***item4***
/R=110-23
/S=***item5***
/R=110-26
afpa.htm
Post Reply