我如何在Shell中获得MCCLI输出中的定界符

Question

在尝试处理“mccli Activity show”的输出（例如）时，输出可能如下所示：

ID               Status                   Error Code Start Time           Elapsed     End Time             Type             Progress Bytes    New Bytes    

---------------- ------------------------ ---------- -------------------- ----------- -------------------- ---------------- ----------------- ---------    

9133910640004809 Completed w/Exception(s) 10020      2012-06-07 18:00 EDT 00h:53m:46s 2012-06-07 18:53 EDT Scheduled Backup 215   0.2%

9133914600006909 Completed                0          2012-06-08 05:00 EDT 00h:00m:04s 2012-06-08 05:00 EDT Scheduled Backup 0                 0%

Desired Output

ID,               Status,                   Error Code, Start Time          ,Elapsed     ,End Time             ,Type             ,Progress Bytes    ,New Bytes    

----------------,------------------------, ---------- ,--------------------, -----------, --------------------, ---------------- ,----------------- ,---------    

9133910640004809, Completed w/Exception(s), 10020,      2012-06-07 18:00 EDT, 00h:53m:46s ,2012-06-07 18:53 EDT, Scheduled Backup,  215 ,  0.2%

9133914600006909, Completed ,               0,          ,2012-06-08 05:00 EDT, 00h:00m:04s ,2012-06-08 05:00 EDT, Scheduled Backup, 0 ,                0%

Code I Tried

awk '!/---/{$1=x; sub(/,+$/,x)}1' OFS=,

but it does not work as it put comma for every space

Answer 1

您发布的预期输出并没有真正的意义（例如，一个明显字段的0，的明显字段的逗号，有时您在逗号之前，有时在逗号之前，有时在其之前和之后都有空白）和我认为您的示例输入不是准确的（例如215和0.2％看起来太近了），所以我猜是 - 但是 - 使用GNU AWK用于fiedwidths < /code>和nextfile，这可能是您真正想做的：

$ cat tst.awk
NR == FNR {
    if ( /^[- ]+$/ ) {
        wids = length($1)
        for ( i=2; i<=NF; i++ ) {
            wids = wids " " length(FS $i)
        }
        nf = NF
        nextfile
    }
    next
}
FNR == 1 {
    FIELDWIDTHS = wids
    OFS = ","
    $0 = $0
}
NF { $nf = $nf }
{ print }

$ awk -f tst.awk file file
ID              , Status                  , Error Code, Start Time          , Elapsed    , End Time            , Type            , Progress Bytes   , New Bytes

----------------, ------------------------, ----------, --------------------, -----------, --------------------, ----------------, -----------------, ---------

9133910640004809, Completed w/Exception(s), 10020     , 2012-06-07 18:00 EDT, 00h:53m:46s, 2012-06-07 18:53 EDT, Scheduled Backup, 215   0.2%,

9133914600006909, Completed               , 0         , 2012-06-08 05:00 EDT, 00h:00m:04s, 2012-06-08 05:00 EDT, Scheduled Backup, 0                , 0%

或者：

$ cat tst.awk
NR == FNR {
    if ( /^[- ]+$/ ) {
        wids = length($1)
        for ( i=2; i<=NF; i++ ) {
            wids = wids " " length(FS $i)
        }
        nf = NF
        nextfile
    }
    next
}
FNR == 1 {
    FIELDWIDTHS = wids
    OFS = ","
    $0 = $0
}
NF {
    $nf = $nf
    $0 = gensub(/( +),/,",\\1","g")
}
{ print }

$ awk -f tst.awk file file
ID,               Status,                   Error Code, Start Time,           Elapsed,     End Time,             Type,             Progress Bytes,    New Bytes

----------------, ------------------------, ----------, --------------------, -----------, --------------------, ----------------, -----------------, ---------

9133910640004809, Completed w/Exception(s), 10020,      2012-06-07 18:00 EDT, 00h:53m:46s, 2012-06-07 18:53 EDT, Scheduled Backup, 215   0.2%,

9133914600006909, Completed,                0,          2012-06-08 05:00 EDT, 00h:00m:04s, 2012-06-08 05:00 EDT, Scheduled Backup, 0,                 0%