Related Information Examples & Tutorials
Want new features? Check out the news on the latest version of Collect! available. Members can download new enhancements FREE! Interested in new features available but not currently on a Membership? Please contact us for pricing. Enhancements may be purchased separately.
“ Unlike most packaged software - Collect! allows us to work 'outside the box.' ” Norma B.

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