I have a field where I've stored the name of approving a task.
Scenarios will be stored all the information about the approval.
Now I want to have everything filtered out so I only see the name of the person - how do I do it?
I have a field where I've stored the name of approving a task.
Scenarios will be stored all the information about the approval.
Now I want to have everything filtered out so I only see the name of the person - how do I do it?
Hi Bente Bang Gormsen,
You really need to provide more and better info for community members to be able to understand your situation and help you.
Cheers,
Rick
I have this approver text in a column(variable)
Godkendt/afvist af: D100B001d-shpnintextest (Godkend) 28-03-2017 12:03 - 28-03-2017 12:04 (Bente Bang Gormsen)
And only wanted to se the name 'Bente Bang Gormsen'
I save Approvers Comments in a field - but later on I only wants to show the Name
Regular expresions to the rescue
([^()]+)$
^^ will show: (Bente Bang Gormsen)
I do not know now form my head how to remove the parentheses but perhaps that is something for you to find out.
You can check your regular expression at: http://www.regexr.com/
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.