This tag supports all kind of fixed width data, including:

• Fixed width data from file. You can read the data using <cffile> and then import it to CF query using this tag.
• Support UNIX, Mac and DOS file mode, as well as other line break delimiters.
• Support any kind of filler character.
• Support for auto-trim value.

Features

• Easy to use!
• Support all kind of fixed width string.
• Fast process
• Create ColdFusion compatible query, just like querying a database using <cfquery>
• Comes with detailed report. It tells which row converted ok, and which is not.
• Support UNIX, Mac and DOS file mode, as well as other line break delimiters.
• Support any kind of filler character.
• Support for auto-trim value.
• Plain CF custom tag. Shared hosting friendly.
  Just copy this custom tag in your ColdFusion script directory, and you're set

Requirements

• ColdFusion 5
• ColdFusion MX 6, 6.1
• ColdFusion MX 7

on all operating systems

Usage

<cf_fixwidth2query		fixedwidth="fixed width string you want to convert to CF query "
		result="[resulted query name]"
		report="[detailed report on result query, the default name is #yourresultname#_report]"
		linebreak="[linebreak, default is carriage return followed by line feed (chr(13) & chr(10))]"
		startrow="[the first row to process]"
		endrow="[the last row to process, if 0 all the rest rows will be processed]">
	<cf_fw2q_column	Field="column name" Width="widht of column" FillChar="filler character. Default is space" Trim="true|false. Default is true: trim the column">
	<cf_fw2q_column	...>
	<cf_fw2q_column	...>
</cf_fixwidth2query>