Download Data Magician 1.5 Documentation

The Data Magician, version 1.5
B R characterposition
B R -characterposition
Break Right of character position in data
Description:
This code returns all the data to the right of the specified position in the data. If
you specify a negative number, the characters are counted from the right side.
This is useful when the contents of a field has several pieces of information in a
specific order, each piece with a specific length (like old computer punch cards).
In MARC records, and in some databases, these are referred to as "fixed fields".
Notes:
If the data does not extend to the specified character position, the data is left
unchanged.
To extract a range of characters from the middle, use a combination of Break Left
and Break Right of character position.
1)
2)
Examples:
1)
Before:
Codes:
After:
CAN0090..ENGXC
BR12
XC
Comments
we want to extract 'XC'
2)
Before:
Codes:
After:
CAN0090..ENGXC
BR 9 BL 4
ENG
'ENG' is a language code
2 steps required (or BL13 BR9)
3)
Before:
Codes:
After:
ABC123ZZ
B R -2
ZZ
we want to extract the 'ZZ'
chop off everything before
last 2 characters
86