<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-15">
<META content="MSHTML 6.00.2900.3157" name=GENERATOR></HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>Agreed -- I suspect most have already created the process to create -</DIV>
<DIV>The import process would be great <BR></DIV>
<DIV>my 2 cents</DIV>
<DIV>Cora</DIV>
<DIV><BR>>>> "Ken Langendock" <Ken@Langendock.com> 8/31/2007 9:16 AM >>><BR></DIV>
<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">.<?XML:NAMESPACE PREFIX = O /><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>