Search value in the field after a character

[thatifc]

Good evening!
I need to get a data, but in the field I have other recorded information, and what "separates" this information is the comma. I want to pick up only what appears after the comma.
Thus:
'Example, test'

I want only the 'test' value ... The content until the virgulum is variable, so I can not use The substr.

Please, how could you do it?
: Roll:

Thank you!

[thatifc]

Ah! One more thing:
I can not use function, because I'm creating an ALERT (in ERP) and there only accepts the simple select ... I need to do the "treatment" in the same field.

[Trevisolli]

Thati, try this code:

Select all

 
DECLARE 
  v_string VARCHAR2(50) := 'Paulo;Trevisolli';  
BEGIN 
  dbms_output.put_line(' Depois do ponto e virgula : ' || SUBSTR(v_string,INSTR(v_string,';')+1,11)); 
END; 

Whatever it sends there.

[Hahu]

Speak thatifc,
Good afternoon,

So, make a selection of the column you need !!

Create a spool C: \ test.txt on SQLPlus and then open in Excel, separating by virgins from the Tools menu, importing external data, Deee you put the tab by ",": LOL:

any things, post here in the forum!

abs hahu

[thatifc]

Trevisolli and Hahu,

muito Thanks for the return !!
Here is the way I found to solve this pendenga:

Select all

 
Select Substr('Exemplo,Teste', Instr('Exemplo,Teste', ',')+1) 
  From Dual 

TKS !!
Thati

: Wink:

[ironijunior]

I have a very similar question:

In your case you searched for the second item of the "list", but if I had more than two items and wanted to seek only the second? Because the way you did it will return everything after the second.

Select all

Select Substr('Exemplo,Teste, Exemplo2', Instr('Exemplo,Teste,Exemplo2', ',')+1) 
  From Dual

This will return: "Test, Example2"

How could I do to seek only the test?

[adrianoturbo]

Ironijunior, just adjust the string incrementator, follow the example:

Select all

 
SQL> SELECT SUBSTR('Exemplo,Teste,Exemplo2',+9,5) FROM DUAL; 
 
SUBST 
----- 
Teste