home *** CD-ROM | disk | FTP | other *** search
- Newsgroups: comp.unix.questions
- Path: sparky!uunet!cs.utexas.edu!swrinde!gatech!usenet.ins.cwru.edu!agate!dog.ee.lbl.gov!hellgate.utah.edu!csn!teal!pershing
- From: pershing@csn.org (Paul Pershing)
- Subject: sed or awk
- Message-ID: <pershing.726513629@teal>
- Summary: sed or awk for manip. stock market tables; need script
- Originator: pershing@teal.csn.org
- Keywords: cleaning up stock mkt. lists
- Sender: news@csn.org (news)
- Nntp-Posting-Host: teal.csn.org
- Organization: Colorado SuperNet, Inc.
- Date: Fri, 8 Jan 1993 17:20:29 GMT
- Lines: 41
-
-
- Hello, everyone. I need help. A project I'm involved in takes stock market
- tables (i.e., N.Y.S.E, AMEX, NASDAQ) in text form (ASCII) that have been
- compiled on a VAXstation 3100 (running VMS), and needs to get them ready
- to place in a Mac publishing program, QuarkXpress. I could pass the files
- through a PC, Mac, VAX, or even remote Unix if I must, but I need help in
- cleaning these files up. First of all, the fractions are all "whole number
- fractions," i.e., 11/16, 5/8, 15/16, and so on. Tables have from two to
- 11 columns, and I need to place a single tab between each column, remove
- all other spaces, close up the whole number fraction with it's companion
- numbers, i.e., +5 11/16 we write as +5-11/16 ("-" separates the fraction
- from its companion, _when_ there is one). I'm sure that sed, awk or
- perl can do this, but I _may_ be limited :) by platform. I have a sed,
- perl and awk that runs under Macintosh MPW (Mac Programmer's Workshop),
- or I have DOS versions of these (I may be able to get PD version for
- VMS...). Can someone point me in the directin I need to clean up these
- files? Some samples would help, and maybe I could then add (if needed) to
- customize whatever anyone contributes.
- This is greatly appreciated, and if this is a bigger deal than I understand,
- the company might be willing to pay someone, although I don't know for
- sure about this. I'll check if someone needs this assurance.
-
- Thanks for your help, please email me and I'll summarize if anyone
- wants (I wasn't sure I was posting to the right group)
- Paul Pershing
- Systems Manager/Editor
- Rocky Mountain News
- 400 W. Colfax Ave., Denver, CO 80204
- 303 892 2633
-
-
- --
- ------------------------------------------------------------------------------
- ******** Paul Pershing, Editorial Design/Systems, Rocky Mountain News ********
- **** 400 W. Colfax Ave. Denver 80204 (303) 892-2633 * Disclaimers, etc. ****
- ------------------------------------------------------------------------------
- --
- ------------------------------------------------------------------------------
- ******** Paul Pershing, Editorial Design/Systems, Rocky Mountain News ********
- **** 400 W. Colfax Ave. Denver 80204 (303) 892-2633 * Disclaimers, etc. ****
- ------------------------------------------------------------------------------
-