Regex : expression to match specific word

user_15001482 0
Viewed 74

I have a regex replace function:

reg_replac​e(Input_Colu​mn,'\b(?:(?!https|www|http)\w)+\b', 'x')

With www.google.com input, the result is www.x.x where as it should be www.xxxxxx.xxx.

Please help me to write a regex which works by letters and not by words.

informatica regex
1 Answers

Use

\w(?!\w*\b(?<=\bhttps|\bwww|\bhttp))

See proof

Explanation

--------------------------------------------------------------------------------
  \w                       word characters (a-z, A-Z, 0-9, _)
--------------------------------------------------------------------------------
  (?!                      look ahead to see if there is not:
--------------------------------------------------------------------------------
    \w*                      word characters (a-z, A-Z, 0-9, _) (0 or
                             more times (matching the most amount
                             possible))
--------------------------------------------------------------------------------
    \b                       the boundary between a word char (\w)
                             and something that is not a word char
--------------------------------------------------------------------------------
    (?<=                     look behind to see if there is:
--------------------------------------------------------------------------------
      \b                       the boundary between a word char (\w)
                               and something that is not a word char
--------------------------------------------------------------------------------
      https                    'https'
--------------------------------------------------------------------------------
     |                        OR
--------------------------------------------------------------------------------
      \b                       the boundary between a word char (\w)
                               and something that is not a word char
--------------------------------------------------------------------------------
      www                      'www'
--------------------------------------------------------------------------------
     |                        OR
--------------------------------------------------------------------------------
      \b                       the boundary between a word char (\w)
                               and something that is not a word char
--------------------------------------------------------------------------------
      http                     'http'
--------------------------------------------------------------------------------
    )                        end of look-behind
--------------------------------------------------------------------------------
  )                        end of look-ahead
user_113298900
Related