Import Issue

General support questions.
Posts: 68
Joined: Tue Jan 25, 2005 1:45 pm
PostPosted: Tue May 27, 2008 8:49 am
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
JIMBO
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Tue May 27, 2008 9:42 am
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 )
John Sindelar
SeedCode
Posts: 68
Joined: Tue Jan 25, 2005 1:45 pm
PostPosted: Tue May 27, 2008 10:56 am
Thanks, I used the calc to replace contents.
JIMBO

Return to General Support

Who is online

Users browsing this forum: No registered users and 3 guests

cron
(855) SEEDCODE
[email protected]
Follow us: