Hi all! I would like to use REGEXP_SUBSTR in Saved Search to get part of string in {memomain}. Can someone help and tell me how i would get:

Example company Plc

From String

Migration invoice. Original invoice id: 12345 for customer: Example company Plc

I think I need to find either the second 

:

 or then 

customer:

and select everything after that. Thank you!

You’d probably want to use REGEXP_REPLACE instead, looking for something like ‘.*customer: ’ and replacing with ‘’.

NVL(REGEXP_REPLACE(REGEXP_SUBSTR({memomain},': [^:]+*$'),': ',''),{memomain})

try that one, its probably close