regex101: Michael's FP DB Install

(?i)applies the following effective flags to the remainder of the pattern: gmi

i modifier: insensitive. Matches without distinguishing uppercase and lowercase letters

Store number – the literal text Store number – (case insensitive)

Group 1([\d\D]*)

Character Class[\d\D]*

*matches any number of characters from the set below:

\da Unicode decimal digit

\Dany character that is not a Unicode decimal digit

\na line-feed (newline) character (ASCII 10)

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

StreetA – the literal text StreetA – (case insensitive)

Group 2([\d\D]*)

Character Class[\d\D]*

*matches any number of characters from the set below:

\da Unicode decimal digit

\Dany character that is not a Unicode decimal digit

\na line-feed (newline) character (ASCII 10)

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

City – the literal text City – (case insensitive)

Group 3([\d\D]*)

Character Class[\d\D]*

*matches any number of characters from the set below:

\da Unicode decimal digit

\Dany character that is not a Unicode decimal digit

\na line-feed (newline) character (ASCII 10)

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

State_id – the literal text State_id – (case insensitive)

Group 4([\d\D]*)

Character Class[\d\D]*

*matches any number of characters from the set below:

\da Unicode decimal digit

\Dany character that is not a Unicode decimal digit

\na line-feed (newline) character (ASCII 10)

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

Postal Code – the literal text Postal Code – (case insensitive)

Group 5([\d\D]*)

Character Class[\d\D]*

*matches any number of characters from the set below:

\da Unicode decimal digit

\Dany character that is not a Unicode decimal digit

\na line-feed (newline) character (ASCII 10)

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

Store Name – the literal text Store Name – (case insensitive)

Group 6([\d\D]*)

Character Class[\d\D]*

*matches any number of characters from the set below:

\da Unicode decimal digit

\Dany character that is not a Unicode decimal digit

\na line-feed (newline) character (ASCII 10)

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

Phone Number – the literal text Phone Number – (case insensitive)

Group 7([\d\D]*)

Character Class[\d\D]*

*matches any number of characters from the set below:

\da Unicode decimal digit

\Dany character that is not a Unicode decimal digit

\na line-feed (newline) character (ASCII 10)

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

Tax Ratesthe literal text Tax Rates (case insensitive)

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

\na line-feed (newline) character (ASCII 10)

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

Tax table 1 – the literal text Tax table 1 – (case insensitive)

Group 8([\d\D]*)

Character Class[\d\D]*

*matches any number of characters from the set below:

\da Unicode decimal digit

\Dany character that is not a Unicode decimal digit

\na line-feed (newline) character (ASCII 10)

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

Tax table 2 – the literal text Tax table 2 – (case insensitive)

Group 9([\d\D]*)

Character Class[\d\D]*

*matches any number of characters from the set below:

\da Unicode decimal digit

\Dany character that is not a Unicode decimal digit

\na line-feed (newline) character (ASCII 10)

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

Tax table 3 – the literal text Tax table 3 – (case insensitive)

Group 10([\d\D]*)

Character Class[\d\D]*

*matches any number of characters from the set below:

\da Unicode decimal digit

\Dany character that is not a Unicode decimal digit

\na line-feed (newline) character (ASCII 10)

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

Tax table 4 – the literal text Tax table 4 – (case insensitive)

Group 11([\d\D]*)

Character Class[\d\D]*

*matches any number of characters from the set below:

\da Unicode decimal digit

\Dany character that is not a Unicode decimal digit

\na line-feed (newline) character (ASCII 10)

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

Tax table 5 – the literal text Tax table 5 – (case insensitive)

Group 12([\d\D]*)

Character Class[\d\D]*

*matches any number of characters from the set below:

\da Unicode decimal digit

\Dany character that is not a Unicode decimal digit

\na line-feed (newline) character (ASCII 10)

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

Artistree vendor – the literal text Artistree vendor – (case insensitive)

Group 13([\d\D]*)

\na line-feed (newline) character (ASCII 10)

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

Store Group – the literal text Store Group – (case insensitive)

Group 14([\d\D]*)

\na line-feed (newline) character (ASCII 10)

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

Store Zone number – the literal text Store Zone number – (case insensitive)

Group 15([\d\D]*)

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

(?i)Store number – ([\d\D]*)\n.*StreetA – ([\d\D]*)\n.*City – ([\d\D]*)\n.*State_id – ([\d\D]*)\n.*Postal Code – ([\d\D]*)\n.*Store Name – ([\d\D]*)\n.*Phone Number – ([\d\D]*)\n.*Tax Rates.*\n.*Tax table 1 – ([\d\D]*)\n.*Tax table 2 – ([\d\D]*)\n.*Tax table 3 – ([\d\D]*)\n.*Tax table 4 – ([\d\D]*)\n.*Tax table 5 – ([\d\D]*)\n.*Artistree vendor – ([\d\D]*)\n.*Store Group – ([\d\D]*)\n.*Store Zone number – ([\d\D]*)

New

FP Team,

Please install the Live database for store 1384. The updates have been completed.

• Store number – 1384
• StreetA – 1275 York Rd, Ste 21A
• City – Gettysburg
• State_id – PA
• Postal Code – 17325-7565
• Store Name – Gettysburg, PA
• Phone Number – (717) 420-8200
• Tax Rates
        o Tax table 1 – 6.0000%
        o Tax table 2 – 0.0000%
        o Tax table 3 – 0.0000%
        o Tax table 4 – 0.0000%
        o Tax table 5 – N/A
• Artistree vendor – Kernersville
• Store Group – US.201308
• Store Zone number – 2030