<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'><div dir='ltr'>
Thanks Jeff - <div><br></div><div>Table approach is OK but harder for us with Sarbanes Oxley reqs. But what does bcp mean?</div><div><br></div><div>Karen<br> <br><div>> Today's Topics:<br>> <br>> 1. Re:Pulling a flat file into format for PH (Jeff Hoffman)<br>> <br><br>> <br>> Hi Karen<br>> <br>> Replace commas with TAB<br>> build a table in an RDB<br>> bcp file into table<br>> use table to update your data using qtp<br>> drop table or truncate table if you expect to do it again.<br>> <br>> Regards<br>> <br>> Jeff Hoffman<br>> <br>> At 08:21 AM 30/08/2011, you wrote:<br>> <br>> >Hi All,<br>> ><br>> >I used to know how to do this but too many years since last time. <br>> >Users want to send me a delimited file to use for updating tables. I <br>> >seem to recall that I made a subfile with a defined line (just one <br>> >big one) and then copied the csv on top of the .sf. After that I <br>> >could parse out the fields using index to locate the <br>> >delimiters. I'm not getting a fixed length line so this is not working.<br>> ><br>> >Ideas? Thanks in advance!<br>> ><br>> >Karen Barrett<br>> >Elk Point, SD<br>> >360 608-6243<br><br>> This list is closed, thus to post to the list you must be a subscriber.<br>> Add 'site:lists.sowder.com powerh-l' to your search terms to search the list archive at Google.<br>> <br>> End of powerh-l Digest, Vol 75, Issue 4<br>> ***************************************<br></div></div> </div></body>
</html>