用replace就可以了 REPLACE(REPLACE(REPLACE(${利润},"(¥","-"),"¥",""),")","")
赞 0 踩 0 2023-12-03 22:24
太复杂,不如使用外部工具,如power query清洗后导入
赞 0 踩 0 2023-04-18 16:20
可以用截取或者添加字符的功能嘛
赞 0 踩 0 2023-01-29 12:16
可以的,您根据您的情况调整即可~
赞 0 踩 0 2023-02-14 10:48
4 评论
用replace就可以了
REPLACE(REPLACE(REPLACE(${利润},"(¥","-"),"¥",""),")","")
赞 0 踩 0 2023-12-03 22:24
太复杂,不如使用外部工具,如power query清洗后导入
赞 0 踩 0 2023-04-18 16:20
可以用截取或者添加字符的功能嘛
赞 0 踩 0 2023-01-29 12:16
可以的,您根据您的情况调整即可~
赞 0 踩 0 2023-02-14 10:48