DosTips.com

Squashman wrote: ↑

27 Nov 2018 14:10

npocmaka_ wrote: ↑

27 Nov 2018 13:42

It would be useful if you can use/create a custom schema file in order to handle other data types than string.

I thought Rojo explained how to do that in this thread because I had asked him about it.

I think he did. viewtopic.php?p=43562#p43562

I had another idea of using System.IO.StreamReader() to read the text file, to avoid loading the entire thing into active memory as the previous solutions all do. With plasma33's example text file, this method is slower than dbenham's JScript hybrid (around 33 seconds for my script, versus around 8 ...

Running test.cmd -name aaa -path bbb I get Name: -name Path: aaa You could simulate "param()" by looping through $argv . <# : batch portion @echo off & setlocal (for %%I in ("%~f0";%*) do @echo(%%~I) | ^ powershell -noprofile "$argv = $input | ?{$_}; iex (${%~f0} | out-...

I find it much easier to let powershell read environment variables in the "env" scope than to try to pass-through script arguments. <# : batch portion @echo off & setlocal set "arg=%~1" powershell -noprofile "iex (${%~f0} | out-string)" goto :EOF : end batch / begin...

My time has come. This is the moment I've been waiting for. My script has become useful to someone. All my toil and strife has not been in vain.

So if my files have no header and are pipe delimited what do I change the Format be? [test.tsv] ColNameHeader=False CharacterSet=1252 Format=?????? Col1=year Integer Col2=make Char Width 255 Col3=model Char Width 255 Col4=color Char Width 255 Col5=worth Text Try this: Format=Delimited(|) I would've...

Still want to get around to trying this out but it is still way over my head on how it all works. Can you post an example of a schema.ini and how I would use that schema.ini to run the bat file? Thanks OK. Basic example. Say you've got a directory containing a file called "test.tsv" with ...

A lambda is a throwaway function. I generally associate lambdas with JavaScript's replace functions. Something like: // This is JavaScript. var count=0 "The quick brown fox".replace(/\w/g, function(m) { count++ }); ... would count the letters in the string. There are 16. You're welcome.

Programmatically pin to taskbar seems relevant. You can use the Pin to Taskbar or Unpin from Taskbar verb through Shell.Application using VBScript or JScript. I'd probably do it as a JScript hybrid.

In Windows XP and earlier, you used to be able to refresh the desktop wallpaper with a rundll32 invocation of a user32.dll function. Not so since Vista. You'll probably have to invoke a PowerShell script. See this page for an example.

Compo wrote:What's wrong with this?

Code: Select all

Echo(%variable%|FindStr "[^0-9]">Nul&&(Echo(Non integer)||(Echo(Integer)

Internal functions are generally faster than executables. Your solution is simpler, but less efficient.

I am trying to use a function to validate numeric input. This method, not in a function, was recently posted as a solution in this forum. Can you tell me why the function below does not communicate the result, which would be FALSE in this example, after the function exits? After the call line, the ...

The simplest test is to append \ and test if it exists: if exist "%%F\" (echo %%F is a folder) else (echo %%F is a file) It's fine for a local drive but this will fail on a network drive IIRC. After testing, it appears that it doesn't fail on a network drive; but it succeeds where it shou...

Great tool :-) Do you have any idea why pointing directly to HKEY_LOCAL_MACHINE\\SOFTWARE\\Wow6432Node\\Microsoft\\Jet\\4.0\\Engines\\Text\\ does not work but it requires 32bit version of cscript? Thanks! I haven't had any practical use for it yet, but maybe it'll save somebody's life some day. The...

Version 1.1.2 Added: ⋅  /S switch to auto generate Schema.ini for all text files in the specified directory If your CSV files are being interpreted incorrectly by the script, generating a Schema.ini and tweaking the column data types might help. See the Schema.ini documentation for suppor...