Is there a way I can take each entry in a memo field and put it into a text field in a separate table. The database is getting really big and the customer notes field for each record has lots of entries. The memo field looks like this:
8.4.14 Ordered 2 cartons
20.3.14 Ordered 2 cartons
4.3.14 Ordered 2 cartons
18.2.14 ordered 1 carton
30.1.14 ordered 3 cartons SCENTED wipes
14.1.14 ordered 1 carton
12/12/13 - Ordered 3 cartons to get through Jan 13.
26/11 - Ordered 2 cartons
12/11/13 - one carton
28/10/13 - Mandy still has two cartons.
15/8/13 – Natalie ordered 1 ctn Uns.
I want to take each line and put put the date in a date field and the text in a text field in a separate table linked by CustID. Is there a way to do that?
8.4.14 Ordered 2 cartons
20.3.14 Ordered 2 cartons
4.3.14 Ordered 2 cartons
18.2.14 ordered 1 carton
30.1.14 ordered 3 cartons SCENTED wipes
14.1.14 ordered 1 carton
12/12/13 - Ordered 3 cartons to get through Jan 13.
26/11 - Ordered 2 cartons
12/11/13 - one carton
28/10/13 - Mandy still has two cartons.
15/8/13 – Natalie ordered 1 ctn Uns.
I want to take each line and put put the date in a date field and the text in a text field in a separate table linked by CustID. Is there a way to do that?