Oracle regexp sample
/* Formatted on 05.07.2013 10:03:10 (QP5 v5.252.13127.32847) */ SELECT REGEXP_SUBSTR ( '20130704125118|2170391:100A2876|952828909|905337662754|aksa|0||0|ORG', '([^\|]*)\||$', 1, 5, NULL , 1) FROM DUAL ----- : aksa