regex101: MM101

^start of line

.*any character (except for line terminators), repeated any number of times

TELEPHONE NUMBERthe literal text TELEPHONE NUMBER (case sensitive)

Group 1(.*)

.*any character (except for line terminators), repeated any number of times

DATE ACCOUNT OPENEDthe literal text DATE ACCOUNT OPENED (case sensitive)

Group 2(.*)

.*any character (except for line terminators), repeated any number of times

LANG CODEthe literal text LANG CODE (case sensitive)

Group 3(.*)

.*any character (except for line terminators), repeated any number of times

CHAIN CODEthe literal text CHAIN CODE (case sensitive)

Group 4(.*)

.*any character (except for line terminators), repeated any number of times

TRANSIT ROUTING NUMthe literal text TRANSIT ROUTING NUM (case sensitive)

Group 5(.*)

.*any character (except for line terminators), repeated any number of times

DATE OF LAST REVIEWthe literal text DATE OF LAST REVIEW (case sensitive)

Group 6(.*)

.*any character (except for line terminators), repeated any number of times

DATE OF NEXT REVIEWthe literal text DATE OF NEXT REVIEW (case sensitive)

Group 7(.*)

.*any character (except for line terminators), repeated any number of times

ALT TRANSIT ROUTING NUMthe literal text ALT TRANSIT ROUTING NUM (case sensitive)

Group 8(.*)

.*any character (except for line terminators), repeated any number of times

AVERAGE FLOAT DAYSthe literal text AVERAGE FLOAT DAYS (case sensitive)

Group 9(.*)

.*any character (except for line terminators), repeated any number of times

SPECIAL CONTROL FLAGSthe literal text SPECIAL CONTROL FLAGS (case sensitive)

Group 10(.*)

.*any character (except for line terminators), repeated any number of times

SEASONAL MERCHANTthe literal text SEASONAL MERCHANT (case sensitive)

Group 11(.*)

.*any character (except for line terminators), repeated any number of times

STATEMENT HOLD CODEthe literal text STATEMENT HOLD CODE (case sensitive)

Group 12(.*)

.*any character (except for line terminators), repeated any number of times

SEND ACQUIRERthe literal text SEND ACQUIRER (case sensitive)

Group 13(.*)

.*any character (except for line terminators), repeated any number of times

STATEMENT MAIL FLAGthe literal text STATEMENT MAIL FLAG (case sensitive)

Group 14(.*)

.*any character (except for line terminators), repeated any number of times

MONTHLY ACH FLAGthe literal text MONTHLY ACH FLAG (case sensitive)

Group 15(.*)

.*any character (except for line terminators), repeated any number of times

MERCHANT NAMEthe literal text MERCHANT NAME (case sensitive)

Group 16(.*)

.*any character (except for line terminators), repeated any number of times

MERCHANT TYPEthe literal text MERCHANT TYPE (case sensitive)

Group 17(.*)

.*any character (except for line terminators), repeated any number of times

DDA NUMBERthe literal text DDA NUMBER (case sensitive)

Group 18(.*)

.*any character (except for line terminators), repeated any number of times

ALT DDA NUMBERthe literal text ALT DDA NUMBER (case sensitive)

Group 19(.*)

.*any character (except for line terminators), repeated any number of times

AUTH INC GRIDthe literal text AUTH INC GRID (case sensitive)

Group 20(.*)

.*any character (except for line terminators), repeated any number of times

AUTH EXP GRIDthe literal text AUTH EXP GRID (case sensitive)

Group 21(.*)

.*any character (except for line terminators), repeated any number of times

CROSS REFERENCE NOthe literal text CROSS REFERENCE NO (case sensitive)

.any character (except for line terminators)

Group 22(.*)

.*any character (except for line terminators), repeated any number of times

ETC NON FDR FLAGthe literal text ETC NON FDR FLAG (case sensitive)

Group 23(.*)

.*any character (except for line terminators), repeated any number of times

ETC VENDOR IDthe literal text ETC VENDOR ID (case sensitive)

Group 24(.*)

.*any character (except for line terminators), repeated any number of times

SALES RESPONSIBILITYthe literal text SALES RESPONSIBILITY (case sensitive)

Group 25(.*)

.*any character (except for line terminators), repeated any number of times

USER DEF INC GRIDthe literal text USER DEF INC GRID (case sensitive)

Group 26(.*)

USER DEF EXP GRIDthe literal text USER DEF EXP GRID (case sensitive)

Group 27(.*)

TAXPAYER IDthe literal text TAXPAYER ID (case sensitive)

Group 28(.*)

ACCOUNT1 FEE FLAGthe literal text ACCOUNT1 FEE FLAG (case sensitive)

Group 29(.*)

ACCOUNT1 STARTthe literal text ACCOUNT1 START (case sensitive)

Group 30(.*)

STOPthe literal text STOP (case sensitive)

Group 31(.*)

MRCH ADV FLAGthe literal text MRCH ADV FLAG (case sensitive)

