How to get output as Tabular Format from Shell scripting?

Question

I have data in text file in below format

/gpfs/pcenterdata/test/SrcFiles/WCC_CDHP_LITES/WGS1/CLM/text1.txt
/gpfs/pcenterdata/test/SrcFiles/WCC_CDHP_LITES/WGS1/CLM/text2.txt
/gpfs/pcenterdata/test/SrcFiles/WCC_CDHP_LITES/EMP2/text3.txt
/gpfs/pcenterdata/test/SrcFiles/WCC_CDHP_LITES/ACS1/text4.txt

I want output as below

                 Path Name                                         File Name
/gpfs/pcenterdata/test/SrcFiles/WCC_CDHP_LITES/WGS1/CLM/           text1.txt
/gpfs/pcenterdata/test/SrcFiles/WCC_CDHP_LITES/WGS1/CLM/           text2.txt
/gpfs/pcenterdata/test/SrcFiles/WCC_CDHP_LITES/EMP2/               text3.txt
/gpfs/pcenterdata/test/SrcFiles/WCC_CDHP_LITES/ACS1/               text4.txt

Answer 1

You can use awk and column commands like:

awk -F'/' 'BEGIN{print "PathName FileName"}{a="";for(i=2;i<=NF-1;i++){a=a"/"$i};a=a"/";print a"\t"$NF}' file_name  | column -t

It will print like:

PathName                                                  FileName
/gpfs/pcenterdata/test/SrcFiles/WCC_CDHP_LITES/WGS1/CLM/  text1.txt
/gpfs/pcenterdata/test/SrcFiles/WCC_CDHP_LITES/WGS1/CLM/  text2.txt
/gpfs/pcenterdata/test/SrcFiles/WCC_CDHP_LITES/EMP2/      text3.txt
/gpfs/pcenterdata/test/SrcFiles/WCC_CDHP_LITES/ACS1/      text4.txt

If you want to keep the spaces between words Path Name and File Name, then you can delimit by tab instead of space.

awk -F'/' 'BEGIN{print "         Path Name\tFile Name"}{a="";for(i=2;i<=NF-1;i++){a=a"/"$i};a=a"/";print a"\t"$NF}' file_name  | column -t -s $'\t'

         Path Name                                        File Name
/gpfs/pcenterdata/test/SrcFiles/WCC_CDHP_LITES/WGS1/CLM/  text1.txt
/gpfs/pcenterdata/test/SrcFiles/WCC_CDHP_LITES/WGS1/CLM/  text2.txt
/gpfs/pcenterdata/test/SrcFiles/WCC_CDHP_LITES/EMP2/      text3.txt
/gpfs/pcenterdata/test/SrcFiles/WCC_CDHP_LITES/ACS1/      text4.txt

Answer 2

ksh only (eg. printf is a shell built-in)

# find the longest path name
MP=0
while read
do
  P="${REPLY%/*}"
  PS=${#P}
  [ $PS -le $MP ] || MP=$PS
done < /tmp/test.txt

# calculate where to put "Path Name"
(( MP++ ))
T="Path Name"
TS=${#T}
(( SS = ( MP - TS ) / 2 ))
(( SP = ( MP - TS ) % 2 ))
printf "%${SS}s%s%${SS}s%${SP}s %s\n" "" "$T" "" "" "File Name"

# format the input text
while read
do
  P="${REPLY%/*}"
  F="${REPLY##*/}"
  printf "%-${MP}s %s\n" "$P/" "$F"
done < /tmp/test.txt

You may understand why some weaker of heart revert to using POSIX commands.

Answer 3

Using Perl + column,you could run something along the lines of

perl -pE 'BEGIN{say "Path\tFile\n"} s!.*/\K!\t!' input | column -t

Answer 4

We may employ tbl, groff which is GNU's adaptation of nroff, and the line editor ed.

We first break apart into dirname and basename each line and then inject tbl code at the beginning and end of the file. The tbl code is to center the header columns and left justify the rest.

The tbl utility spits working groff code which groff then operats upon to gets the desired output. The grep is to deletes empty lines.

$ ed -s inp <<\eof | tbl | groff -Tascii | grep .
,s|[^/]*$|@&|
1i
.TS
tab(@);
c c
l l.
PATH NAME@FILE NAME
.
$a
.TE
.
,p
Q
eof

Output:

                       PATH NAME                           FILE NAME
/gpfs/pcenterdata/test/SrcFiles/WCC_CDHP_LITES/WGS1/CLM/   text1.txt
/gpfs/pcenterdata/test/SrcFiles/WCC_CDHP_LITES/WGS1/CLM/   text2.txt
/gpfs/pcenterdata/test/SrcFiles/WCC_CDHP_LITES/EMP2/       text3.txt
/gpfs/pcenterdata/test/SrcFiles/WCC_CDHP_LITES/ACS1/       text4.txt

Answer 5

Like Prvt_Yadav, you can use awk & column, but awk's "gensub" function can be used to extract the required text.

awk 'BEGIN{print "PathName\tFileName"} {f=gensub(/.*\//,"\\1","1"); p=gensub(/[^/]*$/,"\\1","1"); print p"\t"f}' | column -t

Answer 6

If your source really is this file, you can do it like this:

(echo full_path; cat input) | 
  csv-add-split -c full_path -e / -n parent,name -r |
  csv-cut -c parent,name -S

But if your source is a directory path you can do it like this:

csv-ls -R -c parent,name /gpfs/pcenterdata/test/SrcFiles -S

These commands come from csv-nix-tools (https://github.com/mslusarz/csv-nix-tools).