Hi, I have been passed a csv file which is just a lod of numbers with commas between then e.g. 1,2,3,4,5,6 etc. There are no crlf's after the commas so I can't import this into excel or a database to further process. Does anyone know how I can process this file using either batch file or VBA to insert a crlf after each comma? Than...
Related: How to list the elements of the path in a batch file? How does FOR work? How would you write a batch file or CMD file to remove an element from the path? It should handle gracefully: differences in case shortnames and long names I've done this using tr.exe but it's slow and complicated and uses temporary files, which mak...
How to extract just the filename (no extension) from %1 ? ...
Here is the snippet. %%X is the source path. I want to replace the source path with destination path or just remove the source path. %_DEST%\%%X is not working in this snippet... where it checks to see if the destination file already exists. What is the proper way to check to see if the destination file exists? call :LOGMSG Copying ne...
Hi, I have a database with a Unique key on the the columns ParentRef and SortIndex. In LINQ, I want to switch two SortIndex values. I want to do this in one transaction so there can be multiple users at once. How do I, with LINQ, switch the values in one go, so my Unique key does not be violated? var dc = new MyDataContext(); ...
I have a bunch of MP3 files split up into artist\album, and I want to move these all into a single directory, and get rid of the directory itself, using a windows batch file (hence the tags) ...
How do I in a batch script find the full path to application XYZ if it is installed Clarifications: The application is not in the PATH All I have is it's name in this case "ISTool.exe" and I would like to get C:\Program\ISTool\ISTool.exe ...
I'm trying to do some things during the pre-build phase of a visual studio project. Specifically, I'm trying to execute some commands on all *.resx files within the project. Here is what I have but it doesn't work when the files/directory path have a space in them. How do I get around these spaces? for /f %%a in ('dir /B /S *.resx') ...
I need to call a webservice to validate some data. There is web service task in the control flow but I need to validate during the data flow. Also, the web service supports single or batch validations so it would be nice to batch a 100 items for validation at a time. Is it best to just code all this up in a script component? ...
I'm trying to write a little php to update an svn repo on a server running xampplite under windows. (This is a development server, not a production one.) Here's my php: <?php passthru("update.bat"); // I also tried exec() & putting the svn command in directly ?> update.bat is sitting in the same folder as the php script Here's the ...
I am using rake to build my project and I have a build.bat file similar to this: @echo off cls rake When I double click on build.bat the dos window pops up and shows all the progress but closes itself when the task is finished. Is there way to do a Console.ReadLine so that user can get a chance to see the log? Thanks. Updated: I've...
Our SQL Server 2000 instance hosts several databases which are all similar, one for each of our client. When comes the time to update them all, we use Red Gate SQL Compare to generate a migration script between the development database and a copy of the current state DB of all the clients database. SQL Compare generates a script which i...
Sometimes a network drive that is already mapped to a drive letter because "disconnected". Using the normal Windows functions to access files / folders on that drive fail. As soon as the user manually clicks on that drive it the Windows Explorer dialog, it's magically repaired. Since my program is a batch program I'd like to start this ...
Duplicate data removal using Perl called within via a batch file within Windows A DOS window in Windows called via a batch file. A batch file calls the Perl script which carries out the actions. I have the batch file. The code script I have works duplicate data is removal so long as the data file is not too big. The problem that requires...
I'm trying to create a right-click context menu command for compressing JavaScript files with YUI compressor. My ultimate goal is to try to get this to run on a context menu: java.exe -jar yuicompressor-2.4.2.jar -o <filename>.min.js <filename>.js I know I can use the variable %1 to reference the file name being opened. I can't figure...
I need to remove system variables from client workstation and my clients are 500+ so I want to provide batch file to user to run himself to delete the system variables. ...
I am actually pretty new to this batch file thing. I know it's important to know at least the basic commands. Could somebody help me figure out how to do the following? Zipping a specified folder. Move the folder to another place. When zipping it, the zip file name will be the current date and if there is another zipped file with the ...
Hello MY PURPOSE: i want to make a c++ program that could use dos commands. OPTION: i can make a batch file and put into it the dos commands. but how to use this file from c++ program...? ...
I have an msi installer that needs to call a few batch files to finish the install procedure. The batch file copies extra files from the installer to a few directories and then modifies permissions on several of those directories. We want to continue using the batch files because there is not a lot of time left in our development schedul...
I have a script which finds specific installed software but I am having trouble also getting the software's version. For example, say I am getting a list of all Microsoft software installed. Here is what I have thus far: echo software installed > software_list.txt echo ================= >>software_list.txt reg export HKEY_LOCAL_MACHINE\...