Pulling a flat file into format for PH

[Richard Witkopp]

Maybe import the .csv into Excel and then export a fixed width column file from Excel?

If it's VMS you can then convert the file to a fixed length file and pad with spaces.

________________________________
From: powerh-l-bounces+rwitkopp=phxa.com at lists.sowder.com [mailto:powerh-l-bounces+rwitkopp=phxa.com at lists.sowder.com] On Behalf Of Karen Barrett
Sent: Monday, August 29, 2011 3:22 PM
To: PowerhouseList Post
Subject: Pulling a flat file into format for PH


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


------------------------------------------------------------------------------
NOTICE: The information contained in this e-mail and any attachments is confidential and may be privileged or otherwise protected from disclosure.This e-mail is intended solely for the use of the named addressee. Any other use, printing, copying, disclosure or dissemination may be subject to legal restriction. If you are not the intended recipient, please contact the sender and delete all copies including any attachments.

==============================================================================
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20110829/80a9ae52/attachment.htm