Validation by calculation

[woodman35]

Hello:

I need to validate a field that will not allow the user to enter one or more spaces trailing the entry or one that will trim the spaces on entry.

Don't know exactly how to accomplish this.

Thanks

JW

[LaRetta]

Instead of using validation, which will disrupt data entry, you might just include an auto-enter (*replace) calculation on the field with:

Trim ( Self )

* uncheck 'do not replace existing value if any' so it fires after any modification. This will also remove beginning spaces.

[woodman35]

Thanks a million LaRetta this works much better than what i came up with.

only problem I dont know scripting syntax to combine two functions in same calculation. Just stacking up

Trim(Self)

Substitute (Self; "¶"; "")

FMP wants an operator.

How do i combine both of these functions in a calculation

thanks so much

JW

[comment]

How do i combine both of these functions in a calculation

By nesting, e.g.=

Substitute ( Trim ( Self ) ; ¶ ; "" )