Topic: Re: Batch File Processing (1 of 1), Read 70 times
Conf: Wildfile, Other macros
From: Pauli Lindgren
Date: Tuesday, September 03, 2002 04:38 AM

On 8/29/2002 7:59:23 PM, Jay Daves wrote:
> Yes I would like to have a batch
>file that I can schedule to execute vedit to preform the
>deletion of the "" from my files.
>How do I setup the inp file and the vdm file correctly?

If you want just to find all empty strings (two quote characters without anything between them) and then to remove these two characters, you can do the following:

1. Create a Vedit macro clean.vdm that contains one line:

Replace(/""/,//,ALL)

2. Create a bat file, e.g. clean.bat that contains one line:

for %%name in (*.csv) do vpw -q -x clean.vdm %%name


Now, whenever you run clean.bat from DOS prompt, all the empty quotes are removed from all the .csv files in the current directory.

If you want to run the .bat file from Windows icon, you may need to add commands such as

d:
cd \your\directory

at the beginning of the .bat file.

-- Pauli