I have a notes field in the customer table that is a memo field. An example of one customer's notes field data :
<div>20.3.14 Ordered 2 cartons</div>
<div>4.3.14 Ordered 2 cartons</div>
<div>18.2.14 ordered 1 carton</div>
<div>30.1.14 ordered 3 cartons SCENTED wipes</div>
<div>14.1.14 ordered 1 carton</div>
<div>12/12/13 - Ordered 3 cartons to get through Jan 13.</div>
<div>26/11 - Ordered 2 cartons</div>
<div>12/11/13 - one carton</div>
<div>28/10/13 - Mandy still has two cartons.</div>
<div>15/8/13 – Natalie ordered 1 ctn Uns.</div>
I want to extract the date to append to a date field in a "Calls" table and the comment into a text field in the "Calls" table. Is there a way I can do this via query or code?
<div>20.3.14 Ordered 2 cartons</div>
<div>4.3.14 Ordered 2 cartons</div>
<div>18.2.14 ordered 1 carton</div>
<div>30.1.14 ordered 3 cartons SCENTED wipes</div>
<div>14.1.14 ordered 1 carton</div>
<div>12/12/13 - Ordered 3 cartons to get through Jan 13.</div>
<div>26/11 - Ordered 2 cartons</div>
<div>12/11/13 - one carton</div>
<div>28/10/13 - Mandy still has two cartons.</div>
<div>15/8/13 – Natalie ordered 1 ctn Uns.</div>
I want to extract the date to append to a date field in a "Calls" table and the comment into a text field in the "Calls" table. Is there a way I can do this via query or code?