通过Excel自动生成Shell Script

最新推荐文章于 2026-06-30 09:03:49 发布

原创最新推荐文章于 2026-06-30 09:03:49 发布 · 1.2k 阅读

本内容遵循CC 4.0 BY-SA版权协议

收录于

Linux

Tool

这篇博客介绍了如何利用Excel来自动化创建Shell Script。通过设置特定格式的数据，结合函数1和函数2，可以便捷地生成Shell脚本的代码行。函数1用于处理指定数据，而函数2则用于生成Shell Script的指定部分。

指定数据

xxxxxxxxxx

00000123456

1900/01/01 14:57:27

-123456

ins-xxx-sky

函数

Gen “Celebrus fires content request to Pega - Sending content request to server” Shell Script

="grep -n "&A2&" LogFileName* | grep """&TEXT(C2,"yyyy/MM/dd")&""" | grep ""\""xxxxxxxx\"": \"""&A2&""" | less"

Gen“Celebrus sends ContentDisplayed to Pega - Sending event” Shell Script

="grep -n "&A2&" LogFileName* | grep ""xxxxxxxx"" | grep """&E2&""" | grep """&TEXT(C2,"yyyy/MM/dd")&""" | less"

结果：

Gen "Type 1" Shell Script

grep -n xxxxxxxx LogFileName* | grep "1900/01/01" | grep "\"xxxxxx\": \"xxxxxxxxxxx" | less

Gen "Type 2" Shell Script

grep -n xxxxxxxx LogFileName* | grep "xxxxxxxx" | grep "ins-xxx-sky" | grep "1900/01/01" | less

指定数据：

Gen designation line Shell Script

Shell Script	Data cleaning	Data cleaning	Data cleaning	Log
				LogFileName.log.24:27578:1900/01/01 15:26:43 \| "xxxxxxxx": "xxxxxxxxx",

函数：

Shell Script	Data cleaning	Data cleaning	Data cleaning	Log
="less -n +"&C14&" "&B14	=LEFT(D14,FIND(":",D14)-1)	=RIGHT(D14,LEN(D14)-FIND(":",D14))	=LEFT(E14,FIND(":2019",E14)-1)	LogFileName.log.24:27578:1900/01/01 15:26:43 \| "xxxxxxxxx": "xxxxxxxxx",

结果：

Shell Script	Data cleaning	Data cleaning	Data cleaning	Log
less -n +27578 LogFileName.log.24	LogFileName.log.24	27578	LogFileName.log.24:27578	LogFileName.log.24:27578:1900/01/01 15:26:43 \| "xxxxxxxxx": "xxxxxxxxx",

标签

#Excel #Auto Shell