2023年7月7日 06:34:38go评论59阅读模式

英文:

formatting files with awk to get it to YYYY-MM-DD,value format

问题

我想要这样的内容：

日期,温度
2023-06-29,38
2023-06-29,38

这是我迄今为止的进展（仍在尝试中）：

>> awk -F"[[:blank:]]{2,}" '{print FILENAME,$3}' /log/msg/sched/4G-Fan-Temperature-JZ/2023-06-2[89]*_eNB_618159_table.log
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-28_14:20:02_eNB_618159_table.log
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-28_14:20:02_eNB_618159_table.log
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-28_14:20:02_eNB_618159_table.log
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-28_14:20:02_eNB_618159_table.log
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-28_14:20:02_eNB_618159_table.log temperature
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-28_14:20:02_eNB_618159_table.log
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-28_14:20:02_eNB_618159_table.log 37
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-28_14:20:02_eNB_618159_table.log
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-28_14:20:02_eNB_618159_table.log
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-28_14:20:02_eNB_618159_table.log
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-29_14:20:02_eNB_618159_table.log
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-29_14:20:02_eNB_618159_table.log
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-29_14:20:02_eNB_618159_table.log
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-29_14:20:02_eNB_618159_table.log
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-29_14:20:02_eNB_618159_table.log temperature
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-29_14:20:02_eNB_618159_table.log
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-29_14:20:02_eNB_618159_table.log 38
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-29_14:20:02_eNB_618159_table.log
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-29_14:20:02_eNB_618159_table.log
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-29_14:20:02_eNB_618159_table.log
>>

这是我正在处理的文件的外观：

>> cat /log/msg/sched/4G-Fan-Temperature-JZ/2023-06-2[89]*_eNB_618159_table.log
[2023-06-28 14:20:02] NE=eNB_618159 , USER=t828226 , USER_IP=127.0.0.1 , OPERATION=get , RESULT=OK
NODE-PATH=samsung4g-access-enbdu/managed-element/hardware-management/digital-unit/fan
RPC-REPLY-TABLE=
----------------------------------
NE Name   NE ID        temperature
----------------------------------
ATIDF     eNB_618159   37
----------------------------------
;

[2023-06-29 14:20:02] NE=eNB_618159 , USER=t828226 , USER_IP=127.0.0.1 , OPERATION=get , RESULT=OK
NODE-PATH=samsung4g-access-enbdu/managed-element/hardware-management/digital-unit/fan
RPC-REPLY-TABLE=
----------------------------------
NE Name   NE ID        temperature
----------------------------------
ATIDF     eNB_618159   38
----------------------------------
;

这是我在此示例中使用的两个文件：

>> ls -l /log/msg/sched/4G-Fan-Temperature-JZ/2023-06-2[89]*_eNB_618159_table.log
-rw-rw---- 1 vsm aceman 380 Jun 28 14:20 /log/msg/sched/4G-Fan-Temperature-JZ/2023-06-28_14:20:02_eNB_618159_table.log
-rw-rw---- 1 vsm aceman 380 Jun 29 14:20 /log/msg/sched/4G-Fan-Temperature-JZ/2023-06-29_14:20:02_eNB_618159_table.log

英文:

I want something like this:

date,temperature
2023-06-29,38
2023-06-29,38

This is as far as I have got so far(still trying)

&gt;&gt;awk -F&quot;[[:blank:]]{2,}&quot; &#39;{print FILENAME,$3}&#39; /log/msg/sched/4G-Fan-Temperature-JZ/2023-06-2[89]*_eNB_618159_table.log
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-28_14:20:02_eNB_618159_table.log
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-28_14:20:02_eNB_618159_table.log
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-28_14:20:02_eNB_618159_table.log
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-28_14:20:02_eNB_618159_table.log
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-28_14:20:02_eNB_618159_table.log temperature
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-28_14:20:02_eNB_618159_table.log
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-28_14:20:02_eNB_618159_table.log 37
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-28_14:20:02_eNB_618159_table.log
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-28_14:20:02_eNB_618159_table.log
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-28_14:20:02_eNB_618159_table.log
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-29_14:20:02_eNB_618159_table.log
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-29_14:20:02_eNB_618159_table.log
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-29_14:20:02_eNB_618159_table.log
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-29_14:20:02_eNB_618159_table.log
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-29_14:20:02_eNB_618159_table.log temperature
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-29_14:20:02_eNB_618159_table.log
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-29_14:20:02_eNB_618159_table.log 38
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-29_14:20:02_eNB_618159_table.log
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-29_14:20:02_eNB_618159_table.log
/log/msg/sched/4G-Fan-Temperature-JZ/2023-06-29_14:20:02_eNB_618159_table.log

