{"id":23,"date":"2009-04-15T14:55:27","date_gmt":"2009-04-15T19:55:27","guid":{"rendered":"http:\/\/appcrawler.com\/wordpress\/?p=23"},"modified":"2011-07-06T09:55:22","modified_gmt":"2011-07-06T14:55:22","slug":"oracle-regular-expressions","status":"publish","type":"post","link":"http:\/\/appcrawler.com\/wordpress\/2009\/04\/15\/oracle-regular-expressions\/","title":{"rendered":"Oracle regular expressions"},"content":{"rendered":"

A recent question on CDOS was regarding how to have only one space at the end of a CSV output row. Below was my response…<\/p>\n

SQL> create table t1110(c varchar2(10))\r\n  2  \/\r\n<\/span> \r\n\r\nTable created.\r\n<\/span> \r\n\r\nSQL> insert into t1110 values('1')\r\n  2  \/\r\n<\/span> \r\n\r\n1 row created.\r\n<\/span> \r\n\r\nSQL> insert into t1110 values('2    ')\r\n  2  \/\r\n<\/span> \r\n\r\n1 row created.\r\n<\/span> \r\n\r\nSQL> insert into t1110 values('3 new  ')\r\n  2  \/\r\n<\/span> \r\n\r\n1 row created.\r\n<\/span> \r\n\r\nSQL> column len format 9\r\nSQL> column orig format a10\r\nSQL> column newone format a10\r\nSQL> column new_len format 9\r\nSQL> set trims off\r\nSQL> select length(c) len,\r\n  2         c orig,\r\n  3         regexp_replace(c, '\\W+$', ' ') newone,\r\n  4         length(regexp_replace(c, '\\W+$', ' ')) new_len\r\n  5     from t1110\r\n  6  \/\r\n<\/span> \r\n\r\nLEN ORIG       NEWONE     NEW_LEN\r\n--- ---------- ---------- -------\r\n  1 1          1                1\r\n  5 2          2                2\r\n  7 3 new      3 new            6\r\n<\/span>\r\nSQL><\/span><\/pre>\n","protected":false},"excerpt":{"rendered":"
A recent question on CDOS was regarding how to have only one space at the end of a CSV output row. Below was my response… SQL> create table t1110(c varchar2(10)) 2 \/ Table created. SQL> insert into t1110 values(‘1’) 2…<\/p>\n
Read more →<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"footnotes":""},"categories":[19,22],"tags":[],"_links":{"self":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/23"}],"collection":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/comments?post=23"}],"version-history":[{"count":4,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/23\/revisions"}],"predecessor-version":[{"id":1305,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/23\/revisions\/1305"}],"wp:attachment":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/media?parent=23"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/categories?post=23"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/tags?post=23"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}