使用regex处理配置单元中的特殊字符

iqih9akk  于 2021-06-25  发布在  Hive
关注(0)|答案(1)|浏览(401)

我有这样的数据。

+--------------+--------------+-------------+------------+----------+--------------+-----------------+-----------------+-----------------+-----------------------+---------------------------+----------+
|     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�    |

我想删除尾随特殊字符 提前谢谢。

juud5qan

juud5qan1#

使用 regexp_replace :

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

结果:

FB_FR_SE_1

相关问题