Focal Point
multi-line column display-pls help

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5961077331

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
$10.00 Detail1
Detail2
Detali3
$20.21 Detail1
Detail2
$30.03 Detail1
Detail2

Thanks,
Vipul Gupta Confused
April 13, 2004, 07:19 PM
suzy_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 PM
suzy_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 PM
suzy_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.
Vipul