Converting CSV file to a subfile in Powerhouse

[vamsi krishna]

Hello Jaime,

we can create subfile based on the csv file record length and can use it in
powerhouse.

For example: you hae two records of length 5 and 10, then you should create
subfile in this way:
*************************
define field1 char*5=""
define comma char*1=""
define field2 char*10=""
define filler char*1=""

rep summ all
set sub name myfile keep
go
*************************
field comma for "," and filler for the new line character.

after creating the subfile, copy the data into .sf file, for unix, something
its like this:

cp xyz.csv myfile.sf

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.

Hope it helps.

Vamsi

On 8/27/07, Jaime A <jarqueza at gmail.com> wrote:
>
> Hi
>
> 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.
>
> Thanks
> Jaime
>
> --
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l at lists.sowder.com
> Subscribe: &quot;subscribe&quot; in message body to
> powerh-l-request at lists.sowder.com
> Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; in message body to
> powerh-l-request at lists.sowder.com
> http://lists.sowder.com/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a subscriber.
> Add 'site:lists.sowder.com powerh-l' to your search terms to search the
> list archive at Google.
>



-- 
"Nothing is impossible as impossible itself says i m possible"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20070827/dbf5be37/attachment.htm