批量替换文本中的多组字符串

【问题】

hi friends, I have the following demand and I want to know if you have any suggestions for me:
I want to REPLACE certain strings from one text file with corresponding strings stored in another text file (one to one matching), and save to a new text file (override the original file is also acceptable).
I want to know what is the best programming language to handle this task? all opinions are welcome and appreciated.
If I only had limited knowledge of C programming, html, php, would you list Python as a recommendation for me to handle this problem?
Thank you all.

【回答】

       要想批量替换多组字符串,python用两层循环可以实现,对于初学者来说代码比较难写。可以考虑SPL,不需要循环就能实现,脚本如下:


A

1

=file("e:\\condition.txt").import@t()

2

=A1.iterate(replace(~~,before,after),file("e:\\source.txt").read())

3

=file("e:\\result.txt").write(A2)

A1:读取condition.txt文本,返回序表,其中有before列和after

A2:循环A1,将file("e:\\source.txt").read()字符串中的某些子串批量替换成其他字符串,待替换的子串就是before列的字符串,替换的子串为after列对应的字符串

A3:将批量替换完的字符串结果写入result.txt文本中

 

       如果文件太大无法放入内存,那不论是python还是c都很难用双层循环简单实现了,代码会更加复杂。集算器提供游标读取大文件,易于实现批量替换,具体脚本如下:


A

B

1

=file("e:\\condition.txt").import@t()


2

=file("e:\\source.txt").cursor@s()


3

for A2,1000


4


=A3.(_1).concat(“\r\n”)

5


=A1.iterate(replace(~~,before,after),B4)

6


=file("e:\\result.txt").write@a(B5)

A1读取condition.txt文本,返回序表,其中有before列和after

A2:读取source.txt文本,返回游标,游标内容为单字段串序表

A3:对A2游标循环分段读取,每次读取1000条记录

B4:读取_1列列值,并按照换行分隔符拼成一个字符串

B5:对A1循环,将B4字符串中的某些子串批量替换成其他字符串

待替换的子串就是before列的字符串,替换的子串为after列对应的字符串

B6:把每次替换完的字符串B5追加写入result.txt文本中

写好的脚本如何在应用程序中调用,可以参考Java 如何调用 SPL 脚本