Search found 17 matches
- 21 Oct 2015 06:28
- Forum: DOS Batch Forum
- Topic: Stackoverflow
- Replies: 43
- Views: 31742
Re: Stackoverflow
I got down voted because of my Title! And the hyperlink I used that was fine was all wacky after his "edit". This is the ridiculous bs that happens on SO. http://stackoverflow.com/q/33215467/2282445 I'm pretty sure I did my due diligence. Is that your question Matt? Hmm. no, it's chopping...
- 19 Oct 2015 14:22
- Forum: DOS Batch Forum
- Topic: Stackoverflow
- Replies: 43
- Views: 31742
Re: Stackoverflow
I got down voted because of my Title! And the hyperlink I used that was fine was all wacky after his "edit". This is the ridiculous bs that happens on SO. http://stackoverflow.com/questions/33218246 I'm pretty sure I did my due diligence.
- 05 Oct 2015 07:19
- Forum: DOS Batch Forum
- Topic: List XML files after a certain file
- Replies: 24
- Views: 14829
Re: List XML files after a certain file
Working perfectly now Foxidrive, thanks again!
- 02 Oct 2015 09:11
- Forum: DOS Batch Forum
- Topic: List XML files after a certain file
- Replies: 24
- Views: 14829
Re: List XML files after a certain file
Thanks for your help again Foxidrive. I'm not getting the output I'm expecting.
Here is what I'm getting with either 1 or 2 EOD messages:
Here is what I'm getting with either 1 or 2 EOD messages:
Code: Select all
EODMESS_20151001_1076445661.xml 10/01/2015 05:56 PM
located -1 files between EOD files in total
- 01 Oct 2015 13:38
- Forum: DOS Batch Forum
- Topic: List XML files after a certain file
- Replies: 24
- Views: 14829
Re: List XML files after a certain file
Thanks Foxi! Can I throw a monkey wrench in the works? If 2 Eod files aren't found, I need it to say that. Here is what I was attempting: @echo off set "xmlpath=\\server1\developer\inetpub\Ftproot\XMLs\*.xml" dir /o:-d "%xmlpath%" |find ":" |find /v "\" >"...
- 01 Oct 2015 11:22
- Forum: DOS Batch Forum
- Topic: List XML files after a certain file
- Replies: 24
- Views: 14829
Re: List XML files after a certain file
Hi Foxidrive I would like the last modified date and time after the EODMess file. So the first line and the 2nd to last. EODMESS_20150930_1076295166.xml Date & Time ..... Other files ..... EODMESS_20150930_1076295166.xml Date & Time located 6006 files in total
- 01 Oct 2015 06:42
- Forum: DOS Batch Forum
- Topic: List XML files after a certain file
- Replies: 24
- Views: 14829
Re: List XML files after a certain file
Given this code that Foxidrive helped me with: @echo off set "xmlpath=\\Server1\developer\inetpub\Ftproot\XMLs\*.xml" dir /b /o:-d %xmlpath% >"%temp%\filterEOD.tmp" set "found=" set "files=" setlocal enabledelayedexpansion ( for /f "usebackq delims="...
- 31 Aug 2015 08:08
- Forum: DOS Batch Forum
- Topic: Converting Excel Macro to CSV file with double quotes
- Replies: 13
- Views: 10935
Re: Converting Excel Macro to CSV file with double quotes
Your first 2 questions sound like they would be better done in Excel using VBA. Sure I can write batch code that calls VBScript to do it, but it isn't the best tool for the job. I suggest posting it in the Excel VBA secton of m. Now, to answer your last question, this can be easily done in batch. It...
- 27 Aug 2015 11:20
- Forum: DOS Batch Forum
- Topic: Embedding double quotes in field values of a CSV file
- Replies: 8
- Views: 6217
Re: Embedding double quotes in field values of a CSV file
That was a carryover from code I first started with but figured out a better way to do it.
Thanks for the optimization!
Thanks for the optimization!
- 27 Aug 2015 09:55
- Forum: DOS Batch Forum
- Topic: Embedding double quotes in field values of a CSV file
- Replies: 8
- Views: 6217
Re: Embedding double quotes in field values of a CSV file
Hi Shaswat. Try this:
Code: Select all
@echo off
setlocal enabledelayedexpansion
cd /d %~dp0
for /f "tokens=1,3,4 delims=," %%a in (extract.csv) do (
set rep="%%a",%%b,"%%c"
echo !rep!>>New.Csv
)
- 25 Aug 2015 11:50
- Forum: DOS Batch Forum
- Topic: List XML files after a certain file
- Replies: 24
- Views: 14829
Re: List XML files after a certain file
Thanks Foxi. I have this working perfectly now. You forgot the /a on location and I just used notepad to show the file list as well as sending the number of files there too. Your code is way faster than mine too. It takes less than a second for it to pop up the populated notepad window.
- 25 Aug 2015 08:00
- Forum: DOS Batch Forum
- Topic: List XML files after a certain file
- Replies: 24
- Views: 14829
Re: List XML files after a certain file
I created and run it from my workstation against the server. Since I have read access, I'm able to pushd and popd to get access and have it output to my local workstation. I just can't write a file to the server or my workstation from the server.
- 25 Aug 2015 07:38
- Forum: DOS Batch Forum
- Topic: List XML files after a certain file
- Replies: 24
- Views: 14829
Re: List XML files after a certain file
I can't do it that way. I only have read access on the server. I also can't write back from the server to my workstation I tried that already. I can only run it from my workstation against the server and get the output in the cmd window. I have my buffer size set to 999 and num of buffers set to 999...
- 24 Aug 2015 12:55
- Forum: DOS Batch Forum
- Topic: List XML files after a certain file
- Replies: 24
- Views: 14829
Re: List XML files after a certain file
Here is what I came up with but I think I'm falling prey to the Dir read for large directories. There are 32k files and this takes about 30 seconds to run but the dir is just going to keep growing until the end of the month. I can't write the file out because I only have read access on the server. I...
- 24 Aug 2015 11:20
- Forum: DOS Batch Forum
- Topic: List XML files after a certain file
- Replies: 24
- Views: 14829
Re: List XML files after a certain file
Yes, That is exactly what I'm trying to do.
Thanks for your help Foxi. I appreciate it.
Thanks for your help Foxi. I appreciate it.