title: Using Regex to capture numerics in different form
body: <p>We are receiving files sent by Margin Providers which includes the details of the Margin amount assigned to their accounts by honoring a particular format; We receive this as a <code>*.csv</code> file content. </p>
  
  <p>sample values are as like this (First row is header):</p>
  
  <blockquote>
    <p>DATE(DD/MM/YYYY),CLIENT NAME,CLIENT ID,BORROWING CAPACITY<br>
    27/11/2019,M/s  S.Smith &amp; SON (PVT) LTD,JKB1234LC,6000000.00<br>
    11/3/2020,XXXX Bank PLC / Dr. G. Smith,JKB12345LC,"10,000,000"<br>
    27/11/2019,Mrs. A. Smith &amp; Mrs. A.A.Smith,JKB11223LC,20000000.00<br>
    11/03/2020,Mr. C. Smith,JKB9087LC,0<br>
    27/11/2019,Mrs. I.A. Smith,JKB9876LC,0.00  </p>
  </blockquote>
  
  <p>I have used the following <code>Regex</code> expression to identify the Account and the Margin Value:</p>
  
  <pre><code>(?'Account'JKB[0-9]+LC)(?'Amount',(?&lt;=LC,)\d+\.\d*)
  </code></pre>
  
  <p>It is exactly capturing the Account but there were instances it does not capture the amount because it may be in Thousand separators or no decimal values or even inside single or double quotes etc. </p>
  
  <p>To solve this I am conceptualizing that I can do the following and continue with the same expression listed above:</p>
  
  <ol>
  <li>Identify the amount inside the quotes and remove the comma characters</li>
  <li>Then replace the single quotes or double quotes surrounding the amount and replace </li>
  <li>Then proceed with the same <code>Regex</code> expression</li>
  </ol>
  
  <p>But what I would like to do is build a single <code>Regex</code> expression to capture the Account and the Amount, where the Amount can be either inside a quote, double quote, with decimal or without a decimal or in thousand separators. However, I am finding it difficult to accommodate those scenarios into my <code>Regex</code> and seek your help.</p>
  
  <p>Here is my working:
  <a href="https://regex101.com/r/X6aq4g/1" rel="nofollow noreferrer">https://regex101.com/r/X6aq4g/1</a></p>