This post was contributed by a community member. The views expressed here are the author's own.

Community Corner

QBASIC Program to translate public treasury report data

The purpose of this program is to help failing cities get back on their feet.  This is a QBASIC program that translates data.  It finds the delimiter, in this case a comma, that falls between entries in the format "XXX, Inc. $9,999.99, ZQZ corp, $555.55".  A problem is that there is a comma in the first company's name.  The solution is to search for a period followed by 2 digits then a comma.  When that pattern is found, use the left part of the string preceding the comma to separate out each Accounts Payable and its $ amount entry.  After all the entries containing the Accounts Payable and the dollar amount spent on it are split apart, we can move on to splitting the company name (Accounts Payable) from the amount spent.  Google QBASIC, install it, retype what's in the JPEG, and proceed from there.  An example is available under the Speak Out Treasury Report Test... below.

We’ve removed the ability to reply as we work to make improvements. Learn more here

The views expressed in this post are the author's own. Want to post on Patch?