Field Names

Is there a way to trim the names of the Field names?

For instance I have rules set up to call Field("Color"). The client occasionally sends the data in with the header name as "Color " with a space after it so the Field name does not match.

I was hoping I could just call the Field by column number (Field(2)) but that doesn't seem to work either. If someone has some advice on how to handle this without having to go in and check for spaces every time, it would be appreciated.

You can use ordered fields by unchecking the "First row contains field names" box in the Define Data Source Wizard. Then the field names are defined in the Fields dialog (FusionPro -> Data Definition -> Input Options -> Edit Fields). You'll probably need to do this in OnRecordStart as well:

if (FusionPro.Composition.inputRecordNumber == 1)
   FusionPro.Composition.composeThisRecord = false;