Regular Expressions 101

Community Patterns

create dictionary in VBA from two or three columns of data

0

Regular Expression
PCRE (PHP <7.3)

/
(?sx) ^([^\t\n]+?)\t (?: (?| # branch reset: both captures go to Group 1 ([^\t\n]+)(?=\n.*(")) | ([^\t\n]+)\t([^\t\n]+)$(?=.*(".+?")(")) ) )
/
gsm

Description

Don't forget to add the following line at the end of your source text " & Constants.vbNewLine & ""

Submitted by anonymous - 5 years ago