Unprintable characters
Jonas Rosell
jonas.rosell@cefalo.se
Wed, 10 Nov 2004 08:46:50 +0100
This is a multi-part message in MIME format.
------=_NextPart_000_0039_01C4C701.D231CBB0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Hi Joe,
We do like this when adding a carriage return to the end of a file, probably
you could do the same for TAB.
define cr-code integer = 13
define lf-code integer = 10
define cr-char cha*01 = char(cr-code)[2:1]
define lf-char cha*01 =char(lf-code)[2:1]
report xxxxx cr-char lr-char
In your case then
define tab-code integer = 09
define tab-char cha*01 = char(tab-code)[2:1]
report field1 tab-char
Best Regards
Jonas
-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of Joe Schulz
Sent: den 10 november 2004 06:01
To: powerh-l@lists.sowder.com
Subject: Unprintable characters
How do I insert an unprintable character into a QUIZ output file?
Specifically, I'm using QUIZ to extract data into a delimited format and
want to use a TAB delimiter character between fields. How do I insert a
horizontal tab (ASCII Character Decimal: 9, Octal: 011) into the output.
For example:
REPORT FIELD1 + ??? + FIELD2 + ??? + FIELD3
Thanks,
Joe
------=_NextPart_000_0039_01C4C701.D231CBB0
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2800.1476" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D057414007-10112004><FONT face=3DArial color=3D#0000ff =
size=3D2>Hi=20
Joe,</FONT></SPAN></DIV>
<DIV><SPAN class=3D057414007-10112004><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D057414007-10112004><FONT face=3DArial color=3D#0000ff =
size=3D2>We do=20
like this when adding a carriage return to the end of a file, probably =
you could=20
do the same for TAB.</FONT></SPAN></DIV>
<DIV><SPAN class=3D057414007-10112004><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D057414007-10112004><FONT face=3DArial color=3D#0000ff =
size=3D2>define cr-code integer =3D=20
13<BR>define lf-code integer =20
=3D 10<BR>define cr-char cha*01 =3D=20
char(cr-code)[2:1]<BR>define lf-char =
cha*01 =20
=3Dchar(lf-code)[2:1]</FONT></SPAN></DIV>
<DIV><SPAN class=3D057414007-10112004><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D057414007-10112004><FONT face=3DArial color=3D#0000ff =
size=3D2>report=20
xxxxx cr-char lr-char</FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2></FONT> </DIV>
<DIV><SPAN class=3D057414007-10112004></SPAN><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>I<SPAN class=3D057414007-10112004>n your case =
then</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D057414007-10112004></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D057414007-10112004>define=20
tab-code integer =3D 09</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D057414007-10112004>define=20
tab-char cha*01 =3D char(tab-code)[2:1]</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D057414007-10112004></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D057414007-10112004>report=20
field1 tab-char</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D057414007-10112004></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D057414007-10112004>Best=20
Regards</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D057414007-10112004>Jonas</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D057414007-10112004></SPAN> </DIV>
<DIV><BR></DIV></FONT></SPAN>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B>=20
powerh-l-admin@lists.sowder.com =
[mailto:powerh-l-admin@lists.sowder.com]<B>On=20
Behalf Of </B>Joe Schulz<BR><B>Sent:</B> den 10 november 2004=20
06:01<BR><B>To:</B> powerh-l@lists.sowder.com<BR><B>Subject:</B> =
Unprintable=20
characters<BR><BR></FONT></DIV>
<DIV><SPAN class=3D334495504-10112004><FONT face=3DTahoma size=3D2>How =
do I insert=20
an unprintable character into a QUIZ output file? Specifically, =
I'm=20
using QUIZ to extract data into a delimited format and want to use a =
TAB=20
delimiter character between fields. How do I insert a horizontal =
tab=20
(ASCII Character Decimal: 9, Octal: 011) into the =
output.</FONT></SPAN></DIV>
<DIV><SPAN class=3D334495504-10112004><FONT face=3DTahoma=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D334495504-10112004><FONT face=3DTahoma size=3D2>For =
example:</FONT></SPAN></DIV>
<DIV><SPAN class=3D334495504-10112004><FONT face=3DTahoma=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D334495504-10112004><FONT face=3DTahoma=20
size=3D2>REPORT FIELD1 + ??? + FIELD2 + ??? + =
FIELD3</FONT></SPAN></DIV>
<DIV><FONT face=3DTahoma size=3D2></FONT> </DIV>
<DIV align=3Dleft><FONT face=3DTahoma size=3D2>Thanks,</FONT></DIV>
<DIV align=3Dleft><FONT face=3DTahoma size=3D2>Joe</FONT></DIV>
<DIV align=3Dleft><FONT face=3DTahoma=20
size=3D2></FONT> </DIV></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0039_01C4C701.D231CBB0--