word vba 如何查找出一个字符串中包括了多少个指定子字符串？

Sub at()

aaaa = "ASDFSF。ASDF。SDF。234。'XCV。d"

'第1种方法
bbb = Replace(aaaa, "。", "")
cccc = Split(aaaa, "。")
CS1 = Len(aaaa) - Len(bbb)


'第2种方法
CS2 = UBound(Split(aaaa, "。"))

End Sub

第1种方法，主要使用了replace函数和len函数。

对比替换前后的字符串的长度差值，该差值即是。

 

第2种方法：

使用split函数后，用ubound函数求出得到数组的上标数值。

该上标值即是。

1.使用正则re查找文本中特定中文字符串
#coding:utf-8
 
import re  
temp = "s2f程序员杂志一2d3程序员杂志二2d3程序员杂志三2d3程序员杂志四2d3"  
findword=u"(杂志+)"  #需要查找的特定中文字符串
pattern = re.compile(findword)  
results =  pattern.findall(temp)  
for result in results :  
	print result

输出如下：



2.查找的目标文件line的内容”OUSER.LAST_LAST_POST=xxxxxx”，就是查找这个文档中的所有短信验证码是多少。
import re

line = "OTOPIC.TGNUM=1.000|OUSER.FANS=7034.000|OUSER.LAST_LAST_POST=1536738413.000|OUSER.LEVEL=1.000|\
    OUSER.SCF=1.000|OUSER.URANK=33.000|OUSER.USTATE=524288.000|OUSER.USUD=1552277017.000|\
    OUSER.UTYPE=16448.000(adc_user)|OUSER.VALID_FANS=1297.000|OUSER.VTYPE=2.000|OUSER.ZCF=3.000|\
    PIC.EWADS=327.000(327.000000)|PIC.EWADS_WEIGHT=327.000|PIC.FIGS=1.000(001000082216010170003018078190193003)|\
    PIC.MINUP=2.000|PIC.MWADS_RADIO=1.000|PIC.NUM=1.000(4011677ely1g0yym6fib3j20u0140wia)|PIC.PWS=2.203|\
    PIC.WADS=327.000(整体厨房|定制|定制|卧室)|PIC.WADS_RADIO=1.000|PIC.WAMAX=327.000|PIC.WAMIN=327.000|\
    PROBA.CHEAT=0.000|PROBA.LOWQ=0.000|QI.NEW=304.000|SOURCE.SCORE=78.000"

findword = u"(OUSER.LAST_LAST_POST=+\d\d\d\d\d\d\d\d\d\d)"#匹配后面10个数字
pattern = re.compile(findword)
result = pattern.findall(line)
print(result)


运行结果如下：



如果有多个OUSER.LAST_LAST_POST，则会全部输出

3.查找的目标文件logyzm.txt的内容”您的验证码是..........”,这个字段后面单行所有内容
#!/usr/nbin/python
# --*-- coding:utf-8 --*--
import re
 
logyzm = open("/root/python/dinpay/logyzm.txt").read()
#print logyzm
temp = logyzm.decode("utf8")
findword = u"(您的验证码是.+)"# .+表示匹配至少一个任意字符
#findword = u"(.+您的验证码是.+)"#表示取有“您的验证码是”字符串的这行所有数据
pattern = re.compile(findword)
results = pattern.findall(temp)
for result in results:
	print result


 

4.去除重复的数据，显示为一个列表
#!/usr/nbin/python  
# --*-- coding:utf-8 --*--  
import re  
 
lastlist = []
logyzm = open("/usr/local/tomcat_corp/logs/catalina.out").read()  
#print logyzm  
temp = logyzm.decode("utf8")  
findword = r'bankCode=.{100}'#取该字符串以及其后面100个字符数据
pattern = re.compile(findword)  
results = re.findall(pattern,temp)  
for result in results:  
    #print result
    lastlist.append(result)
 
list = set(lastlist)#对重复数据进行去重处理
for l in list:
    print l


5.取有某个特定字符串的前几位与后几位数据
#!/usr/nbin/python  
# --*-- coding:utf-8 --*--  
import re  
 
lastlist = []
logyzm = open("/usr/local/tomcat_corp/logs/catalina.out").read()  
#print logyzm  
temp = logyzm.decode("utf8")  
findword = r'.{75}bankCode=.{100}'#取该字符串的前面75个字符数据以及其后面100个字符数据
pattern = re.compile(findword)  
results = re.findall(pattern,temp)  
for result in results:  
    #print result
    lastlist.append(result)
 
