Monday, August 12, 2013

Regex spliting the obs level in clarity

,regexp_substr(s_ndo.PATH,'[^/]+',1,6) OBSLevel6 ,regexp_substr(s_ndo.PATH,'[^/]+',1,5) OBSLevel5 ,regexp_substr(s_ndo.PATH,'[^/]+',1,4) OBSLevel4