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

Trim functions


Recommended Posts

Hi, really appreciate any help. I'm using FM version 9 and have built a calculation field that I would like to show addresses without any spaces.

The original data was imported from various excel files. I also have a field that shows concatenated addresses..and they look identical, but when I look at the calculated field, some of those same addresses have spaces between the city and zip code etc....but not all.

My goal is use duplicate find, so I can remove duplicate addresses. I tried on the concatenated field, but the return was terrible...so I thought I'd build a calculated field to resolve unknown differences...but these spaces show up..how do I apply the trim function to the formula so that the spaces go away?


Many, many thanks, Bruce

Link to comment
Share on other sites

Hi, and thanks for the help.


I have an address field that has addresses that look like:

1234 Sunset Blvd.

1234 Sunset Blvd.

1234 Sunset Blvd.

I'd like to delete all of these duplicates (note; they come from different excel files)....but when I do a find, I only get two of the three results.


So....I thought I'd create a calculation field (without spaces would be fine), to get rid of the unseen gremlins, and I get:



1234Sunset Blvd.


I'd sure like to get rid of the space, so the duplicate request can recognize all three as the same. Which got me to the trim idea, but unsure how to apply it to the calculation....Bruce

Any ideas

Link to comment
Share on other sites

The Trim function removes leading and trailing spaces, so " trim this " becomes "trim this"


That doesn't help with your examples, but the Substitute function mentioned by AHunter3 does what you need. That still won't allow your search for duplicates to find Boulevard vs. Blvd. or Avenue vs. Ave or Ave. You may have to do some further Substituting.

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.

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.

  • Create New...

Important Information

Terms of Use