이야봉 블로그

[쿼리]

SELECT SUBSTRING(A.PRODUCT FROM '\[(.*?)\]') AS PRODUCT_CODE,       
                 A.PRODUCT
FROM
      ( 
      	SELECT '[SM-G981N]갤럭시 S20' AS PRODUCT
        UNION ALL
      	SELECT '[SM-G991N]갤럭시 S21'
        UNION ALL
        SELECT '[SM-S901N]갤럭시 S22'
      ) A

[수행결과]

[참고]

https://popsql.com/learn-sql/postgresql/how-to-use-substring-with-regular-expressions-in-postgresql

http://daplus.net/regex-%EB%8C%80%EA%B4%84%ED%98%B8-%EC%82%AC%EC%9D%B4%EC%97%90%EC%84%9C-%ED%85%8D%EC%8A%A4%ED%8A%B8%EB%A5%BC-%EC%B6%94%EC%B6%9C%ED%95%98%EB%8A%94-%EC%A0%95%EA%B7%9C%EC%8B%9D/

https://namu.wiki/w/%EC%82%BC%EC%84%B1%20%EA%B0%A4%EB%9F%AD%EC%8B%9C/%EC%A0%9C%ED%92%88%20%EB%AA%A9%EB%A1%9D#s-1.1

A.xml

SELECT *
FROM T_01

SELECT *
FROM T_02

SELECT *
FROM T_03

B.xml

SELECT *
FROM V_01

SELECT *
FROM V_02

SELECT *
FROM V_03

C.xml

INSERT INTO T_01
VALUES ('A');

SELECT *
FROM T_02

SELECT *
FROM V_02

추출과정

1. 위 3개의 파일형식을 XML(3개) => TXT(3개)로 변경

D:\FolderName>ren *.xml *.txt

2. TXT파일(3개) => TXT파일(1개)로 병합(ABC.txt)

  bluefive.pairsite.com/txtcollector.htm

3. ABC.txt(병합 완료)

d:\prac\xmlS\A.xml
************************************************************************
<!-- A.xml -->
SELECT *
FROM T_01

SELECT *
FROM T_02

SELECT *
FROM T_03


d:\prac\xmlS\B.xml
************************************************************************
<!-- B.xml -->

SELECT *
FROM V_01

SELECT *
FROM V_02

SELECT *
FROM V_03


d:\prac\xmlS\C.xml
************************************************************************
<!-- C.xml -->

INSERT INTO T_01
VALUES ('A');

SELECT *
FROM T_02

SELECT *
FROM V_02

Java로 추출작업 수행

4. txt파일을 FileReader로 한 Line씩 추출하여, List1에 담기

5. Line별로 시작단어가 T_ 이거나, V_인 경우를 List2에 담기

6. List2에서 중복제거

추출결과

T_01
T_02
T_03
V_01
V_02
V_03

참조링크

 bluefive.pairsite.com/txtcollector.htm

editorizer.tistory.com/240

jeong-pro.tistory.com/69

www.dante2k.com/444

m.blog.naver.com/pgh7092/221130579329