Search found 17 matches

by MattW76
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...
by MattW76
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.
by MattW76
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!
by MattW76
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:

Code: Select all

EODMESS_20151001_1076445661.xml 10/01/2015 05:56 PM

located -1 files between EOD files in total
by MattW76
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 "\" >"...
by MattW76
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
by MattW76
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="...
by MattW76
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...
by MattW76
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!
by MattW76
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
)
by MattW76
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.
by MattW76
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.
by MattW76
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...
by MattW76
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...
by MattW76
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.