? Mark in field of Get Nth record

General support questions.
Posts: 68
Joined: Tue Jan 25, 2005 1:45 pm
PostPosted: Mon Jun 30, 2008 2:03 pm
I have run into a challenge with my Get Nth Record. If there is no data to pull in, a ? is placed in the field.

I need to delete the ?. Using a Insert calculated text, If (SPE 2::Amount 1 = "?"; "" ; SPE 2::Amount 1 )

Works in FM but when exported the ? remain.

thanks in advance

Jim
JIMBO
SeedCode Staff
SeedCode Staff
Posts: 2759
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Mon Jun 30, 2008 2:04 pm
You'll want to wrap the whole GetNthRecord string in a substitute that gets rid of the "?", something like:

Substitute ( YOUR_CALC ; "?" ; "" )
John Sindelar
SeedCode

Return to General Support

Who is online

Users browsing this forum: No registered users and 1 guest

cron
(855) SEEDCODE
support@seedcode.com
Follow us: