Text field with a date embedded in some records

[Stickybeak]

I retrieve email records into a database for a to do list.

The body of the email becomes the task.

I want to be able to send emails to the databse with a date in the subject. I used "***dd/mm/yyyy***" as a pattern in another database so that when this pattern appeared in the body it was extracted and placed in the due date field.

I am trying to work out how to do that. I use a script to import the emails into the tasks database and I would like to process the new revords by extracting any date and putting it in the due date.

 

Edited March 7 by Stickybeak

[comment]

I am not sure I understand your description.

It seems you have a text field that contains a pattern such as ***08/03/2024*** and you want to extract the date? Can there be more than one occurrence of such pattern in the same field? If not, you could try:

Let ( [
start = Position ( text ; "***" ; 1 ; 1 ) ;
end = Position ( text ; "***" ; 1 ; 2 )
] ;
If ( start and end ;
Middle ( text ; start + 3 ; end - start - 3 )
)
)

 

Edited March 7 by comment

[Stickybeak]

Excellent - yes there will only be one occurrence in the field.

Worked perfectly.

Thank you so much.