Reports 2.5 tab delimited file output?
From: <markha_at_csufresno.edu>
Date: 1997/05/27
Message-ID: <864760218.32277_at_dejanews.com>#1/1
Date: 1997/05/27
Message-ID: <864760218.32277_at_dejanews.com>#1/1
[Quoted] 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?
Thanks, Mark
-------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to UsenetReceived on Tue May 27 1997 - 00:00:00 CEST