How to split value in single quotes after specific string

ok my bad one mistake from my end

Cannot add user ‘abc’, user is already a member of ‘Test_Sanjeer’ (“.” is not there after user in such errors when it contains extra line as “already member of”

give me revised expression