Fixing common issues.

When importing data, PayGate will automatically correct various common issues found in data.

Sort code Repair

Sort codes are often stored and present with hyphens (and less commonly with colons) .  PayGate will automatically remove hyphens and colons from imported sort codes.

For example: 12-34-56 will be automatically changed to 123456

PayGate will automatically append leading zeros to any imported sort codes of length less than 6 digits.

For example:  12345 will be automatically changed to 012345

PayGate will automatically trim any leading or trailing white spaces from the imported sort code.

Account number length repair

PayGate will automatically append leading zeros to any imported account number of length less than 8 digits.

For example:  123456 will be automatically changed to 00123456

PayGate will automatically trim any leading or trailing white spaces from the imported account number.

Removing null ASCII characters

Legacy systems sometimes add ASCII null characters (ASCII Code 0) when creating data files.  These can cause problems when importing the data into other systems such as PayGate.

PayGate will automatically strip out any null characters from a file during the import.