Jump to content

Copy and paste and deleting text space


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

Recommended Posts

Hello Forum

Hope you can help me on this one.

I have to copy and paste about 200 contacts and whenever I do this the address line places the text into the address fields with a space which I have to then delete.

E.G

123 the Avenue

is pasted as

_123 the Avenue

_ = space

Is there a function that will automatically delete the space?

Hope you understand.

Thanks

Martin

Link to comment
Share on other sites

Check out the Trim Function. It removes Preceding and Trailing spaces. There has also been some creative Posts to handle multiple spaces using the Substitute Function.

HTH

Lee

Link to comment
Share on other sites

You can use the Trim function in a Replace Field Contents step to modify the address field for all the records in your database. Use the calculated replace option to enter the formula. Make sure you have a backup before using Replace Field Contents. It can't be undone. Also, Replace Field Contents only works on the current found set. It's probably best just to show all records since the Trim function won't cause problems with addresses that don't have leading or trailing spaces.

Edited by Guest
Link to comment
Share on other sites

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

Create an account or sign in to comment

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

Create an account

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

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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