Copy and paste and deleting text space

General support questions.
Posts: 2
Joined: Thu May 11, 2006 2:10 am
PostPosted: Thu May 11, 2006 12:20 pm
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
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Thu May 11, 2006 12:31 pm
Sure. Enter all your data then run a replace (From the menu, Records / Replace Field Contents) on the field using the Trim() function.

Or, change the address field to an auto enter calc that uses the Trim() function: be sure to uncheck "Do not replace existing value...".

You'll love it.
John Sindelar
SeedCode

Return to General Support

Who is online

Users browsing this forum: No registered users and 2 guests

cron
(855) SEEDCODE
[email protected]
Follow us: