Pulling a flat file into format for PH

[Jeff Hoffman]

Hi Karen

Replace commas with TAB
build a table in an RDB
bcp file into table
use table to update your data using qtp
drop table or truncate table if you expect to do it again.

Regards

Jeff Hoffman

At 08:21 AM 30/08/2011, you wrote:

>Hi All,
>
>I used to know how to do this but too many years since last time. 
>Users want to send me a delimited file to use for updating tables. I 
>seem to recall that I made a subfile with a defined line (just one 
>big one) and then copied the csv on top of the .sf. After that I 
>could parse out the fields using index to locate the 
>delimiters.  I'm not getting a fixed length line so this is not working.
>
>Ideas? Thanks in advance!
>
>Karen Barrett
>Elk Point, SD
>360 608-6243
>
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l at lists.sowder.com
>Subscribe: 'subscribe' in message body to powerh-l-request at lists.sowder.com
>Unsubscribe: 'unsubscribe <password>' 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.