DosTips.com

Steffen,

Thank you so much for your help. It worked perfectly just how I needed it to!!

I'm not sure if that's possible, or another option would be to extract the "Date Modified" of the file and append it as a new column in the target CSV file. Which I'm also not too sure on where to begin for that.

The script was originally written by a coworker of mine, but I'm assuming that is the line that appends the filename as a new column to the target (completed merged CSV) file. See attached image of how it would look like when I open the CSV file in Excel (confidential information is erased). My goal...

Hi Steffen, I tried the code you have me tried in the nested loop like this, but it returned nothing in my file. Please let me know if I placed it incorrectly. I'm sorry :( for /f "tokens=*" %%G in ('dir "%folder%\%mask%" /a:-d /b') do ( for /f "tokens=2 delims=." %%I in ("%%~nG") do echo %%I for /f...

Sorry, I did find something that was closely related, but I wasn't sure how to incorporate it (if possible) with what I have already. I'm still relatively new in scripting, so please excuse me if confusing any part of it. This script was part of another post that I found while researching. The "set ...

I tried extracting only those characters from the file name, but I also couldn't get it to work. I'm probably doing something wrong

Hello, I receive nightly CSV data in a folder and I merge all the CSV data into one file for upload to another portal. For now, in my script I have it where it also extracts the file and inputs it back into the target file (completed merged copy) as a new column. Instead of the full filename, can I ...