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文本中