Hello all,

I'm looking for a small quirk I have run into. 

I have a background calculated TEXT field with about 200 lines of code to create a fixed set of alphanumeric data to export later.  The problem is the data has leading and trailing blanks at some points.  When I update the field, it truncates the leading and trailing blank data from the results of the code.

How can I override this to ensure the field includes all my data?

Thanks!

Well, I'm storing a fixed ASCII line of 511 characters for each record, that can have changes each time the record is altered, and to built that 511 characters, I have written 220 lines of code and created a number of variables to calculate on form exit.

My original plan was to have these calculate on the fly as the files are worked, and then once a month export them into a flat ASCII file as a report.  This export could be 15,000 records each month...

The field I'm using to create the data is a text field.  When I use WriteLn, my data comes out unstripped.  When I update the field, it briefly appears unstripped in the field, and then truncates it.  Is there some sort of text field setting to avoid truncation of 'extraneous' blanks?

Other than that, would you recommend a better method than what I'm trying, in specific?

Hello Blair,

One other thing you can do since you mean to export it later is end and finish the field with a " character. You can always strip the " character when you do the export as long as you are the one writing out the file using programming.

-Ray