Related Information Examples & Tutorials
Want to learn more? View the Training Videos in the Collect! Member Resource Center to learn the inside tips on utilizing all that Collect! has to offer to optimize your company's efficiency.
“ I looked into many products before purchasing Collect!, but none had the features, ease, detailed instructions, or customer service of your company and product. ” Judy A.

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 RMA ACA Member