reportlite_replace()

D

DocxChanger object.

a

A substring or a sequence of substrings of a source string to be replaced.

b

The target string or a sequence of strings.

@1

Replace the first substring only.

@c

Case insensitive.

@q

Do not replace the substring enclosed in quotation marks.

@w

Replace whole words only.

@s

Split sequence a and sequence b respectively as a sequence of single words and perform the replacement member by member in order.

A

1

=reportlite_open("D:\\wordFile.docx")

Read template file wordFile.docx.

2

=reportlite_replace(A1,"sql","SPL")

Replace substring “sql” in the whole text of the template file with target string “SPL”; case sensitive.

For example, the text is “第1个大写SQL，第2个大写Sql，第1个小写sql，第2个小写sql。”. Perform the replacement and it becomes “第1个大写SQL，第2个大写Sql，第1个小写SPL，第2个小写SPL。”.

3

=reportlite_replace@1(A1,"sql","SPL")

Replace the first substring “sql” in the whole text of the template file with target string “SPL”; case sensitive.

For example, the text is “第1个大写SQL，第2个大写Sql，第1个小写sql，第2个小写sql。”. Perform the replacement and it becomes “第1个大写SQL，第2个大写Sql，第1个小写SPL，第2个小写sql。”.

4

=reportlite_replace@c(A1,"sql","SPL")

Replace substring “sql” in the whole text of the template file with target string “SPL”; case insensitive.

For example, the text is “第1个大写SQL，第2个大写Sql，第1个小写sql，第2个小写sql。”. Perform the replacement and it becomes “第1个大写SPL，第2个大写SPL，第1个小写SPL，第2个小写SPL。”.

5

=reportlite_replace@q(A1,"sql","SPL")

Replace substring “sql” in the whole text of the template file with target string “SPL”; case sensitive, and won’t replace strings enclosed in quotation marks.

For example, the text is “引号内单词"SQL，sql，MySQL，mysql"，引号外单词SQL，sql，MySQL，mysql。”. Perform the replacement and it becomes “引号内单词"SQL，sql，MySQL，mysql"，引号外单词SQL，SPL，MySQL，mySPL。”.

6

=reportlite_replace@w(A1,"sql","SPL")

Replace substring “sql” in the whole text of the template file with target string “SPL”; case sensitive, and replace whole words only.

For example, the text is “引号内单词"SQL，sql，MySQL，mysql"，引号外单词SQL，sql，MySQL，mysql。”. Perform the replacement and it becomes “引号内单词"SQL，SPL，MySQL，mysql"，引号外单词SQL，SPL，MySQL，mysql。”.

7

=reportlite_replace(A1,["sql","报表"],["SPL","集算器"])

Replace substrings “sql” and “报表” in the whole text of the template file with target string “SPL” and “集算器”; case sensitive.

For example, the text is “启动报表工具，编写sql脚本，创建报表组文件。”. Perform the replacement and it becomes “启动集算器工具，编写SPL脚本，创建集算器组文件。”.

8

=reportlite_replace@s(A1,"sql,报表","SPL,集算器")

Split each of the sequences “sql,报表” and “SPL,集算器” into a sequence of single words and replace words in the former with those in the latter in order.

For example, the text is “启动报表工具，编写sql脚本，创建报表组文件。”. Perform the replacement and it becomes “启动集算器工具，编写SPL脚本，创建集算器组文件。”.

9

=reportlite_write(A1,"D:\\outFile.docx")