Group 32(.*)

ACCOUNT2 FEE FLAGthe literal text ACCOUNT2 FEE FLAG (case sensitive)

Group 33(.*)

ACCOUNT2 STARTthe literal text ACCOUNT2 START (case sensitive)

Group 34(.*)

STOPthe literal text STOP (case sensitive)

Group 35(.*)

TERMINAL STARTthe literal text TERMINAL START (case sensitive)

Group 36(.*)

STOPthe literal text STOP (case sensitive)

Group 37(.*)

ACCOUNT3 FEE FLAGthe literal text ACCOUNT3 FEE FLAG (case sensitive)

Group 38(.*)

ACCOUNT3 STARTthe literal text ACCOUNT3 START (case sensitive)

Group 39(.*)

STOPthe literal text STOP (case sensitive)

Group 40(.*)

SPARK EXCLUSION CDthe literal text SPARK EXCLUSION CD (case sensitive)

Group 41(.*)

ACCOUNT4 FEE FLAGthe literal text ACCOUNT4 FEE FLAG (case sensitive)

Group 42(.*)

ACCOUNT4 STARTthe literal text ACCOUNT4 START (case sensitive)

Group 43(.*)

STOPthe literal text STOP (case sensitive)

Group 44(.*)

PAYEE FLAG CDthe literal text PAYEE FLAG CD (case sensitive)

Group 45(.*)

ACCOUNT5 FEE FLAGthe literal text ACCOUNT5 FEE FLAG (case sensitive)

Group 46(.*)

ACCOUNT5 STARTthe literal text ACCOUNT5 START (case sensitive)

Group 47(.*)

STOPthe literal text STOP (case sensitive)

Group 48(.*)

EIDS INDthe literal text EIDS IND (case sensitive)

Group 49(.*)

RECURRING FEE FLAGthe literal text RECURRING FEE FLAG (case sensitive)

Group 50(.*)

RECURRING FEE INDthe literal text RECURRING FEE IND (case sensitive)

Group 51(.*)

BUW INDICATORthe literal text BUW INDICATOR (case sensitive)

Group 52(.*)

TURF CDthe literal text TURF CD (case sensitive)

Group 53(.*)

TURF EFF DTthe literal text TURF EFF DT (case sensitive)

Group 54(.*)

TAX EFF YEARthe literal text TAX EFF YEAR (case sensitive)

Group 55(.*)

BANKCARD DBAthe literal text BANKCARD DBA (case sensitive)

Group 56(.*)

TIMS ACCT IDthe literal text TIMS ACCT ID (case sensitive)

Group 57(.*)

RETAIL DBAthe literal text RETAIL DBA (case sensitive)

Group 58(.*)

CUST BUSINESS IDthe literal text CUST BUSINESS ID (case sensitive)

Group 59(.*)

CUST BUS RELATIONSHIP CDthe literal text CUST BUS RELATIONSHIP CD (case sensitive)

Group 60(.*)

DEPOSIT TYPEthe literal text DEPOSIT TYPE (case sensitive)

Group 61(.*)

ETC ACCOUNT TYPEthe literal text ETC ACCOUNT TYPE (case sensitive)

Group 62(.*)

DEVICE TYPEthe literal text DEVICE TYPE (case sensitive)

Group 63(.*)

EXCLUDE ADJ FLAGthe literal text EXCLUDE ADJ FLAG (case sensitive)

Group 64(.*)

MCthe literal text MC (case sensitive)

\/the literal / (47₁₀ / 57₈ / 2F₁₆)

V POSthe literal text V POS (case sensitive)

Group 65(.*)

DISCOUNT CALCULATIONthe literal text DISCOUNT CALCULATION (case sensitive)

Group 66(.*)

ROUND DISCOUNTthe literal text ROUND DISCOUNT (case sensitive)

Group 67(.*)

REBATE DISTRIBUTEthe literal text REBATE DISTRIBUTE (case sensitive)

Group 68(.*)

REBATE OPTIONthe literal text REBATE OPTION (case sensitive)

Group 69(.*)

REBATE PERIODthe literal text REBATE PERIOD (case sensitive)

Group 70(.*)

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

Search reference

Regular Expression

