Removing blank space

By topjobs
January 16, 2007 in Calculation Engine (Define Fields)

Share

https://fmforums.com/topic/49178-removing-blank-space/

This topic is 6582 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi,

I need to remove and replace blank space in an address field. Ex: 100 Main Street becomes 100+Main+Street

THank you.

Substitute ( Trim ( Address ) ; " " ; "+" )

Posted January 16, 2007

Thank you !!

This topic is 6582 days old. Please don't post here. Open a new topic instead.

You need to be a member in order to leave a comment

Sign up for a new account in our community. It's easy!

Already have an account? Sign in here.

Sign In Now

Share

https://fmforums.com/topic/49178-removing-blank-space/

×

×

By using this site, you agree to our Terms of Use.

I accept