How to extract the string that occurs between the first single quote and then extract the string that occurs between the second single quote separately in a pandas dataframe. I have tried (\'(.*)\')
, but it extracts all strings between quotes regardless of the appearance.
Example:
This is 'Test1' and this is 'Test2'
I want first to extract Test1
and then extract Test2
separately.