二字符串之間 資料提取 (14001)

C2=TRIM(RIGHT(SUBSTITUTE(LEFT(A1,FIND("discount_sell_list",A1)-1),"show_time",REPT(" ",999)),999))

另解=TRIM(MID(SUBSTITUTE(SUBSTITUTE(A1,"discount_sell_list","show_time"),"show_time",REPT(" ",999)),999,999))

另解=MID(A1,FIND("show_time",A1)+LEN("show_time"),FIND("discount_sell_list",A1)-FIND("show_time",A1)-LEN("show_time"))