Please disregard this initial post.
I ended up creating one whole CSV containing the prefix of the file name, and the complete path and file. I then looped through that file and created separate CSV based on the prefix of the file name, which happened to be first value in each line of the...
I need some help in creating separate CSV files based on the contents of a directory.
The CSV would contain the designated substring as one column, and the complete path and filename in a second column. No quotes as text qualifiers.
Assume the folder name = C:\Temp\Images
The content is as...
I am looking for a good utility for printing formatted SQL scripts for documentation purposes. I am currently using SQL2000Print for documenting the dabase objects, etc. However. I need another tool for the scripts themselves.
Any assistance offered would be greatly appreciated.
Thank you!
Thanks to both 'TomThumbKP' and 'tsuji' for your help. I was thinking about using multiple passes to accomplish this. That method works great when cleaning addresses lines, etc.
I certainly appreciate the efforts on both your parts.
Thanks again.
I need some assistance in constructing a RegExp pattern for removing/changing stray quotes within a text file.
My script basically reads a line from a comma-delimited text file (with quotes for text qualifiers). I then want to construct a RegExp pattern to remove.change quotes if they are not...
Spool;
I'm doing the same thing. Here are my suggestions.
1. CleanMgr: Research the "/sageset:n" and "/sagerun:n" arguments, where "n" represents a long integer. These arguments allow you to set a configuration and run it against a drive.
2. ChkDsk: Use this command with the...
I have a failed installation of SQL 6.5 on a Windows 2000 Server box. The "Uninstall" option is no longer available from the CD, and the "setup /t RebuildRegistry = ON" option doesn't appear to work with Windows 2000.
I'd like to repair the install I've got, do a formal "Uninstall", then re-do...
Need some guidance here please.
We have written a scipting utility to change Access database schemas we have deployed in the field. The utility also adds a new custom property to the database, which denotes the scipt name, the date it was run and the success code (i.e., flag).
We know the...
Does anyone know of a script to check for any open files within a given directory? Perhaps an API call is required.
Thanks in advance for any assistance you can offer.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.