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

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

You want to use TrimAll(theField ; 0 ; 0 )

Trim will delete all spaces between the words IN the address field as well. :wink2:

Thanks for that it works a treat.

Just one thing how do I correct all the other address labels that I did before with this function?

Regards,

Martin

Um, you used Trim() on them? Do you have a backup copy?

NO

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 May 11, 200619 yr by Guest

Correct. I have no idea where my mind was on this one. I've been working with Substitute() too much today.