I need to convert a (wild) text field into separate records.
In the actual situation each records is different and may have up to 6 dates with following text
For example the text field could be:
15-09-18 child has entered third class. 15-10-16 has high fever and cannot go to school. 15-12-18 has been tested for dyslexia.
I need to convert that text creating separate records having dates and text in new proper fields, such as:
TEXT_FIELD: child has entered third class.
TEXT_FIELD: has high fever and cannot go to school.
TEXT_FIELD: has been tested for dyslexia.
Anyone may help please ?