I received an email with some sales figures in a table. I just pasted it into a new VFP program, added about 6 lines of code (below), then pasted the code from Excel’s new gradient Data Bar feature is cool: you can do it too! After a couple minor adjustments, I had a graphical display of the data indicating some trends that were easy to spot.
TEXT TO cdata noshow
CREATE cursor test (cmonth c(15),sales c(10),units c(20))
APPEND FROM t.txt DELIMITED WITH tab
SELECT cmonth,INT(VAL(CHRTRAN(&cfld,”,”,””))) as &cfld FROM test INTO CURSOR result