^.*TELEPHONE NUMBER(.*)DATE ACCOUNT OPENED(.*)LANG CODE(.*)CHAIN CODE(.*)TRANSIT ROUTING NUM(.*)DATE OF LAST REVIEW(.*)DATE OF NEXT REVIEW(.*)ALT TRANSIT ROUTING NUM(.*)AVERAGE FLOAT DAYS(.*)SPECIAL CONTROL FLAGS(.*)SEASONAL MERCHANT(.*)STATEMENT HOLD CODE(.*)SEND ACQUIRER(.*)STATEMENT MAIL FLAG(.*)MONTHLY ACH FLAG(.*)MERCHANT NAME(.*)MERCHANT TYPE(.*)DDA NUMBER(.*)ALT DDA NUMBER(.*)AUTH INC GRID(.*)AUTH EXP GRID(.*)CROSS REFERENCE NO.(.*)ETC NON FDR FLAG(.*)ETC VENDOR ID(.*)SALES RESPONSIBILITY(.*)USER DEF INC GRID(.*)USER DEF EXP GRID(.*)TAXPAYER ID(.*)ACCOUNT1 FEE FLAG(.*)ACCOUNT1 START(.*)STOP(.*)MRCH ADV FLAG(.*)ACCOUNT2 FEE FLAG(.*)ACCOUNT2 START(.*)STOP(.*)TERMINAL START(.*)STOP(.*)ACCOUNT3 FEE FLAG(.*)ACCOUNT3 START(.*)STOP(.*)SPARK EXCLUSION CD(.*)ACCOUNT4 FEE FLAG(.*)ACCOUNT4 START(.*)STOP(.*)PAYEE FLAG CD(.*)ACCOUNT5 FEE FLAG(.*)ACCOUNT5 START(.*)STOP(.*)EIDS IND(.*)RECURRING FEE FLAG(.*)RECURRING FEE IND(.*)BUW INDICATOR(.*)TURF CD(.*)TURF EFF DT(.*)TAX EFF YEAR(.*)BANKCARD DBA(.*)TIMS ACCT ID(.*) RETAIL   DBA(.*)CUST BUSINESS ID(.*)CUST BUS RELATIONSHIP CD(.*)DEPOSIT TYPE(.*)ETC ACCOUNT TYPE(.*)DEVICE TYPE(.*)EXCLUDE ADJ FLAG(.*)MC\/V POS(.*)DISCOUNT CALCULATION(.*)ROUND DISCOUNT(.*)REBATE DISTRIBUTE(.*)REBATE OPTION(.*)REBATE PERIOD(.*)

Test String
New

0                                                   TELEPHONE NUMBER  612-874-8702            DATE ACCOUNT OPENED  01/27/14
 LANG CODE - EN                                     CHAIN CODE                                TRANSIT ROUTING NUM   96001013
 DATE OF LAST REVIEW 00/00                          DATE OF NEXT REVIEW   01/15               ALT TRANSIT ROUTING NUM
 AVERAGE FLOAT DAYS  00-00                          SPECIAL CONTROL FLAGS                     SEASONAL MERCHANT    NO
 STATEMENT HOLD CODE Y - SEND ACQUIRER              STATEMENT MAIL FLAG   M - MERCH ADDRESS   MONTHLY ACH FLAG     1 - MERCHANT NAME
 MERCHANT TYPE       REGULAR                        DDA NUMBER            12000069001         ALT DDA NUMBER
 AUTH INC GRID       P801                           AUTH EXP GRID          000                CROSS REFERENCE NO.   0000326
 ETC NON FDR FLAG    N                              ETC VENDOR ID                             SALES RESPONSIBILITY  0001
 USER DEF INC GRID    000                           USER DEF EXP GRID      000                TAXPAYER ID   30-0016022
 ACCOUNT1 FEE FLAG 3                                ACCOUNT1 START 00/00  STOP 00/00          MRCH ADV FLAG        0
 ACCOUNT2 FEE FLAG 1                                ACCOUNT2 START 00/00  STOP 00/00          TERMINAL START 00/00  STOP 00/00
 ACCOUNT3 FEE FLAG 1                                ACCOUNT3 START 00/00  STOP 05/17          SPARK EXCLUSION CD   N
 ACCOUNT4 FEE FLAG 0                                ACCOUNT4 START 00/00  STOP 00/00          PAYEE FLAG CD   S
 ACCOUNT5 FEE FLAG 1                                ACCOUNT5 START 00/00  STOP 00/00          EIDS IND   N
 RECURRING FEE FLAG                                 RECURRING FEE IND                         BUW INDICATOR
 TURF CD A                                          TURF EFF DT 00/00/0000                    TAX EFF YEAR 0000
 BANKCARD DBA - ACADIA CAFE              /MINNEAPOLIS  /MN                                    TIMS ACCT ID O0529808390100022000
 RETAIL   DBA - ACADIA CAFE              MINNEAPOLIS  MN
 CUST BUSINESS ID                                   CUST BUS RELATIONSHIP CD
 - - - - - - - - - - - - - - - - - - - - - - - - - - - -  MERCHANT OPTIONS  - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 DEPOSIT TYPE        3 - ETC                        ETC ACCOUNT TYPE      7 - RESERVED        DEVICE TYPE          NONE
                                                    EXCLUDE ADJ FLAG      Y - EXCL ADJ/CB     MC/V POS             0922
 DISCOUNT CALCULATION -  2  ROUND DISCOUNT -  N
 REBATE DISTRIBUTE                                  REBATE OPTION         N - NO REBATE       REBATE PERIOD

Regular Expressions 101

Regular Expression

Test String
New

Substitution
Processing...

Regular Expression

Test StringNew

SubstitutionProcessing...

Test String
New

Substitution
Processing...