Regex match character after lazy grouping

Question

I want to match specifically the comma "," after the two groups ( AS) and (.*?). I have a positive lookbehind that skips the AS but I cant get the grouping to skip the wildcard lazy group.

Regex:

(?<= AS)(.*?)(,)

Sample text

    SELECT     LEFT(CustomerCode, 5) AS SMSiteCode, SUBSTRING(CustomerCode, 6, LEN(CustomerCode) - 5) AS SMCustCode, SUBSTRING(AgreeNo, 6, LEN(AgreeNo) - 5) 
                  AS SMAgreeNo, CAST(SeqNo AS int) AS SeqNo, SUBSTRING(TrxDate, 7, 2) + SUBSTRING(TrxDate, 4, 2) + SUBSTRING(TrxDate, 1, 2) AS TrxDate, TrxTime, 
                  CAST(Charge AS bit) AS Charge, CASE WHEN LEN(AnalysisCode) > 5 THEN SUBSTRING(AnalysisCode, 6, LEN(AnalysisCode) - 5) 
                  ELSE AnalysisCode END AS AnalysisCode, CAST(ISNULL(Description, N'') AS nvarchar(100)) AS Description, CAST(TaxAmt AS money) AS TaxAmt, 
                  CAST(TotAmt AS money) AS TotAmt, CAST(Match AS bigint) AS Match, CAST(Confirmed AS bit) AS Confirmed, CAST(Balance AS money) AS Balance, 
                  CAST(QtyBal AS money) AS QtyBal, CAST(ISNULL(Drawer, N'') AS nvarchar(50)) AS Drawer, SUBSTRING(DateBanked, 7, 2) + SUBSTRING(DateBanked, 4, 2) 
                  + SUBSTRING(DateBanked, 1, 2) AS DateBanked, CAST(ISNULL(BankBranch, N'') AS nvarchar(50)) AS BankBranch, CAST(Qty AS float) AS Qty, CAST(ISNULL(Narration, 
                  N'') AS nvarchar(100)) AS Narration, SUBSTRING(DateFrom, 7, 2) + SUBSTRING(DateFrom, 4, 2) + SUBSTRING(DateFrom, 1, 2) AS DateFrom, SUBSTRING(DateTo, 7, 2) 
                  + SUBSTRING(DateTo, 4, 2) + SUBSTRING(DateTo, 1, 2) AS DateTo, CAST(PrintNarration AS bit) AS PrintNarration, CAST(DiscAmt AS float) AS DiscAmt, 
                  CAST(ISNULL(CCAuthNo, N'') AS nvarchar(20)) AS CCAuthNo, CAST(ISNULL(CCTransID, N'') AS nvarchar(20)) AS CCTransID, CAST(UserLogin AS nvarchar(20)) 
                  AS UserLogin, CAST(Reconciled AS bit) AS Reconciled, SUBSTRING(DateReconciled, 7, 2) + SUBSTRING(DateReconciled, 4, 2) + SUBSTRING(DateReconciled, 1, 2) 
                  AS DateReconciled, CAST(PrimaryKey AS bigint) AS PrimaryKey, SUBSTRING(InvDate, 7, 2) + SUBSTRING(InvDate, 4, 2) + SUBSTRING(InvDate, 1, 2) AS InvDate, 
                  CAST(InvNo AS int) AS InvNo FROM         SomeDatabase.dbo.tblTransaction WHERE IsDate(trxTime) = 1

With .NET regex you could use a vaiable width lookbehind: (?<= AS.*?), — bobble bubble
– bobble bubble, Commented Aug 7, 2019 at 11:54

Ibrahim · Accepted Answer · 2019-08-07 05:11:34Z

1

You could try \K, but make sure to change Javescript in RegExr from top right of the screen to PCRE.

\K is defined as:

Sets the given position in the regex as the new "start" of the match. This means that nothing preceding the K will be captured in the overall match.

With \K, you could try something like this:

(?<= AS).*?\K(,)

Example: https://regex101.com/r/X3AdbH/1/

answered Aug 7, 2019 at 5:11

Ibrahim

6,1183 gold badges43 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

JReno Over a year ago

That works, thanks! Still strange that we can't use generic lookaheads or non-capturing groups for that

The fourth bird · Accepted Answer · 2019-08-07 10:36:42Z

1

If \K is supported, you could get your matches without using a lookbehind and a capturing group by matching AS and use a negated character class to match any char except a comma.

 AS [^,]+\K,

Explanation

AS Match space, AS and space
[^,]+ Match 1+ times any char except a comma
\K, Forget what was matched and match a comma

Regex demo

answered Aug 7, 2019 at 10:36

The fourth bird

165k16 gold badges61 silver badges75 bronze badges

Comments

Emma Marcier · Accepted Answer · 2019-08-07 05:08:41Z

0

I'm guessing that your expression is just fine, you maybe want to limit the first capturing group to some specific chars, if you wish, maybe looking like:

(?<= AS)([A-Za-z\d\s]+)(,)

The expression is explained on the top right panel of regex101.com, if you wish to explore/simplify/modify it, and in this link, you can watch how it would match against some sample inputs, if you like.

answered Aug 7, 2019 at 5:08

Emma Marcier

27.8k12 gold badges49 silver badges71 bronze badges

Collectives™ on Stack Overflow

Regex match character after lazy grouping

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related