Pulling a flat file into format for PH (Jeff Hoffman)

[Karen Barrett]

Thanks Jeff - 
Table approach is OK but harder for us with Sarbanes Oxley reqs.  But what does bcp mean?
Karen
 
> Today's Topics:
> 
>    1. Re: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

> 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.
> 
> End of powerh-l Digest, Vol 75, Issue 4
> ***************************************
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20110830/945dd173/attachment.htm