SeedCode Support Forum

In FM 8.5, user does an import that where one col. with some rows containing whatever text and other rows being blank. The whatever text will always vary. The fields within the FM records where the col was blank need to read "Member"

I tried auto enter text, but the import over writes the auto enter text.

This is a multi step import involving several excel files. This portion is updating as the account # have already been created.

Is there symbol/phrase for table::anniversary = blank?

Or what should be my solution

thanks,

Jim

Well you could run a scripted replace after the import to replace "blankness" with "Member", or use an auto enter calc set to replace existing contents. The auto enter calc might looks like this:

If ( isempty (trim ( YourField )) ; "Member" ; YourField )

Thanks, I used the calc to replace contents.