creating .csv file with numeric value

Sat Oct 23 12:39:28 PDT 2004

Dennis Malen wrote:
> As always, once a problem has been solved I make sure that the list is aware
> of the resolution.
> 
> It appears that the suggestion to export as a "multi" file as opposed to an
> "ascii" does the trick. The extension of ".csv" is still used If there is a
> leading zero (0) that is now retained.
> 
> The power of filePro and the genious and ingenuity of the list is just
> awesome.
> 
> Thanks again!!!
> 
> Dennis Malen

Dennis, I was on-the-road and not near email.  I have forgotten the 
exact character (me thinks its an ( ' ))  that makes excel treat the 
  data as text.  Just insert that  "'"{aa  and that should preseve 
the leading zeros in the SS numbers.

Regards,
Keith
-----
> 
> ----- Original Message -----
> From: "Walter Vaughan" <wvaughan at steelerubber.com>
> To: <filepro-list at lists.celestial.com>
> Sent: Friday, October 22, 2004 3:39 PM
> Subject: Re: creating .csv file with numeric value
> 
> 
> 
>>Dennis Malen wrote:
>>
>>
>>>My problem is as follows:
>>>
>>>I created an export file which is a comma delimited and the processing
> 
> then
> 
>>>adds the extension .csv
>>>
>>>This is created on a unix box and then ftp'd to windows.
>>
>>>PROBLEM
>>>
>>>One of the columns is a social security number. Some of the numbers have
> 
> a
> 
>>>leading zero (0) before it was loaded. Because all of the columns in
> 
> Excel
> 
>>>are defined as "general" as opposed to "text", the leading zero(0) is
>>>deleted when it is loaded.
>>>
>>>Does anyone know how to solve this problem without having to manually
> 
> import
> 
>>>the file into excel and manually change the definition of the file from
>>>"general" to "text".
>>
>>Export data as HTML. Use styles to define field as "Text" or "General"
>>Your friend in all this is style='mso-number-format:"\@"' to define text
>>
>><html>
>><head>
>><body>
>><table>
>>  <tr>
>>   <td style='mso-number-format:"\@"'>012-123-1234</td>
>>   <td style='mso-number-format:General'>123</td>
>>  </tr>
>>  <tr>
>>   <td style='mso-number-format:"\@"'>012-123-4567</td>
>>   <td style='mso-number-format:General'>04670</td>
>>  </tr>
>></table>
>></body>
>></html>
>>
>>Creating the export can be done via many methods...
>>Don't get hung up on newlines. You can have one header line, unlimited
>>data lines and one footer line.
>>I'll leave it to someone more well versed in filePro HTML codes to
>>translate the above into fP.
>>
>>--
>>Walter
>>
>>--
>>Walter
>>_______________________________________________
>>Filepro-list mailing list
>>Filepro-list at lists.celestial.com
>>http://mailman.celestial.com/mailman/listinfo/filepro-list
>>
>>
> 
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
> 
> 
> 

-- 
- - - - - - - - - - - - - - - - - - - - - - - - - - - -
Keith F. Weatherhead                   keithw at ddltd.com

Discus Data, LTD                  Voice: (815) 237-8467
3465 S Carbon Hill Rd               Fax: (815) 237-8641
Braceville, IL  60407       Nat'l_Pager: (815) 768-8098
- - - - - - - - - - - - - - - - - - - - - - - - - - - -