How do I sweep a string and bring different parts of it?

0

Using REGEX is it possible to "concatenate" masks to bring different parts of the same string?

How do I sweep a string and bring different parts of it?

  • I have a text field with the following information:

      

    00200.035219 / 2012-15 (VOLUME 1)

  • I want the return to be exactly like this:

      

    00200.035219 / 2012-15; 1

The information you have after the semicolon is always about the volume number.

I'm using PL / SQL and REGEX.

    
asked by anonymous 26.01.2018 / 17:46

0 answers