<font size=2 face="sans-serif">any idea why it is not being picked up
by report writer or indeed why report writer is truncating this string?</font>
<br>
<br><font size=2 face="sans-serif">is there a way of changing </font><font size=2 face="Calibri">0x0A</font><font size=2 face="sans-serif">
to something else - curiously actual "\n" as characters
has the desired effect. (the python script is used to generate an xlsx
spreadsheet) </font>
<br>
<br><font size=2 face="sans-serif">so if I could do something like </font>
<br>
<br><font size=2 face="sans-serif"> .LETdesc2_lcl = replace(</font><font size=2 face="Courier New">prop_desc2</font><font size=2 face="sans-serif">,'</font><font size=2 face="Calibri">0x0A</font><font size=2 face="sans-serif">','\n')
in the rw script or in Sql </font>
<br>
<br>
<br><font size=2 face="sans-serif">I tried </font>
<br><font size=2 face="sans-serif"> .LET desc2_lcl = replace(</font><font size=2 face="Courier New">prop_desc2</font><font size=2 face="sans-serif">,char('</font><font size=2 face="Calibri">0x0A</font><font size=2 face="sans-serif">')
,'\n') </font>
<br>
<br><font size=2 face="sans-serif">but that did not work </font>
<br><font size=2 face="sans-serif">Allan</font>
<br>
<br>
<br>
<br>
<br>
<br><font size=1 color=#5f5f5f face="sans-serif">From:
</font><font size=1 face="sans-serif">Bodo Bergmann <Bodo.Bergmann@actian.com></font>
<br><font size=1 color=#5f5f5f face="sans-serif">To:
</font><font size=1 face="sans-serif">"openroad-users@googlegroups.com"
<openroad-users@googlegroups.com>, "info-ingres@lists.planetingres.org"
<info-ingres@lists.planetingres.org></font>
<br><font size=1 color=#5f5f5f face="sans-serif">Date:
</font><font size=1 face="sans-serif">04/04/2017 16:01</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Subject:
</font><font size=1 face="sans-serif">Re: [Info-ingres]
[openroad-users] formfeed is lost by report writer</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Sent by:
</font><font size=1 face="sans-serif">info-ingres-bounces@lists.planetingres.org</font>
<br>
<hr noshade>
<br>
<br>
<br><font size=2 face="Calibri">The '\n' is a newline character (0x0A)
rather than a formfeed (0x0c).</font>
<p><font size=2 face="Calibri"> </font>
<p><font size=2 face="Calibri">Bodo.</font>
<p><font size=2 face="Calibri"> </font>
<p><font size=2 face="Calibri"><b>From:</b> openroad-users@googlegroups.com
[</font><a href="mailto:openroad-users@googlegroups.com"><font size=2 face="Calibri">mailto:openroad-users@googlegroups.com</font></a><font size=2 face="Calibri">]
<b>On Behalf Of </b>Allan Biggs<b><br>
Sent:</b> Tuesday, April 4, 2017 4:43 PM<b><br>
To:</b> info-ingres@lists.planetingres.org<b><br>
Cc:</b> openroad-users@googlegroups.com<b><br>
Subject:</b> [openroad-users] formfeed is lost by report writer</font>
<p><font size=3> </font>
<p><font size=2 face="Arial">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. </font><font size=3><br>
</font><font size=2 face="Arial"><br>
I have a multiline field in OpenROAD which maintains a table with attributes
which are varchar (250) not null with default</font><font size=3> </font><font size=2 face="Arial"><br>
looking at the table via isql - you can see \n where the form feeds are.</font><font size=3>
<br>
</font><font size=2 face="Arial"><br>
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. </font><font size=3><br>
</font><font size=2 face="Arial"><br>
Prior to introducing the form feeds the other parts of the attribute
were displayed in the output file </font><font size=3><br>
</font><font size=2 face="Arial"><br>
Does anyone have any idea what is going on here?</font><font size=3> <br>
</font><font size=2 face="Arial"><br>
Note - I have removed the 200+ spaces to make this readable </font><font size=3><br>
</font><font size=2 face="Arial"><br>
Thanks</font><font size=3> </font><font size=2 face="Arial"><br>
Allan </font><font size=3><br>
<br>
</font><font size=2 color=blue face="Courier New"><b><br>
this is the result for row in an</b></font><font size=3> </font><font size=2 color=blue face="Courier New"><b><br>
sql query just prior to running report writer </b></font><font size=2 face="Courier New"><br>
| prop_desc2 </font><font size=2 color=#800000 face="Courier New"><i>[lots
of spaces removed]</i></font><font size=2 face="Courier New"> |
test_gp_desc2 </font><font size=2 color=#800000 face="Courier New"><i>[lots
of spaces removed]</i></font><font size=2 face="Courier New">
|</font><font size=3> </font><font size=2 face="Courier New"><br>
|Mean thickness</font><font size=2 color=red face="Courier New">\n</font><font size=2 face="Courier New">per
reel </font><font size=2 color=#800000 face="Courier New"><i>[lots of spaces
removed]</i></font><font size=2 face="Courier New"> | Calculated from</font><font size=2 color=red face="Courier New">\n</font><font size=2 face="Courier New">width/length/
</font><font size=2 color=red face="Courier New">\n</font><font size=2 face="Courier New">weight/density
</font><font size=2 color=#800000 face="Courier New"><i>[lots of spaces
removed]</i></font><font size=2 face="Courier New"> |</font><font size=3>
<br>
</font><font size=2 color=blue face="Courier New"><b><br>
Here are fragments of <br>
report writer script for the same row </b></font><font size=3> </font><font size=2 face="Courier New"><br>
.QUERY <br>
select distinct <br>
disp_kind,</font><font size=3> </font><font size=2 face="Courier New"><br>
prop_desc2 ,</font><font size=3> </font><font size=2 face="Courier New"><br>
test_gp_seq, <br>
n_tests ,</font><font size=3> </font><font size=2 face="Courier New"><br>
min_values_for_std ,</font><font size=3> </font><font size=2 face="Courier New"><br>
test_gp_id ,</font><font size=3> </font><font size=2 face="Courier New"><br>
av ,
</font><font size=3> </font><font size=2 face="Courier New"><br>
sds , <br>
test_gp_desc2,</font><font size=3> </font><font size=2 face="Courier New"><br>
srt_order,</font><font size=3> </font><font size=2 face="Courier New"><br>
etc .......</font><font size=3> <br>
</font><font size=2 face="Courier New"><br>
.FORMAT prop_desc2 (c250)</font><font size=3> </font><font size=2 face="Courier New"><br>
.FORMAT test_gp_desc2 (c250)</font><font size=3> <br>
<br>
</font><font size=2 face="Courier New"><br>
.PRINTLN "worksheet1.write(", $actual_row_number, ","
, 0 (f4), "," , "'" prop_desc2
, "'", " ,fmtwrap)"</font><font size=3>
</font><font size=2 face="Courier New"><br>
.PRINTLN "worksheet1.write(", $actual_row_number, ","
, 1 (f4), "," , "'" test_gp_desc2
, "'", " ,fmtwrap)"</font><font size=3>
<br>
<br>
<br>
</font><font size=2 color=blue face="Courier New"><b><br>
the text file produced </b></font><font size=2 face="Courier New"><br>
worksheet1.write( 25, 0,'Mean
thickness </font><font size=2 color=#800000 face="Courier New"><i>[lots
of spaces removed]</i></font><font size=2 face="Courier New"> '
,fmtwrap)</font><font size=3> </font><font size=2 face="Courier New"><br>
worksheet1.write( 25, 1,'Calculated
from </font><font size=2 color=#800000 face="Courier New"><i>[lots of spaces
removed]</i></font><font size=2 face="Courier New"> '
,fmtwrap)</font><font size=3> <br>
<br>
<br>
<br>
</font>
<p><font size=3><br>
This communication is for use by the intended recipient and contains<br>
information that may be Privileged, confidential or copyrighted under<br>
applicable law. If you are not the intended recipient, you are hereby<br>
formally notified that any use, copying or distribution of this e-mail,<br>
in whole or in part, is strictly prohibited. Please notify the sender by<br>
return e-mail and delete this e-mail from your system. Unless explicitly<br>
and conspicuously designated as "E-Contract Intended", this e-mail
does<br>
not constitute a contract offer, a contract amendment, or an acceptance<br>
of a contract offer. This e-mail does not constitute a consent to the<br>
use of sender's contact information for direct marketing purposes or for<br>
transfers of data to third parties.</font>
<p><font size=3>Francais Deutsch Italiano Espanol Portugues
Japanese Chinese Korean</font>
<p><font size=3> </font><a href=http://www.dupont.com/corp/email_disclaimer.html><font size=3 color=blue><u>http://www.DuPont.com/corp/email_disclaimer.html</u></font></a>
<p><font size=3>-- <br>
You received this message because you are subscribed to the Google Groups
"OpenROAD Users Mailing List" group.<br>
To unsubscribe from this group and stop receiving emails from it, send
an email to </font><a href="mailto:openroad-users+unsubscribe@googlegroups.com"><font size=3 color=blue><u>openroad-users+unsubscribe@googlegroups.com</u></font></a><font size=3>.<br>
To post to this group, send email to </font><a href="mailto:openroad-users@googlegroups.com"><font size=3 color=blue><u>openroad-users@googlegroups.com</u></font></a><font size=3>.<br>
Visit this group at </font><a href="https://groups.google.com/group/openroad-users"><font size=3 color=blue><u>https://groups.google.com/group/openroad-users</u></font></a><font size=3>.<br>
To view this discussion on the web visit </font><a href="https://groups.google.com/d/msgid/openroad-users/OFE457D510.8CE52C6C-ON802580F8.004E0E91-802580F8.0050D7C5%40CDCLN05.LVS.DUPONT.COM?utm_medium=email&utm_source=footer"><font size=3 color=blue><u>https://groups.google.com/d/msgid/openroad-users/OFE457D510.8CE52C6C-ON802580F8.004E0E91-802580F8.0050D7C5%40CDCLN05.LVS.DUPONT.COM</u></font></a><font size=3>.<br>
For more options, visit </font><a href=https://groups.google.com/d/optout><font size=3 color=blue><u>https://groups.google.com/d/optout</u></font></a><font size=3>.</font><tt><font size=2>_______________________________________________<br>
Info-ingres mailing list<br>
Info-ingres@lists.planetingres.org<br>
</font></tt><a href="http://lists.planetingres.org/mailman/listinfo/info-ingres"><tt><font size=2>http://lists.planetingres.org/mailman/listinfo/info-ingres</font></tt></a><tt><font size=2><br>
</font></tt>
<p><p><br>
This communication is for use by the intended recipient and contains<br>
information that may be Privileged, confidential or copyrighted under<br>
applicable law. If you are not the intended recipient, you are hereby<br>
formally notified that any use, copying or distribution of this e-mail,<br>
in whole or in part, is strictly prohibited. Please notify the sender by<br>
return e-mail and delete this e-mail from your system. Unless explicitly<br>
and conspicuously designated as "E-Contract Intended", this e-mail does<br>
not constitute a contract offer, a contract amendment, or an acceptance<br>
of a contract offer. This e-mail does not constitute a consent to the<br>
use of sender's contact information for direct marketing purposes or for<br>
transfers of data to third parties.</p>
<p>Francais Deutsch Italiano Espanol Portugues Japanese Chinese Korean</p>
<p> http://www.DuPont.com/corp/email_disclaimer.html</p>