title: Extract data from list using a delimiter
body: <p>I have a set of 10 python lists in the below format:</p>
  
  <pre><code>[ABC*DEF*123&gt;~123*999*HHH]
  [PQR*RST*567&gt;~AWS*999*POI]
  [XYZ*TGT*234&gt;~2352*245*HFT]
  [STU*DEF*789&gt;~654*345*QQQ]
  </code></pre>
  
  <p>I am trying to extract data from the above list such that the final output is a Dataframe and <strong>expect the below output</strong>:</p>
  
  <pre><code>123,999,HHH
  AWS,999,POI
  2352,245,HFT
  654,345,QQQ
  </code></pre>
  
  <p>Given below is what I have done thus far:</p>
  
  <pre><code>allFiles = Path where all the txt files are stored
  list_ = []
  for file_ in allFiles:
      with open(file_) as fp:
          lines1 = fp.read().split('\n')
          b = [i.split('~', 1)[1] for i in lines1]
          print(b)
  </code></pre>
  
  <p>The above gives me a list as below:</p>
  
  <pre><code>[123*999*HHH]
  [AWS*999*POI]
  [2352*245*HFT]
  [654*345*QQQ]
  </code></pre>
  
  <p>I am unable to extract the above data using a delimiter (*) and split them into different columns and have this saved to a Dataframe</p>