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 Code	Character	Hex Code	Character	Hex Code	Character
x09	TAB	x2A	*	x4A	@
x0A	LF	x2B	+	x5B	[
x0D	CR	x2C	,	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	?

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.