Shell - Widget: Column

Description

Voici une petite fonction en bash permettant de formater un fichier ou une variable sous la forme d'un tableau. Elle est utile sur les systèmes ne disposants pas de la fonction column.

Arguments

# ./column.sh --help

    --help    : Help

    --input   : Input File|Variable
    --column  : Column to Display      [Default=all] (Ex: 1,3|1-3|2)
    --header  : Display Header         [Default=No]
    --sort    : Sort Column            [Default=No]  (Ex: k2,n,r)
    --sep     : Input Separator        [Default=';']
    --mrg     : Margin between Column  [Default=1]

Examples

Input file:

Title1;Title2;Title3
Field_Aaa;Field_Zzzz;Field_Bbbbb
Field_Uuuuu;Field_Xxxxxxx;Field_Yyy

Output:

# ./column.sh --input my_file.csv
 | Title1      | Title2        | Title3
 | Field_Aaa   | Field_Zzzz    | Field_Bbbbb
 | Field_Uuuuu | Field_Xxxxxxx | Field_Yyy

# ./column.sh --input my_file.csv --header
 | Title1      | Title2        | Title3
 | ------      | ------        | ------
 | Field_Aaa   | Field_Zzzz    | Field_Bbbbb
 | Field_Uuuuu | Field_Xxxxxxx | Field_Yyy

# ./column.sh --input my_file.csv --header --sort k2,r
 | Title1      | Title2        | Title3
 | ------      | ------        | ------
 | Field_Uuuuu | Field_Xxxxxxx | Field_Yyy
 | Field_Aaa   | Field_Zzzz    | Field_Bbbbb

# ./column.sh --input my_file.csv --header --mrg 4
 | Title1         | Title2           | Title3
 | ------         | ------           | ------
 | Field_Aaa      | Field_Zzzz       | Field_Bbbbb
 | Field_Uuuuu    | Field_Xxxxxxx    | Field_Yyy
 ```

## Codes

### Version Complète

```bash
#!/bin/bash

array_column(){

    local lst=''
    local cl_cnt='all'
    local header=0
    local sorting=0
    local sep=';'
    local mrg=1

    local usage="
    --help    : Help

    --input   : Input File|Variable
    --column  : Column to Display      [Default=all] (Ex: 1,3|1-3|2)
    --header  : Display Header         [Default=No]  
    --sort    : Sort Column            [Default=No]  (Ex: k2,n,r)
    --sep     : Input Separator        [Default=';']
    --mrg     : Margin between Column  [Default=1]
    "

    for _ in $(seq 1 $#); do
        case $1 in
            -h|--help  ) echo "$usage"; exit 0;;
            --input    ) lst=$2; shift 2;;
            --column   ) cl_cnt=$2; shift 2;;
            --header   ) header=1; shift 1;;
            --sort     ) sorting=$2; shift 2;;
            --sep      ) sep=$2; shift 2;;
            --mrg      ) mrg=$2; shift 2;;

            ''         ) shift 1;;
            *          ) echo '<!> Bad Argument(s) [--help]'; exit 1;;
        esac
    done

    [ -z $lst ] && { echo '<!> Argument --input Needed'; exit 1; }
    [ -e $lst ] && lst=$(cat $lst) || lst=$(echo -e "$lst")

    if [ $header == 1 ]; then
        h=$(echo "$lst" | sed -n '1p')
        h_line=$(echo "$h" | sed -r 's#(\w|\d)#\-#g')
        lst=$(echo "$lst" | sed '1d')
    fi

    [ $sorting != 0 ] && lst=$(echo "$lst" | sort -$(echo ${sorting} | sed 's/,/\ \-/g'))
    [ $header == 1 ] && lst=$(echo "$h"; echo "$h_line"; echo "$lst")

    case $cl_cnt in
        *-*     ) local f_lst=($(seq ${cl_cnt%-*} ${cl_cnt#*-}));;
        *,*     ) local f_lst=($(echo "$cl_cnt" | sed s/,/\\n/g));;
        *[0-9]* ) local f_lst=($cl_cnt);;
        *|all   ) local f_lst=($(seq 1 $(echo "$lst" | head -n 1 | awk -v sep=$sep 'BEGIN{FS=sep} {print NF}')));;
    esac

    for f in ${f_lst[@]}; do
        cl[$f]=$(($(echo "$lst" | awk -v f=$f -v sep=$sep 'BEGIN{FS=sep} {print length($f)}' 2>&- | sort -n | sed -n '$p') + ${mrg}))
    done

    local pr_fmt=$(
        printf " "
        for f in ${f_lst[@]}; do
            echo -e "| %-${cl[$f]}.${cl[$f]}s\c"
        done
        printf "\\\n"
    )

    echo "$lst" | awk -v sep=$sep 'BEGIN{FS=sep}
        {printf "'"$pr_fmt"'", '"$(echo $(for f in ${f_lst[@]}; do echo "\$${f}"; done) | sed 's/\ /,\ /g')"'}
    '

}

array_column $*

Version Compacte

array_column(){
    # Arguments : Liste Column_Count(Df:All) Separator(Df:';') Marge(Df:1)

    [ -e $1 ] && local lst=$(cat $1) || local lst=$(echo -e "$1")

    case $2 in
        *-*     ) local f_lst=($(seq ${2%-*} ${2#*-}));;
        *,*     ) local f_lst=($(echo "$2" | sed s/,/\\n/g));;
        *[0-9]* ) local f_lst=($2);;
        *       ) local f_lst=($(seq 1 $(echo "$lst" | head -n 1 | awk -v sep=${3:-';'} 'BEGIN{FS=sep} {print NF}')));;
    esac

    for f in ${f_lst[@]}; do
        cl[$f]=$(($(echo "$lst" | awk -v f=$f -v sep=${3:-';'} 'BEGIN{FS=sep} {print length($f)}' 2>&- | sort -n | sed -n '$p') + ${4:-1}))
    done

    local p_fmt=$(printf " "; for f in ${f_lst[@]}; do echo -e "| %-${cl[$f]}.${cl[$f]}s\c"; done; printf "\\\n")
    echo "$lst" | awk -v sep=${3:-';'} 'BEGIN{FS=sep} {printf "'"$p_fmt"'", '"$(echo $(for f in ${f_lst[@]}; do echo "\$${f}"; done) | sed 's/\ /,\ /g')"'}'

}