This tool cleans and formats the data contained in Data Fields. If the data fields output in the text file are not in the correct format. The Format Data Field tool can remove spaces, or specify a fixed length for the fields.
Input Data |
Description |
---|---|
Variable |
System data item that will be formatted. |
Remove Characters |
Description |
---|---|
Characters |
List of characters to be removed. |
Spaces |
Indicates whether spaces, or extra spaces, will be removed from the text data. |
Masking |
Description |
---|---|
Crop Mask |
Indicates the crop mask to be applied to the text data. |
Edit Mask |
Indicates the edit mask to be applied to the text data. |
Format |
Description |
---|---|
Fixed Length |
Indicates the length that the data will become. |
Justification |
Indicates if the data will be justified to the left or the right. |
Shift Case |
Indicates whether or not the text data will have its case shifted. |
Zero Fill |
Indicates if the data will be padded with zeros instead of spaces. |
Translations |
Description |
---|---|
Character Substitutions |
Provides a list of characters and their translated values. |