AnsweredAssumed Answered

Extract dates from text field

Question asked by Wicktor on Feb 8, 2019
Latest reply on Feb 8, 2019 by anothersmurf

Hello,

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:

 

record#1

DATE_FIELD: 15-09-18

TEXT_FIELD: child has entered third class.

 

record#2

DATE_FIELD: 15-10-16

TEXT_FIELD: has high fever and cannot go to school.

 

record#3

DATE_FIELD: 15-12-18

TEXT_FIELD: has been tested for dyslexia.

 

Anyone may help please ?

Wictor

Outcomes