Yet another quiz question
Maloney, Charlie
Charlie.Maloney@Cognos.com
Tue, 24 Aug 2004 18:17:10 -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_01C48A28.1A115CBA
Content-Type: text/plain
Hello Kristina;
You can use PowerHouse 8.41.D for Windows (NT/XP/2000/2003) for direct
access to Progress databases through the Progress ODBC driver.
Rgds,
charles w. maloney | senior account manager | cognos corporation |
application development tools
15 wayside road | burlington, ma 01803
cell: 781 367 6749 | office: 781 313 2305 | fax: 781 345 3091
Productivity Never Goes Out of Style:
<http://powerhouse.cognos.com/> http://powerhouse.cognos.com
ReportNet Demo:
http://www.cognos.com/products/demos/reportnet/
<http://www.cognos.com/products/demos/reportnet/>
_____
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Kristina Carlton
Sent: Tuesday, August 24, 2004 5:39 PM
To: 'powerh-l@lists.sowder.com'
Subject: Yet another quiz question
I am running several extracts and outputting the data into a " delimited
file. The plan is to upload this data into a Progress database and a double
quote is the only delimiter I can use. The problem is that some of our
character fields have a double quote within the data (which shouldn't be
there) and I need to parse through each text field, see if it contains any
double quotes, and replace each with a space.
Is that even possible in Quiz? I know how to do it in SQL or Progress, but
don't even know where to begin in Quiz.
Thanks,
-Kristina
Ext. 2459
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_01C48A28.1A115CBA
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns=3D"http://www.w3.org/TR/REC-html40" xmlns:o =3D=20
"urn:schemas-microsoft-com:office:office" xmlns:w =3D=20
"urn:schemas-microsoft-com:office:word"><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUS-ASCII">
<META content=3DWord.Document name=3DProgId>
<META content=3D"MSHTML 6.00.2800.1458" name=3DGENERATOR>
<META content=3D"Microsoft Word 9" name=3DOriginator><LINK=20
href=3D"cid:filelist.xml@01C489F8.CAEA8B80" rel=3DFile-List><!--[if gte =
mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:EnvelopeVis/>
<w:DrawingGridHorizontalSpacing>2.85 =
pt</w:DrawingGridHorizontalSpacing>
=
<w:DisplayVerticalDrawingGridEvery>2</w:DisplayVerticalDrawingGridEvery>=
</w:WordDocument>
</xml><![endif]-->
<STYLE>@font-face {
font-family: Century Gothic;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.0in 1.0in 1.0in; =
mso-header-margin: .5in; mso-footer-margin: .5in; mso-paper-source: 0; =
}
P.MsoNormal {
FONT-SIZE: 9pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Century Gothic"; =
mso-bidi-font-size: 12.0pt; mso-style-parent: ""; mso-pagination: =
widow-orphan; mso-fareast-font-family: "Times New Roman"; =
mso-bidi-font-family: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 9pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Century Gothic"; =
mso-bidi-font-size: 12.0pt; mso-style-parent: ""; mso-pagination: =
widow-orphan; mso-fareast-font-family: "Times New Roman"; =
mso-bidi-font-family: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 9pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Century Gothic"; =
mso-bidi-font-size: 12.0pt; mso-style-parent: ""; mso-pagination: =
widow-orphan; mso-fareast-font-family: "Times New Roman"; =
mso-bidi-font-family: "Times New Roman"
}
P.MsoAutoSig {
FONT-SIZE: 9pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Century Gothic"; =
mso-bidi-font-size: 12.0pt; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: =
"Times New Roman"
}
LI.MsoAutoSig {
FONT-SIZE: 9pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Century Gothic"; =
mso-bidi-font-size: 12.0pt; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: =
"Times New Roman"
}
DIV.MsoAutoSig {
FONT-SIZE: 9pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Century Gothic"; =
mso-bidi-font-size: 12.0pt; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: =
"Times New Roman"
}
SPAN.EmailStyle15 {
COLOR: #333399; mso-bidi-font-family: Arial; mso-style-type: =
personal-compose; mso-ansi-font-size: 10.0pt; mso-ascii-font-family: =
"Century Gothic"; mso-hansi-font-family: "Century Gothic"
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=3DEN-US style=3D"tab-interval: .5in">
<DIV dir=3Dltr align=3Dleft>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D787524621-24082004><FONT =
face=3DArial><FONT=20
color=3D#0000ff><FONT size=3D2><SPAN class=3D179431322-24082004>Hello=20
</SPAN>Kristina;</FONT></FONT></FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D787524621-24082004><FONT =
face=3DArial=20
color=3D#0000ff size=3D2></FONT></SPAN> </DIV>
<DIV dir=3Dltr align=3Dleft><FONT face=3DArial><FONT =
color=3D#0000ff><FONT size=3D2><SPAN=20
class=3D787524621-24082004><SPAN class=3D179431322-24082004>You can use =
</SPAN></SPAN><SPAN class=3D787524621-24082004>PowerHouse 8.41.D for =
Windows<SPAN=20
class=3D179431322-24082004> (</SPAN>NT/XP/2000/2003<SPAN=20
class=3D179431322-24082004>)</SPAN> for direct access to Progress=20
databases <SPAN class=3D179431322-24082004>through =
the</SPAN> Progress=20
ODBC driver.<SPAN class=3D179431322-24082004> =20
</SPAN></SPAN></FONT></FONT></FONT></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D787524621-24082004><FONT =
face=3DArial=20
color=3D#0000ff size=3D2></FONT></SPAN> </DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D787524621-24082004><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>Rgds,</FONT></SPAN></DIV></DIV>
<DIV><FONT face=3DVerdana size=3D2></FONT> </DIV>
<DIV><FONT face=3DVerdana size=3D2>charles w. maloney | senior =
account manager=20
| cognos corporation | application development tools</FONT><BR><FONT=20
face=3DVerdana size=3D2>15 wayside road | burlington, ma =
01803</FONT><BR><FONT=20
face=3DVerdana size=3D2>cell: 781 367 6749 | office: 781 313 =
2305 |=20
fax: 781 345 3091</FONT></DIV>
<DIV align=3Dleft>
<P align=3Dleft><BR><FONT face=3DArial size=3D2><STRONG><FONT =
face=3DTahoma=20
size=3D3>Productivity Never Goes Out of Style:</FONT></STRONG><BR><A=20
href=3D"http://powerhouse.cognos.com/"><FONT=20
face=3DTahoma>http://powerhouse.cognos.com</FONT></A></FONT></P>
<P align=3Dleft><B><FONT face=3DTahoma>ReportNet Demo:</FONT></B> =
<BR><FONT=20
face=3DTahoma color=3D#000080 size=3D2><A=20
title=3Dhttp://www.cognos.com/products/demos/reportnet/=20
href=3D"http://www.cognos.com/products/demos/reportnet/"=20
target=3D_blank>http://www.cognos.com/products/demos/reportnet/</A></FON=
T> </P>
<P> </P></DIV>
<DIV> </DIV><BR>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr align=3Dleft>
<HR tabIndex=3D-1>
<FONT face=3DTahoma size=3D2><B>From:</B> =
powerh-l-admin@lists.sowder.com=20
[mailto:powerh-l-admin@lists.sowder.com] <B>On Behalf Of </B>Kristina=20
Carlton<BR><B>Sent:</B> Tuesday, August 24, 2004 5:39 PM<BR><B>To:</B>=20
'powerh-l@lists.sowder.com'<BR><B>Subject:</B> Yet another quiz=20
question<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=3DSection1>
<P class=3DMsoNormal><SPAN class=3DEmailStyle15><FONT face=3D"Century =
Gothic"=20
color=3D#333399 size=3D2><SPAN style=3D"FONT-SIZE: 10pt; =
mso-bidi-font-size: 12.0pt">I=20
am running several extracts and outputting the data into a “ =
delimited file. The=20
plan is to upload this data into a Progress database and a double quote =
is the=20
only delimiter I can use. The problem is that some of our character =
fields have=20
a double quote within the data (which shouldn’t be there) and I =
need to parse=20
through each text field, see if it contains any double quotes, and =
replace each=20
with a space. <o:p></o:p></SPAN></FONT></SPAN></P>
<P class=3DMsoNormal><SPAN class=3DEmailStyle15><FONT face=3D"Century =
Gothic"=20
color=3D#333399 size=3D2><SPAN style=3D"FONT-SIZE: 10pt; =
mso-bidi-font-size: 12.0pt"><![if =
!supportEmptyParas]><![endif]> <o:p></o:p></SPAN></FONT></SPAN></P>=
<P class=3DMsoNormal><SPAN class=3DEmailStyle15><FONT face=3D"Century =
Gothic"=20
color=3D#333399 size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">Is that even =
possible in=20
Quiz? I know how to do it in SQL or Progress, but don’t even know =
where to begin=20
in Quiz.<o:p></o:p></SPAN></FONT></SPAN></P>
<P class=3DMsoNormal><SPAN class=3DEmailStyle15><FONT face=3D"Century =
Gothic"=20
color=3D#333399 size=3D2><SPAN style=3D"FONT-SIZE: 10pt; =
mso-bidi-font-size: 12.0pt"><![if =
!supportEmptyParas]><![endif]> <o:p></o:p></SPAN></FONT></SPAN></P>=
<P class=3DMsoNormal><SPAN class=3DEmailStyle15><FONT face=3D"Century =
Gothic"=20
color=3D#333399 size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: =
12.0pt">Thanks,<o:p></o:p></SPAN></FONT></SPAN></P>
<P class=3DMsoNormal><!--[if supportFields]><font =
color=3D"#333399"><span=20
style=3D'color:#333399'><span =
style=3D'mso-element:field-begin'></span><span=20
style=3D"mso-spacerun: yes"> </span>AUTOTEXTLIST \s "E-mail=20
Signature" <span =
style=3D'mso-element:field-separator'></span></span></font><![endif]--><=
SPAN=20
class=3DEmailStyle15><FONT color=3D#333399 size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: =
12.0pt">-Kristina<o:p></o:p></SPAN></FONT></SPAN></P>
<P class=3DMsoNormal><SPAN class=3DEmailStyle15><FONT face=3D"Century =
Gothic"=20
color=3D#333399 size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">Ext.=20
2459</SPAN></FONT></SPAN><FONT color=3D#333399><SPAN=20
style=3D"COLOR: #333399; mso-color-alt: windowtext"><o:p></o:p></SPAN></=
FONT></P>
<P class=3DMsoNormal><!--[if supportFields]><font =
color=3D"#333399"><span=20
style=3D'color:#333399'><span =
style=3D'mso-element:field-end'></span></span></font><![endif]--><FONT=20
color=3D#333399><SPAN=20
style=3D"COLOR: #333399"><![if =
!supportEmptyParas]><![endif]> </SPAN></FONT><FONT=20
color=3D#333399><SPAN=20
style=3D"COLOR: #333399; mso-color-alt: =
windowtext"><o:p></o:p></SPAN></FONT></P></DIV></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_01C48A28.1A115CBA--