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

Wed Apr 5 06:46:59 UTC 2017

Bodo,

update  wavgstdevsorted_w_asd set prop_desc2 = replace ( prop_desc2 , 
X'0a', '\n') ;\p\g

works 

thanks 
Allan 

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

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> 
To:        "openroad-users at googlegroups.com" <
openroad-users at googlegroups.com>, "info-ingres at lists.planetingres.org" <
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 

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] On Behalf Of Allan Biggs
Sent: Tuesday, April 4, 2017 4:43 PM
To: info-ingres at lists.planetingres.org
Cc: 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\n
width/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 
-- 
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.
To post to this group, send email to 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
.
For more options, visit https://groups.google.com/d/optout.
_______________________________________________
Info-ingres mailing list
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.
To post to this group, send email to 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
.
For more options, visit https://groups.google.com/d/optout.
_______________________________________________
Info-ingres mailing list
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20170405/2f0e355a/attachment.html>