From: Kurt True (kurtt_at_uclink.berkeley.edu)
Date: Mon Apr 21 2003 - 11:10:21 PDT
Saving as Excel was your first mistake. Excel, in the authoritarian
fashion characteristic of Microsoft products, systematically eliminates
leading zeros, with which the campus chart of accounts abounds. Try saving
as "csv." Then you can use just about any RDBMS known to Western
civilization to convert the comma delimited file to fixed width.
-kurt
At 09:47 AM 4/21/2003 -0700, E. Bond Francisco wrote:
>Folks,
>
>I'd like a fixed field length file (but I'd accept Tab or comma delimited)
>that contains all the account numbers and associated names. In other
>words: 56210 - Buidling Maintenance.
>
>I've been to the BFS, downloadable chart of accounts links, but these seem
>to come back as Excel Spreadsheets, and I can't figure out how to extract
>the appropriate data into two columns. I've tried =LEFT(CELLREF, 5) to
>pick out the account numbers for starters, but it appears that that's not
>the appropriate function for the data type or there's a bunch of leading
>characters, or something. I'm willing to do that if someone can tell me how.
>
>Anyway, any clues greatly appreciated.
>
>Thanks,
>
>Bond
>_______________
>(-)(-)(-)(-)(-)(-)(-)(-)(-)
>E. Bond Francisco
>CMMS Administrator
>Physical Plant - Campus Services
>UC Berkeley
>510-643-5523
>
>
><http://promos.hotbar.com/promos/promodll.dll?RunPromo&El=hotbar%5felement%3bst%3b&SG=&RAND=1857g
>
------------------------------------------------------------------------
The following was automatically added to this message by the list server:
For information about Micronet, including subscribing to
or unsubscribing from its mailing list and finding out
about upcoming meetings, please visit the Micronet Web site:
<http://micronet.berkeley.edu/>.
This archive was generated by hypermail 2.1.5 : Mon Apr 21 2003 - 11:13:53 PDT