使用正则表达式处理配置单元中的特殊字符

我有这样的数据。


+--------------+--------------+-------------+------------+----------+--------------+-----------------+-----------------+-----------------+-----------------------+---------------------------+----------+
|     label    |     ent      |   custom1   |  account   | custom2  |     icp      |   created_by    |   approved_by   |    posted_by    |      date_posted      |        description        | group_1  |
+--------------+--------------+-------------+------------+----------+--------------+-----------------+-----------------+-----------------+-----------------------+---------------------------+----------+
| FB_FR_SE_1�  | 0418 - NORW  | D_ADJ_USD�  | 06D24CLS�  | acc�     | [ICP None]�  | lbryan46@LDAP�  | lbryan46@LDAP�  | pprzyboc@LDAP�  | 7/5/2019 3:29:00 PM�  | Credit Loss Translation�  | FCEB�    |

我要删除尾部特殊字符

谢谢。

zhibudao 回答:使用正则表达式处理配置单元中的特殊字符

使用regexp_replace

select regexp_replace('FB_FR_SE_1�','�','');

结果:

FB_FR_SE_1
本文链接:https://www.f2er.com/3111706.html

大家都在问