我有这样的数据。
+--------------+--------------+-------------+------------+----------+--------------+-----------------+-----------------+-----------------+-----------------------+---------------------------+----------+
| 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� |
我想删除尾随特殊字符 �
提前谢谢。
1条答案
按热度按时间juud5qan1#
使用
regexp_replace
:结果: