主页 / coding / 问题 / 77010695
Accepted
Lord OfTheRing
Asked: 2023-08-31 02:35:04 +0800 CST

使用 AWK 命令将文本提取到多列中

  • 772

我有以下文字：

    roledetails="name: CLD:HYB_Y_BASIS_ADMIN
    description: Basis Admin
    readOnly: <null>
    roleReferences:
      - description: desc1
        name: AuthGroup_Administrator
        roleTemplateAppId: it!b2455
        roleTemplateName: AuthGroup_Administrator
      - description: Desc2
        name: AuthGroup_BusinessExpert
        roleTemplateAppId: it!b2455
        roleTemplateName: AuthGroup_BusinessExpert
"

我喜欢转换为以下格式的 .csv 文件。我将如何使用 AWK 来做到这一点？

Collection Role Desc,Role_Name,App_Id, Role_Template
CLD:HYB_Y_BASIS_ADMIN, desc1, AuthGroup_Administrator,it!b2455,AuthGroup_Administrator
CLD:HYB_Y_BASIS_ADMIN, desc2, AuthGroup_BusinessExpert,it!b2455,AuthGroup_BusinessExpert

我尝试了下面的代码但不起作用：

declare fullfilepath=$(pwd)"/test1.csv"    
awk -F':[[:space:]]+' -v fullfilepath="$fullfilepath" 'NR==1{               # When on Line 1
        a=$2;cnt=0            # Set a and cnt vars
    }
    /^-/{                     # When line starts with -
        rta[cnt]=$2; getline; # Add role template app ID to rta array
        rtn[cnt]=$2; getline; # Add role template name to rtn array
        n[cnt]=$2;cnt++       # Add name to n array
    }
    END{                      # When the file processing is over
        for(i=0;i<cnt;i++) {  # Iterate over the found values and... 
            #print a","n[i]","rtn[i]","rta[i]     # print them
            printf a","n[i]","rtn[i]","rta[i] "\n"  >> fullfilepath   # print them
        }
    }' <<< "$roledetails"
shell

2 个回答

  1. TXR中的解决方案

    Collection,Role Desc,Role_Name,App_Id, Role_Template
CLD:HYB_Y_BASIS_ADMIN,desc1,AuthGroup_Administrator,it!b2455,AuthGroup_Administrator
CLD:HYB_Y_BASIS_ADMIN,Desc2,AuthGroup_BusinessExpert,it!b2455,AuthGroup_BusinessExpert

    使用 Bash 重定向从变量<<<：

    $ role_details="$(cat roledeets)"
$ txr rd2csv.txr <<<"$role_details"
Collection,Role Desc,Role_Name,App_Id, Role_Template
CLD:HYB_Y_BASIS_ADMIN,desc1,AuthGroup_Administrator,it!b2455,AuthGroup_Administrator
CLD:HYB_Y_BASIS_ADMIN,Desc2,AuthGroup_BusinessExpert,it!b2455,AuthGroup_BusinessExpert

    代码：

    name: @coll
@(collect)
      - description: @desc
        name: @name
        roleTemplateAppId: @appid
        roleTemplateName: @templ
@(end)
@(output)
Collection,Role Desc,Role_Name,App_Id, Role_Template
@  (repeat)
@coll,@desc,@name,@appid,@templ
@  (end)
@(end)
    • 1
  2. Best Answer

    假设：

    • 标头应该有 5 个字段，而不是 OP 提供的 4 个字段
    • 数据字段在逗号之前/之后不应有空格（如某些 OP 的预期输出字段）
    • 每个rollReferences块都有相同的 5 个字段，最后一个字段始终是roleTemplateName

    一个awk想法：

    awk '
BEGIN                      { FS  = ":[[:space:]]+"
                             OFS = ","
                             print "Collection","Role Desc","Role_Name","App_Id","Role_Template"
                           }
$1 ~ /^name$/              { coll = $2 }
$1 ~ /- description$/      { desc = $2 }
$1 ~ / name$/              { name = $2 }
$1 ~ / roleTemplateAppId$/ { id   = $2 }
$1 ~ / roleTemplateName$/  { print coll,desc,name,id,$2 }
' <<< "${roledetails}"

    注意：这在很大程度上取决于输入数据的确切格式

    这会生成：

    Collection,Role Desc,Role_Name,App_Id,Role_Template
CLD:HYB_Y_BASIS_ADMIN,desc1,AuthGroup_Administrator,it!b2455,AuthGroup_Administrator
CLD:HYB_Y_BASIS_ADMIN,Desc2,AuthGroup_BusinessExpert,it!b2455,AuthGroup_BusinessExpert
    • 1

相关问题