This is what the files look like that I am working with

 &gt;&gt;
    &gt;&gt; cat /log/msg/sched/4G-Fan-Temperature-JZ/2023-06-2[89]*_eNB_618159_table.log
    [2023-06-28 14:20:02] NE=eNB_618159 , USER=t828226 , USER_IP=127.0.0.1 , OPERATION=get , RESULT=OK
    NODE-PATH=samsung4g-access-enbdu/managed-element/hardware-management/digital-unit/fan
    RPC-REPLY-TABLE=
    ----------------------------------
    NE Name   NE ID        temperature
    ----------------------------------
    ATIDF     eNB_618159   37
    ----------------------------------
    ;
    
    [2023-06-29 14:20:02] NE=eNB_618159 , USER=t828226 , USER_IP=127.0.0.1 , OPERATION=get , RESULT=OK
    NODE-PATH=samsung4g-access-enbdu/managed-element/hardware-management/digital-unit/fan
    RPC-REPLY-TABLE=
    ----------------------------------
    NE Name   NE ID        temperature
    ----------------------------------
    ATIDF     eNB_618159   38
    ----------------------------------
    ;

These are the 2 files I am using in this example

&gt;&gt; ls -l /log/msg/sched/4G-Fan-Temperature-JZ/2023-06-2[89]*_eNB_618159_table.log
-rw-rw---- 1 vsm aceman 380 Jun 28 14:20 /log/msg/sched/4G-Fan-Temperature-JZ/2023-06-28_14:20:02_eNB_618159_table.log
-rw-rw---- 1 vsm aceman 380 Jun 29 14:20 /log/msg/sched/4G-Fan-Temperature-JZ/2023-06-29_14:20:02_eNB_618159_table.log

答案1

得分: 3

awk 'BEGIN{ print "日期,温度" } /RESULT=/{ date=substr($1,2) } /ATIDF/{ print date "," $3 }' 2023-06-2[89]*_eNB_618159_table.log 输出:

 日期,温度 2023-06-28,37 2023-06-29,38

> substr($1,2): 输出从第二个字符到最后的 $1（这里去掉了前导 [）

英文:

I assume that the leading spaces are not part of your files.

awk &#39;BEGIN{ print &quot;date,temperature&quot; }
     /RESULT=/{ date=substr($1,2) }
     /ATIDF/{ print date &quot;,&quot; $3 }&#39; 2023-06-2[89]*_eNB_618159_table.log

Output:
<pre>
date,temperature
2023-06-28,37
2023-06-29,38
</pre>

> substr($1,2): Output $1 from second character to last (here remove leading [)

通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。

使用awk格式化文件以获得YYYY-MM-DD，值格式。

问题

答案1

将一个双精度浮点数格式化为不使用科学计数法的字符串。

在bash中解析一个包含不寻常字符、空格、括号和不规则换行的大型CSV文件：

如何将文件模式转换为整数？

日期格式错误

What's the correct way to type hint an empty list as a literal in python?

如何在Highcharts Gantt中更改本地化的星期名称

如何在同一个流中使用多个过滤器和映射函数？

如何使用Map/Set来将代码优化到O(n)？

.NET MAUI Android在GitHub Actions上构建失败，错误代码为1。

如何在Playwright视觉比较中屏蔽多个定位器？

在C++中，可以使用可变模板参数来检索类型的内部类型。

selenium.common.exceptions.StaleElementReferenceException: Message: stale element reference: stale element not found

Creating and opening a URL to log in to Website via Basic Auth with Robot Framework/Selenium (Python)

AG Grid 在上下文菜单中以大文本形式打开

发表评论