Member Avatar for end3r

Hi,

I have a string like this: ABC_STRING_DEF_GHI_JKL. Where the "STRING" part is constant.

I am trying to get its corresponding regex pattern.
Something like

%_STRING_%_%_%

So far I managed to get to this point:

SELECT 1 FROM DUAL WHERE REGEXP_LIKE('abc_STRING_def_ghi_jkl', '(^(\w[^_])+)_STRING_([^_]+)_([^_]+)_([^_]+)$');

It's not really working, so if you have any idea, please help!

Thanks,
Ender

Edited by end3r
  • 2 Contributors
  • 1 Reply
  • 133 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by pritaeas
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.