Hi all,

Here's a challenge. I do have to do this in a project I'm working on though , so really do need some direction.

I have a Memobox on a Form in which we will copy and paste 6 lines of text - Name, Address1, Address2, Region, Email, Telephone.

I would like to do 2 things:
1. Extract Name, Region, Email, and Telephone
2. Split Name in to Surname and FirstName(including any initials)

Any ideas guys? I'm not looking for code, just directions and ideas. I've not worked with text and memo boxes, or Strings for that matter.

Thank you in advance.
Clinton

Clinton,
Where are you getting the lines to paste from?

Kevin

dartcoach

Hey Kevin,

Copy and pasted from and intranet page.

Cheers,
Clinton

Clinton,

Will there be any type of formatting from the intranet page?
I.E.
Line1: LastName,FirstName, MiddleInitial
Line2: Region

etc.

Kevin

dartcoach

Hi Kevin,

Name: Clinton Blah
Address: 123 The Road
RM12 4JP Mytown
Email: [email protected]
Telephone: 1236754987

This is how it translates to text... the forum does that... it would be in HTML in a table... hope that helps... Cheers

Cheers,
Clinton

Clinton,

I know it's late across the pond, but a couple of questions.

1. Is this data stored anywhere else after it's input?
2. Can you cut and paste me EXACTLY what the data would look like?

Kevin

dartcoach

Kevin,

How do you turn HTML on on here. Can you? I could paste it as it would be formatted. Only thing, if I use a memo box, it will change it to text. No?

To 1:
Yes - a table mtblContacts - fields: chrFirstName, chrSurname, chrEmail, chrRegion, chrTelephone

Hey, don't worry about the time. I'm working nightshift... And I really do appreciate your help...

Cheers,
Clinton

Ok,

Can you access the table mtblcontacts directly?

By they way - I sent you an email through the forum so if you can check your email, we can correspond outside the forum.

Kevin

dartcoach

Kevin,

Thank you for all your help. You are a star. Greatly appreciated.

Cheers,
Clinton