Me always try to Remember REGEX, but always Forget, so here is alternative as I am not ab REGEX expert.
If it Helps, Pl mark it Helpful and Correct to close Thread
REGEX Forum Help.twbx 9.6 KB
Thanks for the reply!
This solution would work but I failed to mention that the String is dynamic so the keys and values will be changing. I need a solution that does not contain hard-coded values.
Hi Matthew ,
I am able to get this using regex.
Get Key Stage:
Get Key Final:
LEFT([Get Key Stage],LEN([Get Key Stage])-1)
I have tested by adding another key value pairs able to get the O/P
hope this helps