从DB2列获取子字符串 [英] Get Substrings From DB2 Column

问题描述

我有:AAAA/DATA1/Data2; xyx; pqr这个数据我只想要: DATA1 和 Data2

I Have: AAAA/DATA1/Data2;xyx;pqr this data I want only:DATA1 And Data2

推荐答案

如果这是针对特定行的，是否可以使用 SUBSTR ?像

If this is for a specific row, maybe use SUBSTR? Something like

SELECT 
  SUBSTR(column, 6, 5) AS col1
, SUBSTR(column, 13, 5) AS col2
 FROM table

这是您可以做的其他事情.尽管它变得非常复杂，但这并不是您要查找的确切答案，但是它可以帮助您入门.希望这会有所帮助:

Here is something else you can do.. Although it gets pretty complicated, and this isn't the exact answer you are looking for but it will get you started. Hope this helps:

WITH test AS (
SELECT characters
  FROM ( VALUES
  (   'AAAA/DATA1/Data2;xyx;pqr'
  ) )
    AS testing(characters)
)
SELECT 
    SUBSTR(characters, 1, LOCATE('/', characters) - 1) AS FIRST_PART
  , SUBSTR(characters, LOCATE('/', characters) + 1) AS SECOND_PART
  , SUBSTR(characters, LOCATE('/', characters, LOCATE('/', characters) + 1) + 1) 
      AS THIRD_PART
    FROM test
;

不幸的是，

DB2没有单个功能.在这里查看答案:如何根据DB2中的定界符分割字符串值

这篇关于从DB2列获取子字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！