ThomasLewis Posted March 15, 2013 Share Posted March 15, 2013 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. Quote Link to comment Share on other sites More sharing options...
Dan Korn Posted March 21, 2013 Share Posted March 21, 2013 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; Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.