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
April 13, 2004, 07:19 PM
suzy_smithYou 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_smithForgot 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_smithSheesh--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