Extracting string between multiple occurrence of same delimiter in python pandas

Question

Column "Test" has strings with multiple occurrence of same delimiter. Am trying to fetch the string which is within those delimiters. Can you please help.

Example:

Test
|||||CHNBAD||POC-RM0EP7-01-A

My code:

df["Fetch"]=df["Test"].str.rsplit("|", 2).str[-2]

But its giving me an output as POC-RM0EP7-01-A.

Am looking to get "CHNBAD" from the string

Answer 1

With your shown samples, please try following. We could use str.extract function pf Pandas here. Applying str.extract function on Test column and creating new column named Fetch in DataFrame.

df['Fetch'] = df['Test'].str.extract(r'^\|+([^|]*)\|.*',expand=False)

DataFrame's will be as follows:

    Test                            Fetch
0   |||||CHNBAD||POC-RM0EP7-01-A    CHNBAD

Explanation of regex:

^\|+     ##Matching 1 or more matches of | from starting of value.
([^|]*)  ##Creating 1st capturing group which has everything till next | comes.
\|.*     ##Matching | and everything till last of value.