HotDocs Tip – Parse City, State, Zip from Address

HotDocsTip_ConvertCSZ_SnipIn our work in HotDocs, we often need to bring in defective and malformed data from databases.  Often the data source contains an address field or fields.  Ideally, it will be formatted with Street, City, State and Zip as separate fields.  However, more often, the data is not properly structured for analysis and usage.  We may get address line 1 and address line 2 or even address line 3.  To put this data into a usable format requires an understanding of text parsing.

With the use of the Custom Functions properties of HotDocs Computations, we have defined a way to parse the Address Line text which is in the [CityName], [StateAbbrev] [ZipCode] format in a line into the 3 separate constituent fields, respectively tmpCity, tmpState, and tmpZip.  We pass a parameter, prmCSZ which contains the address string.  The output sets the tmp fields which can then be used in a dialog script or other computation to set the actual fields you wish to use.

Read more

Spring in the Air

SpringCleaningThe thermostat in our little river hamlet of Cortlandt Manor has hit 75 degrees.  While spring has not yet officially begun, it is just around the corner.  Along with spring come new resolutions.  The first and foremost is to remove the clutter that accumulates of the cold dark winter.   For me, that means several things.

NOTE:  With this post, Seth Rowland returns to the web with an active blog.  I realize the hiatus has been over a year and a half.  I have been very busy, but have neglected the prime imperative of sharing and educating that has been key to the success of my own business venture.  And so, come back, subscribe, even feel free to comment.  I hope to make it worth your while.

Read more

A Solution in Search of a Problem – Paper Software

Paper Software (for the Mac) from Turner (Contracts Made Easy) (www.paper-software.com) is a solution in search of a problem.  On encountering the product at LegalTech New York 2014, I asked myself how this tool would improve either legal document drafting or document analysis.  I was told there was a new “document assembly” tool that work on a Mac.  What I found was fascinating, but really a niche product.

Read more

Surviving the Cold Snap

There are times when it gets REALLY  cold.  Today was one such day.  It seems as if my office overlooking a frozen lake was like the place on left.  The funny thing is that while humans don’t like the cold, computers do, so long as  they are not in a moist environment.  The “cool air” is far preferable to the amount of heat generated by CPU processors, graphic processors, and memory cards.

Read more

Power of HotDocs – Creating a Loan Amortization Table

Yesterday, I took on a  new “challenge” in one of the many commercial lending systems we have been building.  Typically, we attach a Loan Amortization Table supplied by the “bank client” to the loan documentation.

These tables project payments of principal and interest during the term of the loan.  After some research on formulas, review of VBA model code and Excel spreadsheets, I took the challenge. That featured image up top is the result.

Read more

Some CHEAP Gift Ideas

For the past six months, I have been making extensive use of my JAMBOX.  This little “electronic box” connects via Bluetooth to my iPad, iPhone or Android, and even my laptop, and gives room-filling, high fidelity sound.  It does require periodic recharging. And setting it up for Bluetooth connection can be shaky after six months of use.

Further, at over $150 price tag on Amazon for the small version, and $250 for the larger version, it can be a large ticket item.

Read more

Navigating the Cloud – Pace of Innovation

The burst of innovation in law firm practice management is very exciting. It seems as if a new time and billing service is launched every week. Existing cloud vendors announce mind-expanding new features every month. Desktop vendors are busy trying to Cloud-Enable their software or build hooks into the cloud. When Frank Heckman lamented once that annual new releases of software was too fast for a software company to handle, he was wrong. It is in fact too slow.

Read more