When using the Format Data Field tool, you may selectively crop segments within a field using the Crop Mask property. Enter the Crop Mask characters to keep or remove individual or strings of characters. Crop Mask characters include:
Character |
Description |
---|---|
R |
Retain character |
X |
Exclude character |
+ |
Wild card save (per word) |
- |
Wild card delete (per word) |
For example, if your original ASCII Output = 123456789, then:
Mask |
Output |
---|---|
RRR |
123 |
RRRXXXXXX |
123 |
XXXRRXXXX |
45 |
-RRRR |
6789 |