var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I'm importing data that is formatted with a (-) for example 1234-4567 and want to remove the (-) upon importing. I'm assuming this can be done with a calculation but not sure how - I've just begun using FM. Thanks, R
1 option, off the top of my head. If you have fm7 or 8
Set one extra field as a calculation, evaluate and replace always, with Substitute importfield;"-";"" if you want the "-" to disappear.
There are too many ways to do this with an existing field, so a calculation field seems the simplest for an import.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors