parsing a string in oracle sql

Question

I am wanting to parse a string within SQL, However, I am not sure how to go about doing so.

Here is my code:

 SELECT distinct sku, A_CLUSTER_DESC 
 FROM TOOL_SAS_DATA 
 WHERE sku in (1099895,
  1099896,
  1000960,
  1000960,
  1000898
  );

My output is:

  ||  sku  || A_Cluster_desc   ||

1 ||1099895|| 'GG SAS AP_1234 A'||

2 ||1099896|| 'GG SAS AP_1113 B'||

etc.

I am wanting to just output under A_Cluster_desc for it to say AP_1234 or AP_1113 and just excluding everything else around it.

EDIT:

Sorry if it wasn't more clear, I am wanting to just output AP_1234 or AP_####

Is it always going to be of the same pattern like AP_1234 including the prefix and suffix? — Blurryface
– Blurryface, Commented Feb 8, 2018 at 18:34

Barbaros Özhan · Accepted Answer · 2018-02-08 18:37:21Z

2

Just for A_CLUSTER_DESC part, use :

select regexp_substr(A_CLUSTER_DESC, '(.*?GG SAS )(.*?) ',1,1,'',2) from TOOL_SAS_DATA;

answered Feb 8, 2018 at 18:37

Barbaros Özhan

65.9k11 gold badges36 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1