About SEAnews Database
http://58.185.228.62/fmi/iwp/res/iwp_home.html
Click “SEAnews digest” or “SEAnews for subscriber”.
There are two columns. The left column is the status area in which you can find several control buttons, icons, bars etc. The right column is a field area where you can find several data fields such as ‘No”, ‘日付(date)’, ‘対日関係(Relation with Japan)”,”見だし(headline)”, “前書き(lead)” and so on.
Following is an example for search data you want to find.
1)Choose “search” scrolling the “レイアウトwindow” in the status area.
2)There are three icons “house”, “pencil” and “magnifier” on the bar placed at the head of the status area. click the “magnifier icon”.
3)Type “2007*” in the date field and put “*” in the電子電気製品(Electronics/Electrical) field.
4)Then click “検索実行(Find)” bar in the status area.
Through these transactions you can find news articles in the electronics and electrical category in the year 2007.
Finding text and characters
(The following explanations are copied from FileMaker’s “help” just for your reference. The web version may be different..)
★Words that start with Roman characters
The characters
Chris Smith finds Chris Smith, Smith Chris, Chris Smithson, and Smith Christenson
★Words that start with Japanese Hiragana, Katakana, or Kanji characters
The characters between = and *
finds , , and
★A phrase or sequence of characters
The text, including spaces and punctuation, between the double quotation marks (").
"Marten and Jones Interiors" finds Marten and Jones Interiors but not Jones and Marten Interiors
", Ltd." finds all companies with ", Ltd." in the name, but not those without the comma.
★Words with one or more unknown or variable characters
One wildcard character (@) for each unknown character.
Gr@y finds Gray and Grey
@on finds Don and Ron but not Bron
★Invalid characters in a text field
?
Invalid characters display as blank characters
Note To find the ? character, search for "?"
★Digits in a text field
A # character for each digit
# finds 3 but not 30
## finds 30 but not 3 or 300
#3 finds 53 and 43 but not 3
★Words with zero or more unknown or variable text characters in a row
* for all unknown characters.
Jo*n finds Jon and John
J*r finds Jr. and Junior
*phan* finds Phan and Stephanie
★Symbols or other non-alphanumeric characters, such as punctuation or spaces
The characters, including spaces and punctuation, between the double quotation marks (").
"@" finds @ (or an email address, for example)
"," finds records containing a comma
" " finds three spaces in a row
★A character with special meaning, such as the find symbols recognized by FileMaker Pro:
@, *, #, ?, !, =, <, >, "
\ followed by the special character
\"Joey\" finds "Joey"
Joey\@abc.net finds the email address Joey@abc.net
★Words with accented characters
The text, including spaces and punctuation, between the double quotation marks (").
"òpera" finds òpera but not opera
(òpera without quotes finds both òpera and opera)
★Partial phrases (a sequence of words or characters)
Characters, punctuation, and spaces between the double quotation marks ("). Use * to find this text in the middle of a longer text string.
*"son & Phillips" finds
Johnson & Phillips and Paulson & Phillips
★Exact matches of the text you specify
==
(two equal signs)
==John finds John but not John Smith
==John Smith finds John Smith but not Smith, John or John Smithers
Exact matches of whole words you specify
=
=Market finds Market, Market Services, and Ongoing Market Research but not Marketing or Supermarket
=Chris =Smith finds Chris Smith or Smith Chris but not Chris or Christopher Smithson
★Words that contain Japanese Hiragana, Katakana, and Kanji characters (Japanese-indexed fields only)
The characters.
finds , , and
★Kana characters in a Japanese-indexed field without differentiating between Hiragana/Katakana, Voiced/Semi-Voiced/Unvoiced Kana, Small/Regular Kana, and Kana Voiced/Unvoiced Iteration Marks
~ (tilde) and the character.
finds , , , , , and .
Notes
Normally, finds are not case sensitive or width sensitive. For example:
A find for fred finds Fred and FRED.
A find request that includes Japanese half-width characters will match results that contain the equivalent full-width characters.
http://www.filemaker.com/help/03-Finding%20sorting4.html
One example of application of SEAnews
The Institute for Policy Sciences, Japan (IPS), a think tank funded by the Japanese leading companies including the Tokyo Electric Power Company, has collected data from SEAnews digest on our website and assembled the following tables and provided to the public.