the walker Posted April 28, 2003 Share Posted April 28, 2003 Hi am trying to clear five fields over around a thousand records for a script. this take a while to loop through the lot so i need to cut it down to record just with text in the five fields does any one know how i can script it to enter in "" into a field to find any text if not does any one know how to find blank fields in a script the i can just show omitted and hey presto i have my record set i need cheers all Link to comment Share on other sites More sharing options...
djgogi Posted April 28, 2003 Share Posted April 28, 2003 To find non empty values in TEXT field use following Set error Capture [on] Freeze Window Enter Find Mode[] SetField [field1, "="] New Record Request SetField [field2, "="] ... ... Perform Find If [status(CurrentFoundCount)] Show omtted Perform Script [Your Script For Clearing Fields] else //Handle no records found end if Dj Link to comment Share on other sites More sharing options...
cjaeger Posted April 28, 2003 Share Posted April 28, 2003 you could also do a SetField [field1, """"] (That's four quotes). Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7859 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now