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
I will be hosting a Rebol Developers Conference in Philadelphia this summer (July 6th-7th). I've a great location lined up just around the corner from the Independence Mall (across the street from Ben Franklin's Post Office) and have some great talks lined up (more on this to follow--some epic projects: some you'll know about, one or two you won't).
I'll have registration up shortly, for now I've a wee questionnaire to get an idea of what kind of interest there is. Aside from the featured talks, I'd like to now issue a call for participation for anyone that would like to talk about their Rebol, Red or Ren-C projects. We'll have streaming and will record the talks for posterity.
If you're in the northeastern US, Philly is very accessible (great rail/bus access) about 90mins from NYC and DC. If not, it's a culturally rich city that is very much worth a visit even without a Rebol conference as an excuse, and we'll be here for July 4th at the very location where July 4th became a thing. Our hosts will provide co-working space on July 5th for any conference participant arriving from out of town.
Updated web site for the Rebol  developer conference. Includes some info on the talks, speakers and location and a link to the event registration. Be sure to register as soon as you can so I can get a close-to-accurate head count ahead of time.
Also on the registration site, I'm accepting donations to help offset some of the costs (it's unlikely registrations alone will cover everything--I've deliberately kept the registration fee down to encourage wider participation).
At this time, there is help available if accommodation is still needed. Just drop me a line.
Only a week away now, hope to see you there!
A huge thank you to everyone that attended/contributed to Rebol  here in sunny Philadelphia*. It was a blast and there were some monumental presentations. I will update the conference site shortly with links and videos as they become available.
If you did contribute and would attach some links to your talks, please email them to me.
*it is always except for that moment a tornado warning interrupted Ed's talk
I just saw a Rebol conference took place this summer, it's great! Are the videos of the conference available online? I was not able to find them.