list = set(lastlist)#对重复数据进行去重处理
for l in list:
    print l


 

转自：http://www.pinlue.com/article/2018/09/1514/087188585901.html

1.在vim 编辑器里查找某一字符串：


  
/content enter


如：在编辑mylog.log文件时，查找”hello”字符串，上下翻页实在太长，可以用以下方式：

/hello #向下搜索

?hello #向上搜索

2.查找某个文件里是否包含字符串 : grep “content” filename

如，在mylog.log里查找”hello“：


  
grep “hello” mylog.log


若是要显示”hello”是文件里的行数，则添加参数  -n：


  
grep -n “hello” mylog.log


忽略大小写添加 -i：


  
grep -i “hello” mylog.log


显示行数又忽略大小写 -ni：


  
grep -ni “hello” mylog.log


以下是所有的参数介绍



Regexp selection and interpretation:
  -E, --extended-regexp     PATTERN is an extended regular expression (ERE)
  -F, --fixed-strings       PATTERN is a set of newline-separated fixed strings
  -G, --basic-regexp        PATTERN is a basic regular expression (BRE)
  -P, --perl-regexp         PATTERN is a Perl regular expression
  -e, --regexp=PATTERN      use PATTERN for matching
  -f, --file=FILE           obtain PATTERN from FILE
  -i, --ignore-case         ignore case distinctions
  -w, --word-regexp         force PATTERN to match only whole words
  -x, --line-regexp         force PATTERN to match only whole lines
  -z, --null-data           a data line ends in 0 byte, not newline

Miscellaneous:
  -s, --no-messages         suppress error messages
  -v, --invert-match        select non-matching lines
  -V, --version             display version information and exit
      --help                display this help text and exit

Output control:
  -m, --max-count=NUM       stop after NUM matches
  -b, --byte-offset         print the byte offset with output lines
  -n, --line-number         print line number with output lines
      --line-buffered       flush output on every line
  -H, --with-filename       print the file name for each match
  -h, --no-filename         suppress the file name prefix on output
      --label=LABEL         use LABEL as the standard input file name prefix
  -o, --only-matching       show only the part of a line matching PATTERN
  -q, --quiet, --silent     suppress all normal output
      --binary-files=TYPE   assume that binary files are TYPE;
                            TYPE is 'binary', 'text', or 'without-match'
  -a, --text                equivalent to --binary-files=text
  -I                        equivalent to --binary-files=without-match
  -d, --directories=ACTION  how to handle directories;
                            ACTION is 'read', 'recurse', or 'skip'
  -D, --devices=ACTION      how to handle devices, FIFOs and sockets;
                            ACTION is 'read' or 'skip'
  -r, --recursive           like --directories=recurse
  -R, --dereference-recursive
                            likewise, but follow all symlinks
      --include=FILE_PATTERN
                            search only files that match FILE_PATTERN
      --exclude=FILE_PATTERN
                            skip files and directories matching FILE_PATTERN
      --exclude-from=FILE   skip files matching any file pattern from FILE
      --exclude-dir=PATTERN directories that match PATTERN will be skipped.
  -L, --files-without-match print only names of FILEs containing no match
  -l, --files-with-matches  print only names of FILEs containing matches
  -c, --count               print only a count of matching lines per FILE
  -T, --initial-tab         make tabs line up (if needed)
  -Z, --null                print 0 byte after FILE name

Context control:
  -B, --before-context=NUM  print NUM lines of leading context
  -A, --after-context=NUM   print NUM lines of trailing context
  -C, --context=NUM         print NUM lines of output context
  -NUM                      same as --context=NUM
      --group-separator=SEP use SEP as a group separator
      --no-group-separator  use empty string as a group separator
      --color[=WHEN],
      --colour[=WHEN]       use markers to highlight the matching strings;
                            WHEN is 'always', 'never', or 'auto'
  -U, --binary              do not strip CR characters at EOL (MSDOS/Windows)
  -u, --unix-byte-offsets   report offsets as if CRs were not there
                            (MSDOS/Windows)

符加一项查找文件命令，可以用 find

如：查找mylog.log文件：


  
find / -name mylog.log