Python将所有单词都剪切到两个字符串之间

Question

除了使用python3的第一行之外，有人能帮我剪切JOIN和ON关键字之间的所有字符串吗？你知道吗

分配给变量的输入数据

input_txt=
date_dim date_dim_all
INNER JOIN main_fact_response
  ON (date_dim_all.response_date = main_fact_response.response_date)
LEFT JOIN dim_fore_main
  ON (dim_fore_main.id = fact_fore_respond.id)
LEFT JOIN fact_fore_resi
  ON (fact_fore_resi.fore_re = fact_fore_respond.fore_re
INNER JOIN fact_fore_respond fact_fore_respond_merit
  ON (
      fact_fore_respond_merit.fore_respond = fact_fore_r
espond.fore_respond

输出数据

date_dim date_dim_all,
main_fact_response,
dim_fore_main,
fact_fore_resi,
fact_fore_respond fact_fore_respond_merit

Answer 1

 input_data = '''date_dim date_dim_all
    INNER JOIN main_fact_response
      ON (date_dim_all.response_date = main_fact_response.response_date)
    LEFT JOIN dim_fore_main
      ON (dim_fore_main.id = fact_fore_respond.id)
    LEFT JOIN fact_fore_resi
      ON (fact_fore_resi.fore_re = fact_fore_respond.fore_re
    INNER JOIN fact_fore_respond fact_fore_respond_merit
      ON (
          fact_fore_respond_merit.fore_respond = fact_fore_r
    espond.fore_respond'''  


input_data = input_data.replace("JOIN","cuthere")
input_data = input_data.replace("ON","cuthere")
data_list = input_data.split('cuthere')
data_list = data_list[1::2]
#The Next Part Of The Code Is Needed Only Because Your String Is Multiline .
i = 0
for i < len(data_list):
      data_list[i] = data_list[i].strip()