MS Excel question

[JohnB 255]

For all you MS Office genius types...Is there a way to mass delete the contents of the csv files without opening each and every one? I have over 50 of them and with all the testing I am running, not all of them get content posted to them, so it's a royal pain in the a$$ to go through each and every one! Thanks.

 

John

[alcr 135]

Make them fresh in another folder, and have them empty, and each time you want to overwrite all of them. Just replace them with the fresh ones.

[JohnB 255]

I love being around people smarter than me!http://ubotstudio.com/forum/public/style_emoticons/default/rolleyes.gif Thanks.

[TommyTx 5]

To expand your knowledge of the dark days you can also..

Type the following into a .txt file and name it mydelete.bat

 

delete *.csv

 

or if the csv is in the directory \mycsvstuff\ then

 

delete mycsvstuff\*.csv

 

simply save that one liner as mydelete.bat or any other .bat name and double click it and whiff.. all gone..

 

and if you want to play with deleting them from the ubot interface... just call Shell for the mydelete.bat file.

 

Shell will fire off the bat file... like a big dog...

 

while you are are at it do you want a list of all the files in your directory..

put this in a text file and call it mydir.bat

 

dir

that will list all to the screen..

\if you want the directory in a text file use

 

dir > mydirlist.txt

 

and if you want just the .jpg files from the direcitory in a text file..

 

dir *.jpg > mydirofjpg.txt

 

I know.. I am showing my age now... but its really fast and simple...

[JohnB 255]

To expand your knowledge of the dark days you can also..

Type the following into a .txt file and name it mydelete.bat

 

delete *.csv

 

or if the csv is in the directory \mycsvstuff\ then

 

delete mycsvstuff\*.csv

 

simply save that one liner as mydelete.bat or any other .bat name and double click it and whiff.. all gone..

 

and if you want to play with deleting them from the ubot interface... just call Shell for the mydelete.bat file.

 

Shell will fire off the bat file... like a big dog...

 

while you are are at it do you want a list of all the files in your directory..

put this in a text file and call it mydir.bat

 

dir

that will list all to the screen..

\if you want the directory in a text file use

 

dir > mydirlist.txt

 

and if you want just the .jpg files from the direcitory in a text file..

 

dir *.jpg > mydirofjpg.txt

 

I know.. I am showing my age now... but its really fast and simple...

 

 

 

That is just plain old...SWEEEEEEEEEEEEEEEET!!!!!!!!!!!!!!!!!!!!!!!

 

I likes it!

 

Thank you.

 

John

 

 

[TommyTx 5]

Just be very careful with it.. its call DOS and the D is for dangerous..

For example forgetting to put the *.csv will delete the entire directory in a flash..

Actually I am wrong... it takes a delete *.* to get the entire directory.. so maybe its not as dangerous as I suggested..

Now that I think about it.. maybe D is for the dark ages as that is how long DOS has been around..

Actually some of the new fangled puters won't run dos..

[TommyTx 5]

For anyone interested in learning more about DOS.. http://www.computerhope.com/msdos.htm

there is a million pages out there in google.. just one of a ton above... it might help you do something you might not otherwise be able to do and since the commands will all be in .bat file, UBOT can run them via the shell command. I occasionally will use a .bat command when in a hurry to do something quick and do not have time to program it..