Page 1 of 1

Import Issue

PostPosted: Tue May 27, 2008 8:49 am
by jim shelton
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

PostPosted: Tue May 27, 2008 9:42 am
by John Sindelar
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 )

PostPosted: Tue May 27, 2008 10:56 am
by jim shelton
Thanks, I used the calc to replace contents.