Using the EXPAND Command (continued)
In File 9, I'll use the EXPAND command to conduct the search on Electronic Arts, then refine it to see what Electronic Arts is doing with Sega, and finally narrow it to the most current year. Here's how it will look.
Step 1: EXPAND using the appropriate prefix and term:
e co=Electronic Arts
TYPE the command at the question mark prompt and press ENTER.
Set Items Description
--- ----- -----------
?expand co=electronic arts
Ref Items Index-term
E1 2 CO=ELECTRONIC ACCESS CONTROL DIV
E2 1 CO=ELECTRONIC AROMAS
E3 0 *CO=ELECTRONIC ART
E4 218 CO=ELECTRONIC ARTS
E5 3 CO=ELECTRONIC ARTS ASIA PACIFIC PTE LTD
(ELECTRO
E6 1 CO=ELECTRONIC ARTS DEUTSCHLAND
E7 147 CO=ELECTRONIC ARTS INC
E8 1 CO=ELECTRONIC ARTS KOREA
E9 1 CO=ELECTRONIC ARTS SEATTLE INC
E10 2 CO=ELECTRONIC ASSEMBLY
E11 1 CO=ELECTRONIC ASSEMBLY SUPPLY CO
E12 3 CO=ELECTRONIC ASSOCIATES INC
Enter P or PAGE for more
Step 2: SELECT the E-numbered lines that contain variations for the company Electronic Arts.
Because I don't know much about Electronic Arts, I want to get all of the entries for this company listed in the database. I will choose E numbers e4 through e9 and enter the command at the question mark prompt:
s e4:e9
?S E4:E9
S1 61 CO='ELECTRONIC ARTS':CO='ELECTRONIC
ARTS SEATTLE INC'
I want the Electronic Arts company that is involved in video games, and I want to see what Electronic Arts and Sega are doing against each other.
I can now refine my search to include sega in my search. My search would look like this:
s s1 and sega
?S S1 AND SEGA
61 S1
181 SEGA
S2 4 S1 AND SEGA
This search limited the results to only four records so I won’t bother to limit by date.
?T S2/FREE,K/ALL
2/K/1
DIALOG(R)File 9:(c) 2003 Resp. DB Svcs. All rts. reserv.
3521132 Supplier Number: 03521132 (USE FORMAT 7 OR
9 FOR FULLTEXT)
Two Video Game Giants to Clash with Competing Football
Game Products
August 19, 2002
WORD COUNT: 1052
COMPANY NAMES: ELECTRONIC ARTS INC; SEGA OF AMERICA
INC (SEGA ENTERPRISES LTD)
INDUSTRY NAMES: Software; Toys & games
PRODUCT NAMES: Computer games and entertainment
software packages (737284)
CONCEPT TERMS: Ad budget; All company; All market
information; Market share; Market size
GEOGRAPHIC NAMES: North America (NOAX); United States
(USA)
(USE FORMAT 7 OR 9 FOR FULLTEXT)
TEXT:
...s vs. Burger King.
It pits Electronic Arts, the undisputed heavyweight
champion of gaming, against Sega of America, the
storied creator of Sonic the Hedgehog, a company on the
comeback trail...
...category within sports, the most lucrative segment
of the $9.4 billion console gaming market. Sega is
counting on its NFL 2K3 title to grab market share
from EA's wildly...
...there's plenty of trash talk, too. EA corporate
spokesman Jeff Brown last week described Sega as "the
Burger King of video game sports -- they can brag about
extra pickles, but they'll always be the second
choice."
Sega 's corporate spokesman, Charles Bellfield's
retort was to send Brown a Burger King burger -- a kind
of "eat your words" gesture.
Sega 's president and chief executive is no stranger
to David vs. Goliath challenges. Peter Moore...
...they say," Moore said. "We have certainly achieved
that....Everything Jeff Brown says refers to Sega .
We're inside their heads."
Taunting an opponent is one thing. Snatching victory
from the...
...seven game platforms, according to SoundView
Technology Group, a Connecticut investment banking
firm. NFL 2K2, Sega 's football offering, captured
about 11 percent of football game sales.
Nonetheless, Sega hopes the strength of game play and
reviews will enable it to more than double that share
to 25 percent of the football game business. If Sega
succeeds, it will come at the expense of EA, its
Redwood City rival.
"It's...
...saying we're going to be No. 1 immediately."
In January 2001, San Francisco-based Sega , a
subsidiary of Japan's Sega Corp., announced it would
leave the hardware business. It abandoned the
struggling Dreamcast console -- and...
...albeit for one-time rivals.
Difficult end Moore recalls the painful decision to
break with Sega 's hardware heritage, which brought
arcade-quality gaming to America's living rooms a
decade...
...other company in the game industry -- 3DO -- has
attempted such a feat -- to mixed success.
Sega wrote off $700 million in costs associated with
leaving the hardware business, laid off the...
...Computer Entertainment.
"People I previously called the Antichrist welcomed
us," said Moore.
Within 10 months, Sega introduced games for all three
next-generation consoles: Sony's PlayStation 2,
Nintendo GameCube and...
...by the popularity of "Sonic Adventure 2" and "Super
Monkey Ball."
Sports holds the key Sega 's confidence in its ability
to become a top independent game developer is
reflected in...
...analyst for ING.
Sports games hold the key. Sports games account for 55
percent of Sega 's sales in the United States, its
largest market. And while Sega plans to publish 27
different sports titles this year -- including tennis,
hockey and baseball games -- the two most anticipated
are NFL 2K3 football and NBA 2K3 basketball.
Sega had encouraging sales of last year's football
and basketball titles -- with sales of 347...
...the games shipped late in the season.
This year, it will meet EA head-on. Sega shipped NFL
2K3 before the NFL season opener to match the launch of
Madden 2003...
...such challenges before. In the 13 years since EA
produced the first Madden game for Sega 's Genesis, it
has survived retail challenges from Sony ("NFL
Gameday"), Midway ("NFL Blitz"), Acclaim...
COMPANY NAMES: ELECTRONIC ARTS INC ...
... SEGA OF AMERICA INC ( SEGA ENTERPRISES LTD)
2/K/2
DIALOG(R)File 9:(c) 2003 Resp. DB Svcs. All rts. reserv.
3509614 Supplier Number: 03509614 (USE FORMAT 7 OR
9 FOR FULLTEXT)
Double headers: EA shows that its new major league
players got game, thanks to digital scanning. (Cover
Story)
August 2002
WORD COUNT: 2895
SPECIAL FEATURES: Table
COMPANY NAMES: ELECTRONIC ARTS INC; MAJOR LEAGUE
BASEBALL PLAYERS ASSOCIATION; MAJOR LEAGUE BASEBALL
PROPERTIES
INDUSTRY NAMES: Applications software; Software; Toys
& games
PRODUCT NAMES: Patent owners and lessors (679400);
Graphics software packages (737269); Computer games
and entertainment software packages (737284); Labor
unions and similar labor organizations (863000)
CONCEPT TERMS: All company; All product and service
information; Applications; Joint venture
GEOGRAPHIC NAMES: North America (NOAX); United States
(USA)
(USE FORMAT 7 OR 9 FOR FULLTEXT)
TEXT:
...who will eventually appear in titles from such heavy
hitters as EA, Sony, Acclaim, and Sega .
...As the newly scanned players enter their rookie
season this year in titles from Sony, Sega , Acclaim,
and EA, the Triple Play crew is actively preparing a
host of improvements for...
COMPANY NAMES: ELECTRONIC ARTS INC ...
2/K/3
DIALOG(R)File 9:(c) 2003 Resp. DB Svcs. All rts. reserv.
3450199 Supplier Number: 03450199 (USE FORMAT 7 OR
9 FOR FULLTEXT)
After the pregame, now the fun begins
May 20, 2002
WORD COUNT: 428
COMPANY NAMES: ELECTRONIC ARTS INC; MICROSOFT CORP;
NINTENDO OF AMERICA INC; SEGA AMERICA INC; SIGIL
GAMES ONLINE; SONY COMPUTER ENTERTAINMENT AMERICA
INDUSTRY NAMES: Software; Toys & games
PRODUCT NAMES: Electronic games and toys (394492);
Computer games and entertainment software packages
(737284)
CONCEPT TERMS: All company; Corporate strategy;
E-Commerce
GEOGRAPHIC NAMES: North America (NOAX); United States
(USA)
(USE FORMAT 7 OR 9 FOR FULLTEXT)
TEXT:
...up and broadband modems for GameCube this fall so
gamers can play new versions of Sega 's original
online game for the Dreamcast, Phantasy Star Online.
All of this, however, might...
COMPANY NAMES: ELECTRONIC ARTS INC ...
... SEGA AMERICA INC
2/K/4
DIALOG(R)File 9:(c) 2003 Resp. DB Svcs. All rts. reserv.
3400674 Supplier Number: 03400674 (USE FORMAT 7 OR
9 FOR FULLTEXT)
Videogame manufacturers see no ceiling on selling
season. (Strategy)
March 18, 2002
WORD COUNT: 450
COMPANY NAMES: ELECTRONIC ARTS INC; SEGA OF AMERICA
INC (SEGA ENTERPRISES LTD)
CONCEPT TERMS: All company; All market information;
Corporate strategy; Marketing campaign
MARKETING TERMS: All media; Cable TV advertising;
Magazine advertising
GEOGRAPHIC NAMES: North America (NOAX); United States
(USA)
(USE FORMAT 7 OR 9 FOR FULLTEXT)
TEXT:
Hein, Kenneth
In a typical year, videogame manufacturers such as
Electronic Arts and Sega would have eased off on ad
campaigns after the holidays. However, this is anything
but...
...have to get the message out that your games are
available across all the platforms."
Sega , which also is spending $10 million in the first
quarter, is running separate campaigns that...
...s Sonic Adventure 2 Battle and PS2's Virtua Fighter
4 are all in rotation. Sega spent about $100,000 on
media in the first quarter of 2001, per CMR.
The...
COMPANY NAMES: ELECTRONIC ARTS INC ...
... SEGA OF AMERICA INC ( SEGA ENTERPRISES LTD)
Now we'll use the FULL format, and TYPE s2/full/1 to see the complete record.
From the record we can see that sports video games are the rage. Looks like there will be quite a battle between Electronic Arts and Sega for control of this gaming area.
Better print out this article for Brian.
Hope this is the last we hear from Brian for a while; however, once he sees this article he may need research on this area of the market.
View the following record, then go to the exercises to practice online.
?T S2/9/1
2/9/1
DIALOG(R)File 9:Business & Industry(R)
(c) 2003 Resp. DB Svcs. All rts. reserv.
03521132 (THIS IS THE FULLTEXT)
Two Video Game Giants to Clash with Competing Football
Game Products
San Jose Mercury News , p N/A
August 19, 2002
DOCUMENT TYPE: Regional Newspaper (United States)
LANGUAGE: English RECORD TYPE: Fulltext
WORD COUNT: 1052
TEXT:
By Dawn C. Chmielewski
In the annals of great business rivalries, the battle
of Bay Area video game titans may rank alongside such
epic bouts as Coke vs. Pepsi, Nike vs. Reebok or
McDonald's vs. Burger King.
It pits Electronic Arts, the undisputed heavyweight
champion of gaming, against Sega of America, the
storied creator of Sonic the Hedgehog, a company on the
comeback trail after ditching the Dreamcast, its
unprofitable game console.
The battle will be joined -- in classic American sports
tradition -- over football. It is the single largest
category within sports, the most lucrative segment of
the $9.4 billion console gaming market. Sega is
counting on its NFL 2K3 title to grab market share
from EA's wildly popular Madden NFL Football franchise.
Both companies have loads of promotional cash to pitch
their $50 games -- about $75 million pledged for
television and print advertising -- and not an
inconsiderable amount of prestige riding on the
outcome.
And there's plenty of trash talk, too. EA corporate
spokesman Jeff Brown last week described Sega as "the
Burger King of video game sports -- they can brag about
extra pickles, but they'll always be the second
choice."
Sega's corporate spokesman, Charles Bellfield's retort
was to send Brown a Burger King burger -- a kind of
"eat your words" gesture.
Sega's president and chief executive is no stranger to
David vs. Goliath challenges. Peter Moore is a former
Reebok executive who used to face off with Nike.
"When fighting Nike, the first goal is to get them to
pay attention to you and refer to you in everything
they say," Moore said. "We have certainly achieved
that....Everything Jeff Brown says refers to Sega.
We're inside their heads."
Taunting an opponent is one thing. Snatching victory
from the overwhelming favorite is another.
EA's Madden game dominates the football category --
with more than a 65 percent share across seven game
platforms, according to SoundView Technology Group, a
Connecticut investment banking firm. NFL 2K2, Sega's
football offering, captured about 11 percent of
football game sales.
Nonetheless, Sega hopes the strength of game play and
reviews will enable it to more than double that share
to 25 percent of the football game business. If Sega
succeeds, it will come at the expense of EA, its
Redwood City rival.
"It's a measuring stick we will apply against ourselves
toward our ability to start stealing market share,"
said Moore. "This is not an immediate turnaround. We're
not saying we're going to be No. 1 immediately."
In January 2001, San Francisco-based Sega, a subsidiary
of Japan's Sega Corp., announced it would leave the
hardware business. It abandoned the struggling
Dreamcast console -- and 15 years of tradition -- to do
what it does best: develop great games, albeit for
one-time rivals.
Difficult end Moore recalls the painful decision to
break with Sega's hardware heritage, which brought
arcade-quality gaming to America's living rooms a
decade ago with the revolutionary Genesis console.
"There was this incredible roller coaster in that
room," said Moore, describing the meeting when the
decision was made. "We walked into the room as a
hardware company and walked out of there as a software
company. We had put an awful lot of emotional currency
into the Dreamcast. Fought hard against Sony. And now,
we had to make them our friends."
Only one other company in the game industry -- 3DO --
has attempted such a feat -- to mixed success.
Sega wrote off $700 million in costs associated with
leaving the hardware business, laid off the staff, and
threw the full weight of its 1,200 developers into
making games for one-time competitors in the console
business -- Nintendo and Sony Computer Entertainment.
"People I previously called the Antichrist welcomed
us," said Moore.
Within 10 months, Sega introduced games for all three
next-generation consoles: Sony's PlayStation 2,
Nintendo GameCube and Microsoft's new entrant, the
Xbox. And it emerged as the largest independent game
publisher for GameCube earlier this year -- buoyed by
the popularity of "Sonic Adventure 2" and "Super Monkey
Ball."
Sports holds the key Sega's confidence in its ability
to become a top independent game developer is
reflected in the company's comments to analysts. It
expects video game revenue for consoles other than the
Dreamcast to grow to 92 percent from 48 percent,
according to Lisa Spicer, an analyst for ING.
Sports games hold the key. Sports games account for 55
percent of Sega's sales in the United States, its
largest market. And while Sega plans to publish 27
different sports titles this year -- including tennis,
hockey and baseball games -- the two most anticipated
are NFL 2K3 football and NBA 2K3 basketball.
Sega had encouraging sales of last year's football and
basketball titles -- with sales of 347,000 and 486,000
games respectively -- even though the games shipped
late in the season.
This year, it will meet EA head-on. Sega shipped NFL
2K3 before the NFL season opener to match the launch of
Madden 2003 last week. It also made a deal with ESPN
to capture the look of the broadcasts within its game
and it pledged $15 million for an ad campaign.
"This is going to be the ultimate litmus test," said
James Lin, managing director of Jefferies & Co., a Los
Angeles investment bank. "It measures whether the
transition is going well. They don't need to overtake
Madden this year. All they have to do is establish
themselves as that firm No. 2 behind EA Sports."
Ready for contest EA has faced such challenges before.
In the 13 years since EA produced the first Madden game
for Sega's Genesis, it has survived retail challenges
from Sony ("NFL Gameday"), Midway ("NFL Blitz"),
Acclaim ("Quarterback Club") and Microsoft ("NFL
Fever").
"We've faced a lot of competition over the years," said
Frank Gibeau, EA's vice president of marketing. "We're
not troubled by it. In fact, we like competition. We're
a competitive organization -- and there's nothing like
having someone pick a fight with you to get you fired
up and focused."
If early reaction from retailers is any indication, EA
won't have to worry about losing its top slot.
GameStop, a specialty retailer that operates FuncoLand
and Babbage's, announced record advance sales of Madden
NFL 2003.
"This is the first time that reservations have ever hit
50,000 for a sports title. As such, our initial order
for this title has reached an all-time high," said Dan
DeMatteo, GameStop's president and chief operating
officer.
Copyright 2002 San Jose Mercury News
provided by Knight-Ridder/Tribune Business
News.
COMPANY NAMES: ELECTRONIC ARTS INC; SEGA OF AMERICA
INC (SEGA ENTERPRISES LTD)
INDUSTRY NAMES: Software; Toys & games
PRODUCT NAMES: Computer games and entertainment
software packages (737284)
CONCEPT TERMS: Ad budget; All company; All market
information; Market share; Market size
GEOGRAPHIC NAMES: North America (NOAX); United States
(USA)
Go to the exercises to practice online.
6-5
