å¯ä»¥ç¨SUBSTITUTEå½æ°
SUBSTITUTE(text,old_text,new_text,instance_num)
Text 为éè¦æ¿æ¢å
¶ä¸å符çææ¬ï¼æ对å«æææ¬çåå
æ ¼çå¼ç¨ã
Old_text 为éè¦æ¿æ¢çæ§ææ¬ã
New_text ç¨äºæ¿æ¢ old_text çææ¬ã
Instance_num 为ä¸æ°å¼ï¼ç¨æ¥æå®ä»¥ new_text æ¿æ¢ç¬¬å 次åºç°ç old_textãå¦ææå®äº instance_numï¼ååªæ满足è¦æ±ç old_text 被æ¿æ¢ï¼å¦åå°ç¨ new_text æ¿æ¢ Text ä¸åºç°çææ old_textã