trim()不能出去掉字段的前后空格_postgresql trim 去除字段中的空格失效-CSDN博客

本文链接：https://blog.csdn.net/weixin_43260719/article/details/121381958

博客内容提到在处理字段时，trim()方法未能有效移除前后空格。解决方案是找到正确的方法来清除这些空格，例如使用正则表达式。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

select TRIM(HIS_PTN_NBR),TRIM(HIS_CAS_DTE),TRIM(HIS_CAS_TIM),TRIM(HIS_XAC_IDT),TRIM(HIS_CAS_SEQ) from ABCODB00.ABC_SSK_HIS_T WHERE HIS_CAS_DTE = '20211116';

没有清除掉空格

TRIM(HIS_PTN_NBR)	TRIM(HIS_CAS_DTE)	TRIM(HIS_CAS_TIM)	TRIM(HIS_XAC_IDT)	TRIM(HIS_CAS_SEQ)
11	20211116	092633	0199484914001001	CO8W
11	20211116	100116	0199418098001001	7UV2
11	20211116	100201	0199322666001001	966K
11	20211116	100258	0199306192001001	EFPN
11	20211116	100340	0199117088001001	HO7D
11	20211116	100424	0199117088001001	GBFO
11	20211116	112730	0101011132080001	2WD8
11	20211116	112733	0140000982003001	6I9Q
11	20211116	201932	0101011132080001	8ZEM
11	20211116	201936	0140000982003001	90D4

select TRIM(HIS_PTN_NBR)||'|'||TRIM(HIS_CAS_DTE)||'|'||TRIM(HIS_CAS_TIM)||'|'||TRIM(HIS_XAC_IDT)||'|'||TRIM(HIS_CAS_SEQ) from ABCODB00.ABC_SSK_HIS_T WHERE HIS_CAS_DTE = '20211116';

清除掉了空格。’|'指分隔符是|

TRIM(HIS_PTN_NBR)	TRIM(HIS_CAS_DTE)	TRIM(HIS_CAS_TIM)	TRIM(HIS_XAC_IDT)	TRIM(HIS_CAS_SEQ)
11	20211116	092633	0199484914001001	CO8W
11	20211116	100116	0199418098001001	7UV2
11	20211116	100201	0199322666001001	966K
11	20211116	100258	0199306192001001	EFPN
11	20211116	100340	0199117088001001	HO7D
11	20211116	100424	0199117088001001	GBFO
11	20211116	112730	0101011132080001	2WD8
11	20211116	112733	0140000982003001	6I9Q
11	20211116	201932	0101011132080001	8ZEM
11	20211116	201936	0140000982003001	90D4