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
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".
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.
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.
Sheesh--that's Noreen Redden (too late in the day to proofread successfully).
Thanks Suzy. I will try that and will try not to tell Noreen.
|Powered by Social Strata|