The following RegEx Pattern ID's Constants in Excel Formulas. In addition, the Pattern appends the Operator (which actually preceeds the Constants in the Excel Formula) to the Constants and I would like the Operator to disappear as prepended of appended.

Possible candidates for deletion are: >>>> [^-+*/^<>=]+ [-+*/^<>]

Dim Pattern As String = "(-?(('[\s\S]*?'!\w+)|(\([\s\S]*?\))|([^-+*/^<>=]+)))([-+*/^<>][<>=]?|$)"

That said, in case I need a revised prepending-pattern in the future, I would like two solutions (Match Patterns) :

1) No Operators appended or Prepended at all (Constants only)

2) Operators (which precede the Constants in Excel Formulas) Prepended to the Constants

Thanks! Dennis

**View Complete Post**

## Regex pattern for validating IPv6

Can anyone can make a regular expression pattern for validating IPv6 (not IPv4)?

Ipv6 has many formats and aliases. I tried making the pattern but written in a lot of codes (i'm not sure my code below will be 100% accepting valid formats and 100% declines invalid formats).