Regex matching beginning AND end strings

Question

This seems like it should be trivial  but I m not so good with regular expressions  and this doesn t seem to be easy to Google   I need a regex that starts with the string  dbo   and ends with the string   fn   So far as I am concerned  I don t care what characters are in between these two strings  so long as the beginning and end are correct   This is to match functions in a SQL server database   For example   dbo functionName fn - Match  dbo  fn functionName - No Match  dbo functionName fn blah - No Match

User · Answer

Scanner scanner   new Scanner System in   String part   scanner nextLine    String line   scanner nextLine     String temp    quot   b quot    part   quot   quot   part    quot   b quot   Pattern pattern   Pattern compile temp toLowerCase     Matcher matcher   pattern matcher line toLowerCase      System out println matcher find      quot YES quot   quot NO quot     If you need  to determine if any of the words of this text start or end with the sequence  you can use this regex  bsubstring substring b anythingsubstring substringanything anythingsubstringanything

User · Answer

bdbo    fn   I was looking through a ton of java code for a specific library  car csclh server isr businesslogic TypePlatform  although I only knew car and Platform at the time   Unfortunately  none of the other suggestions here worked for me  so I figured I d post this    Here s the regex I used to find it    bcar    Platform

User · Answer

dbo     fn    This should work you

User · Answer

If you re searching for hits within a larger text  you don t want to use   and   as some other responders have said  those match the beginning and end of the text   Try this instead    bdbo   w  fn b    b is a word boundary  it matches a position that is either preceded by a word character and not followed by one  or followed by a word character and not preceded by one   This regex will find what you re looking for in any of these strings   dbo functionName fn foo dbo functionName fn bar  dbo functionName fn       but not in this one   foodbo functionName fnbar    w  matches one or more  word characters   letters  digits  or      If you need something more inclusive  you can try  S   one or more non-whitespace characters  or      one or more of any characters except linefeeds  non-greedily    The non-greedy    prevents it from accidentally matching something like dbo func1 fn dbo func2 fn as if it were just one hit

User · Answer

Well  the simple regex is this     dbo     fn     It would be better  however  to use the string manipulation functionality of whatever programming language you re using to slice off the first four and the last three characters of the string and check whether they re what you want

[regex] Regex matching beginning AND end strings

Examples related to regex