[Info-ingres] [openroad-users] formfeed is lost by report writer

Tue Apr 4 15:59:39 UTC 2017

Allan 0x0A is not a string, but a hex value (decimal 10) for the newline character,
therefore you cannot use '0x0A' - which is a 4 character string  (containing the characters '0', 'x', '0' and 'A').
You could try a hex literal constant instead:  X'0a'

Bodo.

From: openroad-users at googlegroups.com [mailto:openroad-users at googlegroups.com] On Behalf Of Allan Biggs
Sent: Tuesday, April 4, 2017 5:37 PM
To: Bodo Bergmann <Bodo.Bergmann at actian.com>
Cc: info-ingres at lists.planetingres.org; info-ingres-bounces at lists.planetingres.org; openroad-users at googlegroups.com
Subject: Re: [Info-ingres] [openroad-users] formfeed is lost by report writer

any idea why it is not being picked up by report writer or indeed why report writer is truncating this string?

is there a way of changing 0x0A to something else - curiously actual  "\n" as characters has the desired effect. (the python script is used to generate an xlsx spreadsheet)

so if I could do something like

 .LETdesc2_lcl = replace(prop_desc2,'0x0A','\n') in the rw script or in Sql

I tried
 .LET   desc2_lcl = replace(prop_desc2,char('0x0A') ,'\n')

but that did not work
Allan

From:        Bodo Bergmann <Bodo.Bergmann at actian.com<mailto:Bodo.Bergmann at actian.com>>
To:        "openroad-users at googlegroups.com<mailto:openroad-users at googlegroups.com>" <openroad-users at googlegroups.com<mailto:openroad-users at googlegroups.com>>, "info-ingres at lists.planetingres.org<mailto:info-ingres at lists.planetingres.org>" <info-ingres at lists.planetingres.org<mailto:info-ingres at lists.planetingres.org>>
Date:        04/04/2017 16:01
Subject:        Re: [Info-ingres] [openroad-users] formfeed is lost by report writer
Sent by:        info-ingres-bounces at lists.planetingres.org<mailto:info-ingres-bounces at lists.planetingres.org>
________________________________

The '\n' is a newline character (0x0A) rather than a formfeed (0x0c).

Bodo.

From: openroad-users at googlegroups.com<mailto:openroad-users at googlegroups.com> [mailto:openroad-users at googlegroups.com] On Behalf Of Allan Biggs
Sent: Tuesday, April 4, 2017 4:43 PM
To: info-ingres at lists.planetingres.org<mailto:info-ingres at lists.planetingres.org>
Cc: openroad-users at googlegroups.com<mailto:openroad-users at googlegroups.com>
Subject: [openroad-users] formfeed is lost by report writer

For this work I am working on a windows 7 laptop with the community edition of ingres installed on it. though the database is on a 10.2 Linux server.

I have a multiline field in OpenROAD which maintains a table with attributes which are varchar (250) not null with default
looking at the table via isql - you can see \n where the form feeds are.

I am running a report writer (.rw) which gives a text file (actually a python script) the"\n"s are somehow truncating the field everything after \n is lost for that field.

Prior to introducing the form feeds  the other parts of the attribute were displayed in the output file

Does anyone have any idea what is going on here?

Note - I have removed the 200+ spaces to make this readable

Thanks
Allan

this is the result for row in an
sql query just prior to running report writer
|    prop_desc2           [lots of spaces removed] |    test_gp_desc2     [lots of spaces removed]                             |
|Mean thickness\nper reel [lots of spaces removed] | Calculated from\nwidth/length/  \nweight/density [lots of spaces removed] |

Here are fragments of
report writer script for the same row
.QUERY
select   distinct
disp_kind,
prop_desc2 ,
test_gp_seq,
n_tests ,
min_values_for_std ,
test_gp_id ,
av         ,
sds        ,
test_gp_desc2,
srt_order,
etc .......

.FORMAT prop_desc2    (c250)
.FORMAT test_gp_desc2 (c250)

