DosTips.com

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...

HI Dave - Thanks for this! I'm trying to incorporate the parseCSV with the macro for more than 32 columns on this link: https://www.dostips.com/forum/viewtopic.php?f=3&t=5702&p=59742#p59742 For some reason, it doesn't return anything. Also, is there a way to check a column in X position and if the v...

Hi Folks - I wrote a piece of code to check for string lengths over 300 and trim back down to 300. ::-- Set maximum length of string --:: SET "STRINGLEN=300" SET "TOT_COLS=6" IF EXIST "datafiletemp.csv" DEL /F /Q "datafiletemp.csv" >nul 2>&1 FOR /F "USEBACKQ tokens=1-%TOT_COLS% delims=," %%A IN ( "d...

HI There -

I'm trying to use this script and it works fine on my local machine. But when I promote to my server, I'm getting permission denied on line 318 of FINDREPL. ANy ideas why? I have write access to the directory.

I see you copied in the string length function wrong. Review your other thread and try again. You're missing an entire parameter.

How about you try yourself using one of the many examples already provided to you?

This works, let us know if this meets your need. @echo off setlocal enableExtensions disableDelayedExpansion for /f "skip=1 tokens=1 delims=, " %%a in ('findstr /v /r /c:"^[0-9, ]*," "test.csv"') do ( setlocal enabledelayedexpansion SET "string=%%~a" & CALL :STRLEN result string if "!result!" GTR "6...

Are you using SORT not for sorting, but to get maximum and minimum? And two times ? :shock: Strange thing... Why not keep things simple? Try: @echo off setlocal set /A max=-99999, min=99999 for /F "usebackq tokens=5,6 delims=|" %%a in ("%%~F") do ( if %%a gtr !max! set "max=%%a" if %%a lss !min! se...

Thank you! Let me play around with this and see if I can get it to work. Ultimately, I need MIN and MAX, I can adjust and see what it renders.

Thanks!

HI Antonio -


Hmmm - I see and now understand. What would be my path forward to overcome this hurdle? I tried to strip out just that column but no luck. Can this still even be done?

HI Folks - For some reason, the SORT function is not working as I would expect. I am sorting the 5th column which has values from 1 through 12. However, when I do SORT /R it's saying the max is9, not 12. Here is my code: ( FOR %%F IN ("!DATAFILENAME!") DO ( REM Sort PERIOD Column in reverse order to...

If i understand your code and task right, then just add that echo before the pause command (and put an goto :eof behind pause to not falsely entering the :process part of your batch). echo(Your choice is: !$_%SELECTION%! pause goto :eof penpen Hi PenPen - That worked perfectly, thank you! I do have...

In doing some research, I came up with this approach which get's me 90% there: :SELECT_BACKUP SET "DOTS=..." FOR %%A IN ("Daily" "Weekly" "Monthly" "Yearly") DO ( FOR /F "delims=" %%a IN ('DIR /S /B "%BACKUPPATH%%%A"') DO ( CALL :PROCESS "%%~a" ) ) :REPEAT CLS FOR /l %%A IN (1,1,%ZIP%) DO ( IF %%A l...

Hi Folks - I have a need to create a script that will display the folder contents from (4) different data backup folders I have. At most, there would only be 44 data files to choose from. I want the script to essentially cycle through each backup folder and display the content (with data modified) b...

Thank you, will do that!