Regular Expressions 101

Explanation

Pro

\ban ASCII word boundary

Non-Capturing Group(?:\w+\.)?

?repeats the group contents below at most once:

\w+any word character, repeated at least once

\.the literal . (46₁₀ / 56₈ / 2E₁₆)

Negated Character Class[^\W_]+

+matches at least one character outside the set below:

\Wany non-word character

_the literal _ (95₁₀ / 137₈ / 5F₁₆)

Non-Capturing Group(?:_[^\W_]+)*

*repeats the group contents below any number of times:

_the literal _ (95₁₀ / 137₈ / 5F₁₆)

Negated Character Class[^\W_]+

+matches at least one character outside the set below:

\Wany non-word character

_the literal _ (95₁₀ / 137₈ / 5F₁₆)

__cthe literal text __c (case sensitive)

\ban ASCII word boundary

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

Match Information

Detailed match information will be displayed here automatically.

Quick Reference

25 tokens

Regular Expression

\b(?:\w+\.)?[^\W_]+(?:_[^\W_]+)*__c\b

New

FFX_GLAAssetDisposalID__c
FAM__Asset_Sub_Group__r.PNL_On_Asset_Disposal_GL_Account__c
Product2.SalesRevenueAccount__c

ffbext__codabecashmatchingreport
Product2.c2g__CODASalesRevenueAccount__c

Extraction

FFX_GLAAssetDisposalID__c
FAM__Asset_Sub_Group__r.PNL_On_Asset_Disposal_GL_Account__c
Product2.SalesRevenueAccount__c

ffbext__codabecashmatchingreport
Product2.c2g__CODASalesRevenueAccount__c