DosTips.com

How about left, right, up, down, home, end, del keys, etc?

I vaguely remember someone bringing up this issue but my search failed

So anyway I wish to display certain statements if the script is being run from the command line and not display the statements if it is being called by another script.

TipMark, Assuming you wish to run some batch code and then, when finished start a specific excel spreadsheet and have the batch window closed with the excel window 'on top' ?? You could try this: RunMyBatchThenOpenMyExcelFile.bat (make a shortcut to this file and set to run minimized under shortcut ...

AiroNG

I apologize for not recognizing the variables in DOS related to regional and language settings. I am usually pretty happy getting something to work in one version, mine.

Carl

AiroNG

My time is format h:mm:ss.hs yours has a comma h:mm:ss,hs
so add a comma to the delimeters in this for loop in the delay routine:


Then it should work. I have only tested on Win7.

SpinSpell.bat ["Message goes here"] [spincount] [spindelay] @ECHO OFF SETLOCAL ENABLEDELAYEDEXPANSION for /f %%a in ('"prompt $H&for %%b in (1) do rem"') do set "$BS=%%a" SET /A SpinCount=7,MaxSpinCount=30,Spin_Delay=4,ctr=0 SET "_MSG=ÛÛÛÛÛÛÛÛÛÛÛÛÛ" IF NOT...

That would be cool, so sample csv file to sort by date, most recent year on top: Sample CSV File Title line FRUIT,Dish,Date submitted,item apple,taco,12/31/2000,bus ticket banana,fruit pie,3/17/1958,table orange,julius,1/5/1999,stool pea pod,stew,04/9/2014,glider key lime,pie,12/1/2000,ladder Is the...

It would be nice to have a date option so that date fields in the format: MM/DD/YYYY or m/d/y could be sorted by year month day? Just a suggestion. I currently have to write to a new file after converting dates to YYYYMMDD, run the sort with the date in the first position, then convert the dates bac...

Here is an example of how to handle switches that may require a following switch or argument Attn to: call :parse %* and %AndShift% toggle and calling :labels in the parse routine This is a Choice replacement routine for XP that handles Win 7-8 and Vista formats as well: @echo off&goto :main :Ch...

Hybrid batch/jscript:

viewtopic.php?f=3&t=4628&p=33475#p33475

Last post
XLS2CSV "D:\XLpath\my file.xlsx" "D:\CSVfiles\my file.csv" /S=/t

Converts xlsx to tab delimited txt file. I don't think there is a pure batch solution.

Here is a Jscript hybrid version that does not need to write a separate VBS More documentation and error checking Update: Tested on Win7 and XP More error checking Still needs Excel though @if (@X)==(@Y) @end /* Harmless hybrid line that begins a JScript comment ::**************** Documentation ****...

You could try SETX

type SETX -I @ command prompt for examples
It may not work if script is not run in admin mode depending on win version

problems with ...'s

C:\>set input=111111111111??

C:\>replvar input output "..." "ttt"

C:\>set output
output=tttttttttttt??

C:\>replvar input output "222" "ttt"

C:\>set output
output=111111111111??

This is the workaround I use in Win7 and does not require writing or reading from a file. Set/p will display backspaces. The :Setup_etc function defines max line width. The :CR function accepts a number to move cursor left. It is also very useful to move the cursor back just a specified number of ch...

After a little more research.... Prior to Pope Gregory's new Calendar that we now use the Julian Calendar was in force. This calendar had leap years for every year divisible by 4 with no remainder. This led to a 10 day difference in the spring equinox from where the earth was actually in position wi...