Located and rebuilt the articles from Rebol Forces. For historical and informational reasons mainly.
Lately at work I have had to do much dissecting and assembling of spreadsheets, as well as cleaning up things accumulated over the years. Learning from previous experience, any time I find any code that could possibly by used in the future, I try to encapsulate it into a module or function. Then I produce a version sanitized of any employer-specific data and put it on a little web site in case it might be of use to others. With today's batch of uploads, I have hit the small milestone of 100 little programs. Most are extremely simple, and extremely specialized. It is sort of like the rebol-dot-org script library but much simpler, maybe more useful to beginners. It does show, like Nick's tutorials show, the value of being able to program one's own computer. The scripts are in the "free stuff" area of http://cobolrebol.com/
It's a QT app which runs a QTextEdit widget as a console and links to the Rebol evaluator, and the C++ API. You can setup watch points to see changes in values in your code for debugging purposes. So, you could run this when debugging your r3/ren-c code.
renc support read-pdf /lines from read-string (use deline/lines instead) /compact from load-dsv /preserve from load-dsv
enzero unarchive archive
split-line bug write-dsv bug load-dsv bug to-string-time now returns "HH:MM:SS" put returns value latin1-to-utf8 handles split strings correctly load-dsv/part/flat formats data correctly
Added /map to sqlcmd Added /flat to load-dsv, load-excel and load-fixed load-fixed now auto detects widths read-string with large files about 10-15x faster load-dsv about 3x faster rows? faster Added /flat to list write-excel now uses archive instead of 7z
build, platform and target moved from global context to settings append-column ascii-file? average-of call-oledb delta load-excel (replaced with oledb) map-source oledb-file? order remove-column split-line sum-of to-rebol-date to-rebol-time
crc32 excel? load-xml (uses unarchive) oledb (refactored from load-excel) settings literal column support to load-dsv, load-xml and munge (e.g. load-dsv/part file [1 "No"]) named column support to load-dsv, load-xml and munge (e.g. munge/where next [["Name" "Age"]["Sam" 50]] [&Age > 30])
munge/update refinement removed (use munge/where blk [row/1: 0]) munge/delete is now the same as munge/delete/where R2 support in archive and unarchive (requires /View) Excel support (using unarchive) added to cols?, fields?, rows? and sheets? replace-deep replaces multiple values in a single pass to-string-date and to-string-time now support Excel XML date (e.g. "41000") and time (e.g. ("0.33") formats list uses settings/console (default TRUE) to control new-line behaviour load-dsv (plus oledb, sqlcmd and sqlite) and load-xml use settings/as-is (default TRUE) to control trim/lines behaviour read-string optimized read-binary lost its /seek refinement added load-dsv/csv
Several parse copy words that escaped to the global context Unarchive bug