String Length
Deskin, Bob
Bob.Deskin@Cognos.COM
Tue, 20 Aug 2002 07:16:59 -0400
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C2483B.19A85DD0
Content-Type: text/plain;
charset="iso-8859-1"
You can use the SIZE function. However, if you take the SIZE of a fixed
length datatype item, SIZE simply returns the size of the item. If you want
the length of the string up to the last non-blank character, also use the
TRUNCATE function as in
DEFINE size-of-text INT SIZE 2 = SIZE(TRUNCATE(item))
Bob Deskin
PowerHouse Web Product Manager, Application Development Tools
Cognos Inc. 3755 Riverside Drive, Ottawa ON K1G 4K9 CANADA
bob.deskin@cognos.com (613) 738-1338 ext 7268
-----Original Message-----
From: Ganapathi [mailto:kganapathi@chennai.tcs.co.in]
Sent: August 20, 2002 2:12 AM
To: powerh-l@cube.swau.edu
Cc: Ganapathi
Subject: String Length
Dear sir,
Is there any built-in function to findout the length of a string in QDESIGN
?
Thanks & Regards
Ganapathi
This message may contain privileged and/or confidential information. If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. Thank you.
------_=_NextPart_001_01C2483B.19A85DD0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.00.3502.4373" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D420051411-20082002>You=20
can use the SIZE function. However, if you take the SIZE of a fixed =
length=20
datatype item, SIZE simply returns the size of the item. If you want =
the length=20
of the string up to the last non-blank character, also use the TRUNCATE =
function=20
as in</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D420051411-20082002></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D420051411-20082002>DEFINE=20
size-of-text INT SIZE 2 =3D SIZE(TRUNCATE(item))</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D420051411-20082002></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D420051411-20082002>
<P><FONT face=3DArial size=3D2>Bob=20
Deskin =
=20
</FONT><BR><FONT face=3DArial size=3D2>PowerHouse Web Product =
Manager</FONT><FONT=20
face=3DArial size=3D2>,</FONT> <FONT face=3DArial size=3D2>Application =
Development=20
Tools</FONT> <BR><FONT face=3DArial size=3D2>Cognos Inc.</FONT><FONT =
face=3DArial=20
size=3D2></FONT> <FONT face=3DArial size=3D2>3755 Riverside =
Drive</FONT><FONT=20
face=3DArial size=3D2>,</FONT> <FONT face=3DArial size=3D2>Ottawa ON =
K1G 4K9=20
CANADA</FONT> <BR><FONT face=3DArial =
size=3D2>bob.deskin@cognos.com</FONT><FONT=20
face=3DArial size=3D2></FONT> <FONT face=3DArial size=3D2>(613) =
738-1338 ext</FONT>=20
<FONT face=3DArial size=3D2>7268</FONT> </P></SPAN></FONT></DIV>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
<DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> Ganapathi=20
[mailto:kganapathi@chennai.tcs.co.in]<BR><B>Sent:</B> August 20, 2002 =
2:12=20
AM<BR><B>To:</B> powerh-l@cube.swau.edu<BR><B>Cc:</B>=20
Ganapathi<BR><B>Subject:</B> String Length<BR><BR></DIV></FONT>
<DIV><FONT size=3D2><FONT face=3DArial>Dear sir,</FONT></FONT></DIV>
<DIV><FONT size=3D2><FONT face=3DArial></FONT></FONT> </DIV>
<DIV><FONT size=3D2><FONT face=3DArial>Is there any built-in function =
to findout=20
the length of a string in QDESIGN ?</FONT></FONT></DIV>
<DIV><FONT size=3D2><FONT face=3DArial></FONT></FONT> </DIV>
<DIV><FONT size=3D2><FONT face=3DArial>Thanks & =
Regards</FONT></FONT></DIV>
<DIV><FONT size=3D2><FONT=20
face=3DArial>Ganapathi</FONT></DIV></BLOCKQUOTE></FONT></BODY></HTML>
<BR>
<P><FONT SIZE=3D2 FACE=3D"Arial">This message may contain privileged =
and/or confidential information. If you have received this e-mail in =
error or are not the intended recipient, you may not use, copy, =
disseminate or distribute it; do not open any attachments, delete it =
immediately from your system and notify the sender promptly by e-mail =
that you have done so. Thank you.</FONT></P>
------_=_NextPart_001_01C2483B.19A85DD0--