1. Welcome to SportsJournalists.com, a friendly forum for discussing all things sports and journalism.

    Your voice is missing! You will need to register for a free account to get access to the following site features:
    • Reply to discussions and create your own threads.
    • Access to private conversations with other members.
    • Fewer ads.

    We hope to see you as a part of our community soon!

Agate-related question

Discussion in 'Journalism topics only' started by HejiraHenry, Apr 8, 2008.

  1. HejiraHenry

    HejiraHenry Well-Known Member

    I have a friend (no, really) who has moved downstream to a paper where they are getting all their AP copy off of Exchange. All well and good, but you deskers probably know what the problem is: Sports agate.

    You pull NL standings, for instance, off that way and it ain't tabbed. Whee!

    Anybody know of a macro or a script that you can run to clean that up? They're doing it by hand right now, I guess, and it's terribly time-consuming.

    The real answer is for them to pull a line in to the paper and start getting the datastream, but I'm trying to help her with at least a short-term solution.
  2. ARD

    ARD Member

    I'm sure the answer is mostly site-specific, and there are easier ways, but ... you could copy the standings from AP Exchange, create a new spreadsheet in Google Docs or Excel, paste in the standings, export them as CSV, open that file in Notepad and paste it into a file in your system. Then search for commas and replace with tabs. Kludgy, but it might work in the short term.
  3. deskslave

    deskslave Active Member

    You could write/have someone write a script to remove all the extraneous characters, then have a dummy set up that you could eyedropper the remaining text with. That, of course, relies on having InDesign or some other program that has a similar tool. And of course, the script would require having someone capable of writing scripts, and methinks a place that is using APExchange for agate probably doesn't have that.
  4. HejiraHenry

    HejiraHenry Well-Known Member

    Both clever ideas ... glad I don't have to do those things.

    It's an 11,000 daily. Not sure why they aren't using the datastream.
  5. deskslave

    deskslave Active Member

    Because the idiot who wears the publisher beanie heard from one of his idiot publisher friends that it might save him $35 a week?
Draft saved Draft deleted

Share This Page