<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16525" name=GENERATOR>
<STYLE>@font-face {
font-family: Wingdings;
}
@page Section1 {size: 595.3pt 841.9pt; margin: 72.0pt 90.0pt 72.0pt 90.0pt; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.EmailStyle17 {
FONT-WEIGHT: normal; COLOR: blue; FONT-STYLE: normal; FONT-FAMILY: Arial; TEXT-DECORATION: none; mso-style-type: personal-compose
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-GB vLink=purple link=blue>
<DIV dir=ltr align=left><SPAN class=375381313-31082007><FONT face=Arial
color=#0000ff size=2>Ha, so was I Bob, s</FONT></SPAN><SPAN
class=375381313-31082007><FONT face=Arial color=#0000ff size=2>ince I have
already handled the CSV import problem by creating a lengthy process to import
these types of files.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=375381313-31082007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=375381313-31082007><FONT face=Arial
color=#0000ff size=2>Maybe we should look at altering this request into some
kind of option to read CSV files automatically?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=375381313-31082007><FONT face=Arial
color=#0000ff size=2>Maybe a new subfile type, CSV that we can read/write
to?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=375381313-31082007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=375381313-31082007><FONT face=Arial
color=#0000ff size=2>Just a thought</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN class=375381313-31082007></SPAN><FONT face=Arial><FONT
color=#0000ff><FONT size=2>K<SPAN
class=375381313-31082007>en</SPAN></FONT></FONT></FONT><BR></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com] <B>On
Behalf Of </B>Deskin, Bob<BR><B>Sent:</B> August 31, 2007 9:05 AM<BR><B>To:</B>
Joe Boyle; powerh-l@lists.sowder.com<BR><B>Subject:</B> RE: new feature request
- identify a subfile record terminator -allsubsequent characters are
ignored<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>
<DIV dir=ltr align=left><SPAN class=421015612-31082007><FONT face=Arial
color=#0000ff size=2>I was waiting to see if anyone else commented on this
idea.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=421015612-31082007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=421015612-31082007><FONT face=Arial
color=#0000ff size=2>Subfiles are created by PowerHouse and, except for nodict
subfiles, are designed to be read by PowerHouse. I know that there are
techniques where the dictionary is created in PowerHouse and the data files are
created elsewhere, but I don't believe that these are very common. And when they
are used, they need to take into account the restrictions of PH
subfiles.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=421015612-31082007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=421015612-31082007><FONT face=Arial
color=#0000ff size=2>We do not currently handle variable length direct or
indexed files on UNIX or Windows. And if you're talking about a pseudo-variable
length, I expect it would require some major work to integrate into our existing
routines.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=421015612-31082007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=421015612-31082007><FONT face=Arial
color=#0000ff size=2>I don't see this as being a high demand item and is
potentially high risk and high effort. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=421015612-31082007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=421015612-31082007><FONT face=Arial
color=#0000ff size=2>Bob</FONT></SPAN></DIV><BR>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
powerh-l-bounces+bob.deskin=cognos.com@lists.sowder.com
[mailto:powerh-l-bounces+bob.deskin=cognos.com@lists.sowder.com] <B>On Behalf
Of </B>Joe Boyle<BR><B>Sent:</B> August 29, 2007 8:24 pm<BR><B>To:</B>
powerh-l@lists.sowder.com<BR><B>Subject:</B> new feature request - identify a
subfile record terminator - allsubsequent characters are
ignored<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Arial">I think I may have a
winner here - at last </SPAN></FONT><FONT face=Wingdings color=blue><SPAN
style="COLOR: blue; FONT-FAMILY: Wingdings">J</SPAN></FONT><FONT face=Arial
color=blue><SPAN
style="COLOR: blue; FONT-FAMILY: Arial">.<O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Arial"><O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Arial">New feature request –
on subfile creation, identify a subfile record length terminator - all
subsequent characters are ignored for the current
record.<O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Arial"><O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Arial">Currently, subfile
records are of absolute length, so very difficult to read variable length
records (e.g. csv format ) with ease. <O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Arial"><O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Arial">In this scenario, a
defined record terminator char can be identified to PH, and appended to each
subfile record on creation e.g. dos example below
:<O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Arial"><O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Arial">`Run some process`
>> “Run_some_process.log”<O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Arial"><O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Arial">For /f “tokens=*”
%i in (“Run_some_process.log”) echo %i| >>
“Run_some_process.ps”<O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Arial"><O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Arial">Where the definition
for portable subfile ‘Run_some_process‘ contains not a record/item length, but
establishes a “|” char as a record terminator.<O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Arial"><O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Arial"><O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Arial">Regards,
Joe.<O:P></O:P></SPAN></FONT></P></DIV></BLOCKQUOTE></DIV>
<DIV> </DIV>
<DIV> 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.
</DIV></BODY></HTML>