Download Data Magician 1.5 Documentation

The Data Magician, version 1.5
X E "punctuation"
Delete: specified punctuation from End of field data
Description:
This code deletes trailing punctuation (or any other characters specified) at the
end of a field. Any of the characters specified, within quotes, will be deleted in
any order until a character that is not in that list is encountered. Thus if you wish
to delete two dashes at the end of a field, you need only specify a single dash.
If none of the characters appear at the end of the field, this code has no effect.
Notes:
This process will be repeated separately for each "subfield" within the current
field, unless limited by the "S n-m" code (see page 119).
This code is a more generic version of the XP code (see page 136). The XP code
could be done using XE " .,/-" (note the space between the quote and the period).
The XP code is simply faster to type.
1)
2)
Examples:
1)
Before:
Codes:
After:
Guelph, Ont. :
XE ": "
Guelph, Ont.
Comments
Place of Publication
Strip colons and spaces (Note: order
doesn't matter)
2)
Before:
Codes:
After:
166744 ..C..
XE " .C"
166744
3)
Before:
Codes:
After:
Dogs.5Cats.5Pets -- Household
xe ".: ,"
Dogs5Cats5Pets -- Household
136
OCLC-type number
Can strip letters, too!