Related Information Examples & Tutorials
Your server is the heart of your company and it's health is vital to the functioning of your business. Schedule a Server Analysis to help keep your system tuned up and running optimally. Not an Extended Support Member but would like to explore custom consulting services? Contact us for pricing.
“ Collect! is the software we used to start our debt collections business in 1999 ... now we are using about 100 licenses. ” Ken W.

Multi Character Field Delimiters

You can specify multiple field delimiters in Collect!'s Import/Export for both Field Delimiter and Record Delimiter fields. Up to 7 characters may be stored, enabling you to specify multiple HEX codes and/or multiple ASCII codes simultaneously. This lets Collect! parse more complex data files where different delimiters are used to separate various data items.

When importing data, every Delimiter in the field will be interpreted as a Record or Field Delimiter in the incoming data, unless the first two delimiters are x0Dx0A, in which case the first two will be used together as a whole.

When exporting data, only the first delimiter specified in the Delimiter field will be used, unless the first two delimiters are x0Dx0A, in which case the first two will be used together as a whole.

Hex Code Table

For your convenience, the following table will help you when specifying the delimiters for your import maps.

Hex CodeCharacterHex Code CharacterHex CodeCharacter
x09TABx2A*x4A@
x0ALFx2B+x5B[
x0DCRx2C,x5C\
x21!x2D-x5D]
x22"x2E.x5E^
x23#x2F/x5F_
x24$x3A:x60`
x25%x3B;x7B{
x26&x3C<x7C|
x27'x3D=x7D}
x28(x3E>x7E~
x29)x3F?  

Top of page.

Summary

Up to 7 characters may be stored in the Import/Export Delimiter fields. This enables you to parse more complex data files where different delimiters are used throughout the file to separate various data items. You can specify multiple HEX codes and/or multiple ASCII codes simultaneously.

Top of page.

See Also

- Import/Export Topics

Top of page.

Was this page helpful? Do you have any comments on this document? Can we make it better? If so how may we improve this page.

Please click this link to send us your comments: helpinfo@collect.org

Collection Advisor Veracode Verified RMA ACA Member