Click here to Skip to main content
15,393,706 members
Home / Discussions / Regular Expressions
   

Regular Expressions

 
GeneralRe: Pattern Check Match Pin
Member 1567083112-Jun-22 8:13
MemberMember 1567083112-Jun-22 8:13 
GeneralRe: Pattern Check Match Pin
Member 1567083112-Jun-22 7:32
MemberMember 1567083112-Jun-22 7:32 
GeneralRe: Pattern Check Match Pin
Member 1567083112-Jun-22 11:49
MemberMember 1567083112-Jun-22 11:49 
AnswerRe: Pattern Check Match Pin
Peter_in_278012-Jun-22 12:36
professionalPeter_in_278012-Jun-22 12:36 
GeneralRe: Pattern Check Match Pin
Member 1567083112-Jun-22 13:46
MemberMember 1567083112-Jun-22 13:46 
GeneralRe: Pattern Check Match Pin
Peter_in_278012-Jun-22 15:42
professionalPeter_in_278012-Jun-22 15:42 
QuestionAdresse erfassen mittels RegEx Pin
Member 156568991-Jun-22 3:26
MemberMember 156568991-Jun-22 3:26 
AnswerRe: Adresse erfassen mittels RegEx Pin
OriginalGriff1-Jun-22 1:53
mveOriginalGriff1-Jun-22 1:53 
To be honest, unless your addresses are pretty rigidly controlled, you are probably on a loser even trying: Extract addressline, state, city, zipcode into different columns from one single column called “adress” with space as delimeter using posgresql[^]

But ...
(?<Name>.+?)\r\n(?<Street>.+?)\r\n(?<Zip>\d+?)\s+(?<Town>.+)
May do it ... I needed to play with regex options Mutiline = true, SingleLine = true and change "$" to "\r\n" to get it working in Expresso.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!

GeneralRe: Adresse erfassen mittels RegEx Pin
Member 156568991-Jun-22 11:39
MemberMember 156568991-Jun-22 11:39 
GeneralRe: Adresse erfassen mittels RegEx Pin
OriginalGriff1-Jun-22 18:59
mveOriginalGriff1-Jun-22 18:59 
AnswerRe: Adresse erfassen mittels RegEx Pin
Richard MacCutchan1-Jun-22 22:01
mveRichard MacCutchan1-Jun-22 22:01 
GeneralRe: Adresse erfassen mittels RegEx Pin
Member 156568992-Jun-22 10:20
MemberMember 156568992-Jun-22 10:20 
Questionget parent LDAP DN - regex Pin
nExoR LU13-May-22 5:12
MembernExoR LU13-May-22 5:12 
AnswerRe: get parent LDAP DN - regex Pin
Richard Deeming15-May-22 21:40
mveRichard Deeming15-May-22 21:40 
GeneralRe: get parent LDAP DN - regex Pin
nExoR LU15-May-22 21:47
MembernExoR LU15-May-22 21:47 
QuestionRegular Expressions RegEx - Wildcards for route patterns Pin
Member 1563258311-May-22 6:05
MemberMember 1563258311-May-22 6:05 
QuestionDoubt in Regular Expression Pin
Member 156250644-May-22 20:09
MemberMember 156250644-May-22 20:09 
AnswerRe: Doubt in Regular Expression Pin
Richard Deeming4-May-22 21:17
mveRichard Deeming4-May-22 21:17 
QuestionRegex Lazy Match Zero or More Times (*?) Pin
Member 155940887-Apr-22 2:52
MemberMember 155940887-Apr-22 2:52 
AnswerRe: Regex Lazy Match Zero or More Times (*?) Pin
k50547-Apr-22 4:17
mvek50547-Apr-22 4:17 
GeneralRe: Regex Lazy Match Zero or More Times (*?) Pin
Member 155940887-Apr-22 10:45
MemberMember 155940887-Apr-22 10:45 
Questiondetect and extract phone numbers Pin
aristosv30-Mar-22 23:02
Memberaristosv30-Mar-22 23:02 
AnswerRe: detect and extract phone numbers Pin
jsc427-Apr-22 6:46
professionaljsc427-Apr-22 6:46 
QuestionMatch all lines except lines beginning with numbers or a few alphabets Pin
Diamond Dallas30-Mar-22 3:06
MemberDiamond Dallas30-Mar-22 3:06 
Questionfinding repetead pattern Pin
Member 1556742215-Mar-22 6:19
MemberMember 1556742215-Mar-22 6:19 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.