.PRINTLN "worksheet1.write(",  $actual_row_number,  "," , 0  (f4),  "," , "'" prop_desc2             , "'", "   ,fmtwrap)"
.PRINTLN "worksheet1.write(",  $actual_row_number,  "," , 1  (f4),  "," , "'" test_gp_desc2      , "'", "       ,fmtwrap)"

the text file produced
worksheet1.write(           25,   0,'Mean thickness  [lots of spaces removed]   '       ,fmtwrap)
worksheet1.write(           25,   1,'Calculated from [lots of spaces removed]   '       ,fmtwrap)

This communication is for use by the intended recipient and contains
information that may be Privileged, confidential or copyrighted under
applicable law. If you are not the intended recipient, you are hereby
formally notified that any use, copying or distribution of this e-mail,
in whole or in part, is strictly prohibited. Please notify the sender by
return e-mail and delete this e-mail from your system. Unless explicitly
and conspicuously designated as "E-Contract Intended", this e-mail does
not constitute a contract offer, a contract amendment, or an acceptance
of a contract offer. This e-mail does not constitute a consent to the
use of sender's contact information for direct marketing purposes or for
transfers of data to third parties.

Francais Deutsch Italiano  Espanol  Portugues  Japanese  Chinese  Korean

          http://www.DuPont.com/corp/email_disclaimer.html<http://www.dupont.com/corp/email_disclaimer.html>

--
You received this message because you are subscribed to the Google Groups "OpenROAD Users Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openroad-users+unsubscribe at googlegroups.com<mailto:openroad-users+unsubscribe at googlegroups.com>.
To post to this group, send email to openroad-users at googlegroups.com<mailto:openroad-users at googlegroups.com>.
Visit this group at https://groups.google.com/group/openroad-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/OFE457D510.8CE52C6C-ON802580F8.004E0E91-802580F8.0050D7C5%40CDCLN05.LVS.DUPONT.COM<https://groups.google.com/d/msgid/openroad-users/OFE457D510.8CE52C6C-ON802580F8.004E0E91-802580F8.0050D7C5%40CDCLN05.LVS.DUPONT.COM?utm_medium=email&utm_source=footer>.
For more options, visit https://groups.google.com/d/optout._______________________________________________
Info-ingres mailing list
Info-ingres at lists.planetingres.org<mailto:Info-ingres at lists.planetingres.org>
http://lists.planetingres.org/mailman/listinfo/info-ingres

This communication is for use by the intended recipient and contains
information that may be Privileged, confidential or copyrighted under
applicable law. If you are not the intended recipient, you are hereby
formally notified that any use, copying or distribution of this e-mail,
in whole or in part, is strictly prohibited. Please notify the sender by
return e-mail and delete this e-mail from your system. Unless explicitly
and conspicuously designated as "E-Contract Intended", this e-mail does
not constitute a contract offer, a contract amendment, or an acceptance
of a contract offer. This e-mail does not constitute a consent to the
use of sender's contact information for direct marketing purposes or for
transfers of data to third parties.

Francais Deutsch Italiano  Espanol  Portugues  Japanese  Chinese  Korean

          http://www.DuPont.com/corp/email_disclaimer.html
--
You received this message because you are subscribed to the Google Groups "OpenROAD Users Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openroad-users+unsubscribe at googlegroups.com<mailto:openroad-users+unsubscribe at googlegroups.com>.
To post to this group, send email to openroad-users at googlegroups.com<mailto:openroad-users at googlegroups.com>.
Visit this group at https://groups.google.com/group/openroad-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/OF1831860C.FFBCFFAC-ON802580F8.00543277-802580F8.0055C706%40CDCLN05.LVS.DUPONT.COM<https://groups.google.com/d/msgid/openroad-users/OF1831860C.FFBCFFAC-ON802580F8.00543277-802580F8.0055C706%40CDCLN05.LVS.DUPONT.COM?utm_medium=email&utm_source=footer>.
For more options, visit https://groups.google.com/d/optout.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20170404/f0e87799/attachment.html>