2018-4-2822:27 匹配EXCEL字符串

創(chuàng)新互聯(lián)服務(wù)項目包括洪澤網(wǎng)站建設(shè)、洪澤網(wǎng)站制作、洪澤網(wǎng)頁制作以及洪澤網(wǎng)絡(luò)營銷策劃等。多年來，我們專注于互聯(lián)網(wǎng)行業(yè)，利用自身積累的技術(shù)優(yōu)勢、行業(yè)經(jīng)驗、深度合作伙伴關(guān)系等，向廣大中小型企業(yè)、政府機構(gòu)等提供互聯(lián)網(wǎng)行業(yè)的解決方案，洪澤網(wǎng)站推廣取得了明顯的社會效益與經(jīng)濟效益。目前，我們服務(wù)的客戶以成都為中心已經(jīng)輻射到洪澤省份的部分城市，未來相信會繼續(xù)擴大服務(wù)區(qū)域并繼續(xù)獲得客戶的支持與信任！

=IF(AND((ISNUMBER(VALUE(RIGHT(LEFT(A2,2),2)))),(RIGHT(LEFT(A2,3),1)="/"),(ISNUMBER(VALUE(MID(A2,4,2)))),(RIGHT(LEFT(A2,6),1)="/"),(ISNUMBER(VALUE(MID(A2,7,4)))),(RIGHT(LEFT(A2,11),1)=""),(ISNUMBER(VALUE(MID(A2,12,2)))),(RIGHT(LEFT(A2,14),1)=":"),(ISNUMBER(VALUE(MID(A2,15,2)))),(RIGHT(LEFT(A2,17),1)=":"),(ISNUMBER(VALUE(MID(A2,18,2)))),(VALUE(RIGHT(LEFT(A2,2),2))<24),(VALUE(MID(A2,4,2))<31),(VALUE(MID(A2,7,4))<=YEAR(TODAY())),(VALUE(MID(A2,12,2))<24),(VALUE(MID(A2,15,2))<60),(VALUE(MID(A2,18,2))<60),(LEN(A2)=19)),"TRUE","FALSE")

