Regex Hive not working -
i trying extract 44
string
created rsa key 45555 intelligent expense id 44|54?hotel?345555|||||
using hive regexp_extract
.
the regex have (^\id\s)\d*
, not working.
can me please
^
marks beginning of string not case, because not start id
. can use
(id\s)\d*
for capturing numbers after id
, should use \d+
instead of \d*
id\s(\d+)
this capturing group can accessed using 1
mentioned here
Comments
Post a Comment