Jump to content
Salesforce and other SMB Solutions are coming soon. ×

I cannot seem to include text function Trim in a script.


daffodil
 Share

Recommended Posts

I created an Access database in 2003 and am now attempting to convert it to Filemaker Pro 12. There must be a very simple answer to this, but I have looked everywhere. I cannot include the Text Function Trim into a script -- the function name does not appear in the left pane of the script writer. Please tell me what I am missing! Thank you.

Link to comment
Share on other sites

I cannot include the Text Function Trim into a script -- the function name does not appear in the left pane of the script writer.

 

You cannot add Trim() (or any other function) directly to a script, because a script consists of steps (commands).

 

Compared with “conventional” programming languages, the difference is akin to the one between a statement and an expression.

 

What you can do is use Trim() (or any other function) in a step that uses a calculation; so you would have something like:

 

Replace Field Contents [ no dialog;

target field: YourTable::yourField ;

calculated result: Trim ( YourTable::yourField )

]

 

where a calculation is used to get the result that is used in the command.

 

If you don't know the difference between a script step and a function, I suggest you study some introductory material.

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share



×
×
  • Create New...

Important Information

Terms of Use