nginx安裝與調(diào)優(yōu) 啟動容器 liwangdeMacBook-Air:~liwang$dockerrun-i-t--namenginx_server_01-v/Users/liwang/docker/nginx_data:/data-p80:80centos/bin/bash 將文件copy至容器中 liwangdeMacBook-Air:~liwang$dockercpDownloads/nginx-1.14.0.tar.gznginx_server_01:/soft/nginx-1.14.0.tar.gz 解壓 [root@e46ae471064esoft]#tarxf/soft/nginx-1.14.0.tar.gz-C/soft/ 安裝之前修改源碼屏蔽名稱以及版本號 [root@e46ae471064ecore]#ls-l"/soft/nginx-1.14.0/src/core/nginx.h" -rw-r--r--110011001476Apr1715:22/soft/nginx-1.14.0/src/core/nginx.h [root@e46ae471064ecore]# ------------------------------------------------------ #defineNGINX_VERSION"0.0.1" #defineNGINX_VER"HaiYan/"NGINX_VERSION #defineNGINX_VAR"HaiYan" ------------------------------------------------------ #defineNGINX_VERSION"1.14.0" #defineNGINX_VER"nginx/"NGINX_VERSION #defineNGINX_VAR"NGINX" ------------------------------------------------------ 安裝插件 [root@e46ae471064e~]#yuminstallpcrepcre-develgccgcc-c++makeopensslopenssl-devel-y 添加用戶 [root@e46ae471064enginx-1.14.0]#useraddnginx-s/sbin/nologin-M 安裝 [root@e46ae471064enginx-1.14.0]#./configure--prefix=/usr/local/nginx--with-http_ssl_module--with-http_stub_status_module--user=nginx--group=nginx [root@e46ae471064enginx-1.14.0]#make [root@e46ae471064enginx-1.14.0]#makeinstall 利用curl工具獲取服務(wù)器信息 [root@e46ae471064enginx]#curl-Ilocalhost HTTP/1.1200OK Server:HaiYan/0.0.1 Date:Tue,01May201814:39:56GMT Content-Type:text/html Content-Length:612 Last-Modified:Tue,01May201814:33:26GMT Connection:keep-alive ETag:"5ae87ab6-264" Accept-Ranges:bytes [root@e46ae471064enginx]# nginx虛擬主機配置 基于域名的虛擬主機 [root@e46ae471064econf]#catnginx.conf|grep-v"#"|grep-v"^$">>extra/www.conf 修改www.conf [root@e46ae471064eextra]#catwww.conf server{ listen80; server_namewww.wang-li.top; location/{ roothtml/www; indexindex.htmlindex.htm; } error_page500502503504/50x.html; location=/50x.html{ roothtml; } } [root@e46ae471064eextra]# 修改nginx.conf在http區(qū)間增加,includeextra/*;這行 [root@e46ae471064econf]#catnginx.conf|grep-v"#"|grep-v"^$" worker_processes1; events{ worker_connections1024; } http{ includemime.types; default_typeapplication/octet-stream; sendfileon; keepalive_timeout65; server{ listen80; server_namelocalhost; location/{ roothtml; indexindex.htmlindex.htm; } error_page500502503504/50x.html; location=/50x.html{ roothtml; } } includeextra/*; } [root@e46ae471064econf]# 增加html/www/index.html文件 [root@e46ae471064econf]#ls/usr/local/nginx/html/www/index.html-l -rw-r--r--1rootroot613May114:50/usr/local/nginx/html/www/index.html [root@e46ae471064econf]# 修改hosts文件，訪問 [root@e46ae471064econf]#cat/etc/hosts|grepwww.wang-li.top 127.0.0.1 www.wang-li.top [root@e46ae471064econf]#curl-Iwww.wang-li.top HTTP/1.1200OK Server:HaiYan/0.0.1 Date:Tue,01May201814:54:41GMT Content-Type:text/html Content-Length:613 Last-Modified:Tue,01May201814:50:21GMT Connection:keep-alive ETag:"5ae87ead-265" Accept-Ranges:bytes [root@e46ae471064econf]# 基于端口的虛擬主機 修改www.conf基于端口的訪問，如下: [root@e46ae471064eextra]#catwww.conf server{ listen8081; server_namewww.wang-li.top; location/{ roothtml/www; indexindex.htmlindex.htm; } error_page500502503504/50x.html; location=/50x.html{ roothtml; } } [root@e46ae471064eextra]# reloadnginx訪問如下 [root@e46ae471064eextra]#/usr/local/nginx/sbin/nginx-t nginx:theconfigurationfile/usr/local/nginx/conf/nginx.confsyntaxisok nginx:configurationfile/usr/local/nginx/conf/nginx.conftestissuccessful [root@e46ae471064eextra]#/usr/local/nginx/sbin/nginx-sreload [root@e46ae471064eextra]#curl-Iwww.wang-li.top:8081 HTTP/1.1200OK Server:HaiYan/0.0.1 Date:Tue,01May201814:56:48GMT Content-Type:text/html Content-Length:613 Last-Modified:Tue,01May201814:50:21GMT Connection:keep-alive ETag:"5ae87ead-265" Accept-Ranges:bytes [root@e46ae471064eextra]# 基于IP的虛擬主機 獲取容器ip liwangdeMacBook-Air:~liwang$dockerinspect-f{{.NetworkSettings.IPAddress}}nginx_server_01 172.17.0.2 liwangdeMacBook-Air:~liwang$ 修改www.conf如下 [root@e46ae471064eextra]#catwww.conf server{ listen172.17.0.2:8082; server_namewww.wang-li.top; location/{ roothtml/www; indexindex.htmlindex.htm; } error_page500502503504/50x.html; location=/50x.html{ roothtml; } } [root@e46ae471064eextra]# 訪問如下: [root@e46ae471064eextra]#curl-I172.17.0.2:8082 HTTP/1.1200OK Server:HaiYan/0.0.1 Date:Tue,01May201815:00:44GMT Content-Type:text/html Content-Length:613 Last-Modified:Tue,01May201814:50:21GMT Connection:keep-alive ETag:"5ae87ead-265" Accept-Ranges:bytes [root@e46ae471064eextra]# nginxstub_status說明 查看系統(tǒng)是否安裝此模塊 [root@e46ae471064eextra]#/usr/local/nginx/sbin/nginx-V nginxversion:HaiYan/0.0.1 builtbygcc4.8.520150623(RedHat4.8.5-16)(GCC) builtwithOpenSSL1.0.2k-fips26Jan2017 TLSSNIsupportenabled configurearguments:--prefix=/usr/local/nginx--with-http_ssl_module--with-http_stub_status_module--user=nginx--group=nginx [root@e46ae471064eextra]# 發(fā)現(xiàn)有--with-http_stub_status_module就是支持的 配置www.conf如下: [root@e46ae471064eextra]#catwww.conf server{ listen80; server_namewww.wang-li.top; location/{ #roothtml/www; #indexindex.htmlindex.htm; stub_statuson; access_logoff; } } [root@e46ae471064eextra]# 訪問如下 [root@e46ae471064eextra]#curlwww.wang-li.top Activeconnections:3 serveracceptshandledrequests 212120 Reading:0Writing:1Waiting:2 [root@e46ae471064eextra]# 三個值分別代表： activeconnections:正在處理的連接活動數(shù) 212120 第一個表示從啟動到現(xiàn)在一共處理了21次請求 第二個表示建立了21次握手 第三個表示總共處理了20次請求 丟包數(shù)=握手數(shù)-連接數(shù)可見，并未丟包 reading:nginx讀取到客戶端的header信息數(shù) writing:Nginx返回給客戶端的header信息數(shù) waiting:Nginx處理完等待下一次請求指令的駐留連接，在開啟keep-alive的情況下，這個值等于active-(reading+writing) nginxlog記錄日志 訪問日志記錄: nginx如果不指定format和access，則默認格式為： #log_formatmain\'$remote_addr-$remote_user[$time_local]"$request"\' #\'$status$body_bytes_sent"$http_referer"\' #\'"$http_user_agent""$http_x_forwarded_for"\'; #access_loglogs/access.logmain; 格式參數(shù)說明: $remote_addr:訪問網(wǎng)站客戶端地址 $http_x_forwarded_for:當(dāng)前端有代理服務(wù)器時，設(shè)置web節(jié)點記錄客戶端地址配置，此參數(shù)前提是服務(wù)器進行了相關(guān)x_forwarded_for設(shè)置 $remote_user：遠程客戶端用戶名稱 $time_local：記錄訪問時間與時區(qū) $request：用戶的http起始行信息 $status:http狀態(tài)碼 $body_bytes_sent:服務(wù)器發(fā)送給客戶端相應(yīng)body字節(jié)數(shù) $http_referer:記錄此請求時從哪個連接過來的 $http_user_agent：記錄客戶端的訪問信息 關(guān)于access_log官方說明： Syntax:access_logpath[format[buffer=size][gzip[=level]][flush=time][if=condition]]; access_logoff; Default: access_loglogs/access.logcombined; Context:http,server,location,ifinlocation,limit_except buffer=size：訪問日志緩沖器大小 gzip[=level：壓縮級別 flush=time：緩沖器的日志刷新到磁盤時間 if=condition：其他條件 access_logoff：不記錄訪問日志 nginx_location: 語法: location[=|~|~*|^-]url{ ... } ~和~*的區(qū)別:~區(qū)分大小寫，~*不區(qū)分大小寫 =:為精確配置 /:為默認配置 其他配置依上至下 nginxrewrite: 語法: rewrite^/(.*)url/$1permanent; 意思是只要匹配如下^/(.*)，就跳轉(zhuǎn)至url上，且$1是取前面regex部分括號的內(nèi)容，結(jié)尾的primanent是永久301重定向標(biāo)記。 regex語法: ：去掉特殊字符 ^：起始位置 $：結(jié)束位置 *：匹配0次或多次 +：匹配前面的字符一次或多次 ?:匹配前面的字符0次或1次 .:匹配n之外的任何字符 (pattern):匹配括號內(nèi)字符，并可以在后面匹配，常用$0-$9屬性獲取值 rewriteflag標(biāo)記 last:本條規(guī)則匹配完成后，繼續(xù)向下匹配 break:本條規(guī)則匹配完成后，不再匹配后面的規(guī)則 redirect:返回302臨時重定向， permanent:返回301永久重定向 nginx訪問認證: 設(shè)置密碼: [root@e46ae471064econf]#htpasswd-cb/usr/local/nginx/conf/htpasswdliwangliwang 修改conf: [root@e46ae471064econf]#sed-n"48,54p"nginx.conf location/{ roothtml; indexindex.htmlindex.htm; auth_basic"test"; auth_basic_user_file/usr/local/nginx/conf/htpasswd; } [root@e46ae471064econf]#