What I am trying to do is delete the suite number of an address. However, not all addresses have suite numbers and I haven't figured out a way for the calculation to identify which records to edit and not edit. Each record that has a suite number has a "#" symbol after the address and before the suite number (e.g. 123 w main st # 200). Does anyone know of a way to remove/edit the suite number while leaving the non suite address records unchanged? Any suggestions would be greatly appreciated.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.