DosTips.com

HI Dave -

As usual, thank you so much!!! That worked like an absolute charm!!!!

Thank you and have a great weekend!

HI Folks - I have a massive data file (600K rows) that I need to "clean". The source team where I get the file from is pushing back on doing this clean up from their end so I need to build a solution on my end before I import the file into our financial application. There are TONS of rows that can b...

Hi PenPen -

When I echo the error, it says "Object Error", but nothing else.

You're able to get the file to download?

Hi Penpen -

Changing to "3" worked and the link is found. But I'm getting an error on the download and can't figure out why.

HI Folks - I have the following jscript (that you guys helped me with last year) to download a zip file from the Web. The script stopped working recently and I believe it's due to the format of the Webpage. @if (@a)==(@b) @end /* Batch part: @ECHO off &SETlocal ::-- Download Link --:: CSCRIPT //nolo...

Thank you, PenPen!!! That worked like a charm!! Stupid oversight on my part, I know it was real simple.

Thank you, again!

Hi Folks - I"m trying to pipe the results of a text file to a FIND command to return the found string. I have this code but it's returning everything after the second delim, regarding if its the correct string I'm passing in as the search mask. Any idea? FOR %%A IN ( "StartMonth" ) DO ( FOR /F "toke...

Hi Folks - I have a situation where I need to do some string manipulation. Here it my code: SET "CLOUD_URL=https://planning2-z558000.pbcs.us2.oraclecloud.com" ECHO("%CLOUD_URL:~16,1%"|FINDSTR "^[\"][-][1-9][0-9]*[\"]$ ^[\"][1-9][0-9]*[\"]$ ^[\"]0[\"]$">nul && SET "NUM=%CLOUD_URL:~16,1%"||SET "NUM=" ...

Hi Folks - I have a simple routine that sends an email via PowerShell. However, I ONLY want to redirect if and error occurs. However, when I use this syntax, it's still creating a blank file: POWERSHELL -ExecutionPolicy ByPass -file "Email_Utility.ps1" ^ "%EMAIL_SERVERzz%" ^ "%EMAIL_FROM%" ^ "%EMAIL...

Thank you, all!!

I reallly Aacini's and Dave's solutions and I am going to leverage both. The file to scan will only be about 200 lines max, give or take a few.

Thank you again and I hope everyone is healthy!

Thank you Hackadoo.

Unfortunately, I don't think it's fail proof. if I add this line to the file:

outbox/logs/DIM_BPMC_PLN - Account_2082.log

It doesn't return it. Furthermore, if I add "7898574" to a file name, it doesn't pull that either.

outbox/logs/DIM_BPMC_PLN - Account_7898574.log

Hello Folks - I have a output file that I need to parse. The output file consists of this: outbox/logs/DIM_BPMC_PLN - Account_292.log outbox/logs/DIM_BPMC_PLN - Account_287.log outbox/logs/DIM_BPMC_PLN - Account_285.log outbox/logs/DIM_BPMC_PLN - Account_284.log outbox/logs/Account Reconciliation Ma...

wow!!!! THat was easy enough.

Thank you Dave, I really appreciate it!!!

Hi Folks - I have the following data file (sample) that is created by another team and they are unwilling to work with me to clean up their process. Therefore, I need to handle cleaning up the file on my end: E01,S00000,1040-00,2019,"","","","","","","","","","","","" E01,S00000,1100-00,2019,267171....

Dave - I ended up with VBS. What I tried to do is spool all the strings greater than 300 to a temp file and then use JSCRIPT to do a find and replace on the original file, however that was taking a very long time to complete. The file is 105 columns X 47k rows. strTrimFile = "Trim_List_" & Year(Date...