How to separate out information in a string

[Dregerator]

Hi,

I have a string that is like this  Date : 2020/12/18Notes :this was done in July (WASH-797)/WASHER-797-LUV/p

What I would like is two variables that separate the information from Date part and Notes part i.e

Date                   Notes:

2020/12/18         this was done in July (WASH-797)/WASHER-797-LUV/p

Thank yo in advance

[AMSAS · Accepted solution]

You are probably going to need to look at PRXMATCH and the related functions