April 13, 2004, 06:02 PM<Vipul>
multi-line column display-pls help
I need to divide a 255 char long free format data field into multiple parts (which are delimited by /) and show it as multiple lines in a column on a tabular report some thing like this:
Dollar Amt Tran Details
April 13, 2004, 07:19 PMsuzy_smith
You will probably be able to use the "MacGyver Technique" to get what you want.
Essentially, you can create as many records as you want from a single record in the file. Each new "record" in the file would be the text that is enclosed between the / characters that you mention. Of course, you will need code to pick out the text between each group and connect it to the "counter". http://techsupport.informationbuilders.com/tech/cof/cof_tcn_m00.html
There may be other references to MacGyver on IBI's search site, but this one (from Noreen Redded, one of the FocWizards) is pretty straightforward.
April 13, 2004, 07:22 PMsuzy_smith
Forgot to mention--you would HOLD these new "records" in a HOLD file and then TABLE from the HOLD file instead of the original file.
April 13, 2004, 07:24 PMsuzy_smith
Sheesh--that's Noreen Redden (too late in the day to proofread successfully).
April 13, 2004, 07:39 PM<Vipul>
Thanks Suzy. I will try that and will try not to tell Noreen.