importing csv directly on a form

[DeanRowe]

Hi,

I have information in a csv format, like this:

Name,surname,address,postcode,telephone

I have a memo field on my form which shows this data - currently I am cutting and pasting the name, telephone details into the relevant fields on my form.

It’s quite time consuming and I was looking to cut this down - is there any way to automatically copy and paste the data into the fields on the form using coding? Can coding be used to detect the commas and paste the name data into the name field, surname data into the surname field etc.

Any help, advice, alternate ideas or ways of doing this would be greatly appreciated.

Thanks for your time.

Dean Rowe

 

[aziz rasul]

Why can't u import the csv file into the table directly? The data would then be split into the relevant fields.

 

[DeanRowe]

Hi Aziz,

Thank you for your reply. The reason why is because the csv data is sent to me in an email from a web form - some customers type out their address with commas, for example:

Joe Bloggs,
50 ABC Street
Gatling
Anywhere
West Yorkshire,
WY34 45BW

is sometimes written as:

Joe Bloggs,
50 ABC Street,
Gatling,
Anywhere,
West Yorkshire,
WY34 45BW

and it plays havoc with imports, plus it involves saving the email, then closing the form we use while it imports and then loading up the form again so the data is shown. By simply copying and pasting the details in the email into a memo field, we have everything there on the form - plus we can edit out the commas before the import takes place. It would just be a more convenient way of doing it for us without having to keep saving the email and then closing and loading the forms while the import takes place and allows us to edit the info before the import (that way if anything goes wrong like we don't spot a comma we'll realise why straight away when one of the fields is empty or an error pops up).

Any ideas would be greatly appreciated.

Cheers

Dean