Need regular expression to identify records

Database
Enthusiast

Need regular expression to identify records

Can anyone help me in identifying the records of this format

########      this_is_a_record.sh      ########

 I have tried many options but nothing works.

Tags (1)
1 REPLY
Enthusiast

Re: Need regular expression to identify records

Select 
Case when
Character_length(
Oreplace
('string start ########      this_is_a_record.sh      ######## strng end',
'########      this_is_a_record.sh      ########',
''))
<
Character_length('ABC ########      this_is_a_record.sh      ######## ABC')
then 'Rec found'
else 'Not found'
end

Hi, How about a combination of char_length & oreplace?