Hello Jaime,<br><br>we can create subfile based on the csv file record length and can use it in powerhouse.<br><br>For example: you hae two records of length 5 and 10, then you should create subfile in this way:<br>*************************
<br>define field1 char*5=""<br>define comma char*1=""<br>define field2 char*10=""<br>define filler char*1=""<br><br>rep summ all<br>set sub name myfile keep<br>go<br>*************************
<br><span style="font-weight: bold;">field comma for "," and filler for the new line character.</span><br><br>after creating the subfile, copy the data into .sf file, for unix, something its like this:<br><br>cp
xyz.csv myfile.sf<br><br>That's it and you can use it in PH. But you will have to take care of record lengths, and it should it be uniform throughout the CSV file, otherwise data will be shown corrupted.<br><br>Hope it helps.
<br><br>Vamsi<br><br><div><span class="gmail_quote">On 8/27/07, <b class="gmail_sendername">Jaime A</b> <<a href="mailto:jarqueza@gmail.com">jarqueza@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi<br><br>Like to know if there's any suggestion of converting a CSV
file to a subfile in Powerhouse and use this subfile to load to a table
defined in the dictionary.<br><br>Thanks<br><span class="sg">Jaime<br>
</span><br>--<br>= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>Mailing list: <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>
Subscribe: &quot;subscribe&quot; in message body to <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br>Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; in message body to
<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://lists.sowder.com/mailman/listinfo/powerh-l" target="_blank">
http://lists.sowder.com/mailman/listinfo/powerh-l</a><br>This list is closed, thus to post to the list you must be a subscriber.<br>Add 'site:<a onclick="return top.js.OpenExtLink(window,event,this)" href="http://lists.sowder.com" target="_blank">
lists.sowder.com</a> powerh-l' to your search terms to search the list archive at Google.<br></blockquote></div><br><br clear="all"><br>-- <br>"Nothing is impossible as impossible itself says i m possible"