Re: Reports 2.5 tab delimited file output?

[Quoted] I found a solution to this problem: First, add a user defined printer [Quoted] code to the printer definition file which will translate to control-I, [Quoted] the ascii tab character. For example:

printer "no_ff"
height 66
width 2000
after page
code "09" control(I) <-- added code 09 to generate ctl-I (tab) [Quoted] linefeed control(J)

Then, instead of selecting all the fields and concatenating them into a [Quoted] single data record, select as individual fields.

SELECT field_1, field_2, field_3, etc.

Then place each field in the character format layout side by side with [Quoted] the "General Layout-Horizontal-Variable" property set, and the "Printer [Quoted] Code-After" property set to &09 for each of the fields (except the last).

Mark

  markha_at_csufresno.edu wrote:
>
> I am creating a file as output from Reports 2.5 for input to another
> product which requires tab delimited fields. I have been unable to get
> the tab character imbedded in the output. My last attempt was to use the
> chr function which should return the binary equivalent for a value. It
> does seem to do this in all other cases, but not for tab. The select
> was coded like:
>
> SELECT field_1 || chr(09) || field_2 || chr(09) || field_3 "data_record"
> FROM ...
>
> the tabs are replaced with a variable number of spaces to move the field
> to column 9, 17, 25, etc. This appears to happen in the server, as
> SQL*Plus and Reports 2.5 are yielding the same result.
>
> Any ideas?
>

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet