DosTips.com

Version 1.1.1 Fixed: ⋅  logic mistake with SQL command file iteration (skipped line 2) Added: ⋅  DESCRIBE TABLE filename.csv ⋅  TRUNCATE TABLE filename.csv The "DESCRIBE TABLE filename" shows how the Jet OLEDB engine interprets your CSV file's data types. It ...

Version 1.1 Added: ⋅  Now accepts either a filename or a SQL string as an argument. If filename, the script reads its SQL commands from the file, one command per line. ⋅  /E switch added. Since the script can handle a file containing multiple SQL commands, having the option eith...

SQL statements can become quite long - perhaps too long to fit on the command line. A nice feature would be an option to read the statement from a file. Even better would be the abililty to include multiple statements in a single script file. Dave Benham Aww, man, let me have a few moments of satis...

Version 1.0.2 Fixed: ⋅  It seems the MS Jet driver has difficulty executing more than one WHERE clause per process thread (possibly only WHERE...LIKE?). Workaround by forking a query into a separate process. As an unintended benefit, this actually sped up execution a little. Cool. ⋅&...

Of course that you are nuts for doing this! The same way than several of use around here, so I think this site is perfect for you! (Welcome here, rojo, I frequently enjoyed your original Batch-file answers at S.O.) Thanks! Likewise! Some time ago I developed FilePointer.exe auxiliary program that a...

Version 1.0.1 Fixed: ⋅  setting var=number sometimes used to set var=column[number].value. Now it doesn't. ⋅  joined table.column arguments for better header generation Added: ⋅  /debug switch to show intermediate sql operations. It's mostly for my own benefit, so I'll...

Pretty sure this is going to come in handy. Can I still do queries if I do not have a header row that defines my delimited fields. I work with a lot of files like this. I know what the fields are already. I do most of my work on our mainframe with sas but this may come in handy for quick reporting ...

I've thought about it, but more in the context of reading csv and importing to MS Access or sqlite. My more immediate goal is to fix the bugs I discovered this afternoon though. They're gnawing at me. Life afk is interfering at the moment though, so it'll have to wait. I hate leaving things broken.....

Sure. Say you own a few rental properties and have some records in CSV format. properties.csv: id,address,city,state,rent,available 1,"123 Smith St","Johnson City",TN,$1200,1 2,"384 Jones Ave",Erwin,TN,$800,1 3,"4250 Harbison Blvd",Jonesborough,TN,$900,0 appli...

CSV.BAT allows interaction with CSV (or TSV or similar) files with SQL syntax. It's not as fast as direct search-and-replace manipulation of the text, but hopefully it will provide enough flexibility to be useful as a utility for other projects and a solution to CSV challenges. Rather than counting ...

Here's the latest version of CSV.BAT : @if (@CodeSection == @Batch) @Then :: ----------------------------------------------------- :: csv.bat v1.1.2 :: csv.bat /? for usage :: :: For updates and discussion, visit :: http://www.dostips.com/forum/viewtopic.php?f=3&t=6184 :: -----------------------...