Re: fold a long line into short lines, how ?

On 13 Apr 1995, Kuo-Chien Kai wrote: > I have a table named my_tab which contains 2 columns: > col1: 30-char long > col2: 120-char long > <*** deleted > Kuo-Chien: Three solutions in brief: 1. Unload Unload data to a file. Use awk to reformat. 2. Write an ace report. 3. (not too sensible, but if you play with it enough, maybe) use the sql built-in strval function, i.e. [n,m], as for example, col2[1,40] col2[41,80] create a virtual column with enough spaces to force column2 down one line. This will probably take some work, and is probably not worth it. Looking at my answer, you see that isql is limited in formatting capability. You were hoping for something better I suppose. Hope this helps or stimulates thought from our colleagues, Yours, Nick ********************************* Nick Nobbe, Library of Congress NLS/BPH mail: nnob@loc.gov *********************************