title: Regular expression to find separator dots in formula
body: <p>The C# expression library I am using will not directly support my table/field parameter syntax:</p>
  
  <p>The following are table/field parameter names that are not directly supported:</p>
  
  <pre><code>TableName1.FieldName1
  [TableName1].[FieldName1]
  [Table Name 1].[Field Name 1]
  </code></pre>
  
  <p>It accepts alphanumeric parameters without spaces, or most characters enclosed within square brackets.  I would like to use C# regular expressions to replace the dot separators and neighboring brackets to a different delimiter, so the results would be as follows:</p>
  
  <pre><code>[TableName1|FieldName1]
  [TableName1|FieldName1]
  [Table Name 1|Field Name 1]
  </code></pre>
  
  <p>I also need to skip any string literals within single quotes, like:</p>
  
  <pre><code>'TableName1.FieldName1'
  </code></pre>
  
  <p>And, of course, ignore any numeric literals like:</p>
  
  <pre><code>12345.6789
  </code></pre>
  
  <p>EDIT: Thank you for your feedback on improving my question.  Hopefully it is clearer now.</p>