Jump to content

Field Names

Recommended Posts

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.

Link to comment
Share on other sites

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;

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...