Question

Using awk,

create a subdirectory in one directory, for each line in a csv and each line in the csv looks like: first_name,last_name,id_number

need each subdirectory to be in the form "last_name.first_name.id_number"

Answer 1

Please find the following answer for the question using awk script in Unix Shell and added necessary comments, screen shots for your reference.

Note:

1. Using awk, we treat each line as a record through which we can edit the fields and redirect to new file.

2. We can "system" system call in awk to create a directory once we read all the three fields.

Program:

#!/bin/bash
#empty variable
dirName=

if [ $# -ne 1 ]
then
   echo "$0 <csv file>"
   exit 1
fi

if [ ! -f $1 ]
then
   echo "$1: file not present"
   exit 1
fi

echo "Enter the directory name, where directories needs to be created"
read dirName

#check if user enters any name, else take current directory
#to create directory for each record
if [ ! -z $dirName ]
then
#if directory is not present, create one directory
if [ ! -d $dirName ]
then
   mkdir $dirName
   if [ $? -eq 0 ]
   then
       echo "Directory: $dirName created"
   fi
fi
else
   dirName=.
fi

#mention delimiter as "," to read field from csv file and pass the
#directory name to awk script
awk -F"," -v dir_Name=$dirName '
BEGIN { count =0 }
/./ {
tempDir=""
#using sprintf create the command to create a directory
tempDir = sprintf("mkdir %s/%s.%s.%s", dir_Name,$2,$1,$3)
#system command to execute the command
system(tempDir);
#increment the count value for each creation and print at the end
count++;
}
END { printf("Total number of directories created: %d\n", count) }' $1

Output:

osboxes@osboxes:~/Chegg/SHELL$ ./dirFromCsv.sh csvFileDr.csv
Enter the directory name, where directories needs to be created
test1
Total number of directories created: 3

osboxes@osboxes:~/Chegg/SHELL$ ./dirFromCsv.sh
./dirFromCsv.sh <csv file>
osboxes@osboxes:~/Chegg/SHELL$

osboxes@osboxes:~/Chegg/SHELL$ ./dirFromCsv.sh csvFileDr.csv
Enter the directory name, where directories needs to be created
.
Total number of directories created: 3
osboxes@osboxes:~/Chegg/SHELL$ ls -ltr|tail
-rw-r--r-- 1 osboxes osboxes 48 Feb 20 20:14 csvFileDr.csv
drwxr-xr-x 5 osboxes osboxes 4096 Feb 20 20:19 test1
-rwxr-xr-x 1 osboxes osboxes 1045 Feb 20 20:21 dirFromCsv.sh
drwxr-xr-x 2 osboxes osboxes 4096 Feb 20 20:22 Bryant.Kobe.24
drwxr-xr-x 2 osboxes osboxes 4096 Feb 20 20:22 James.Lebron.23
drwxr-xr-x 2 osboxes osboxes 4096 Feb 20 20:22 middleton.kris.1
osboxes@osboxes:~/Chegg/SHELL$
osboxes@osboxes:~/Chegg/SHELL$ cd test1
osboxes@osboxes:~/Chegg/SHELL/test1$ ls -ltr
total 12
drwxr-xr-x 2 osboxes osboxes 4096 Feb 20 20:19 Bryant.Kobe.24
drwxr-xr-x 2 osboxes osboxes 4096 Feb 20 20:19 James.Lebron.23
drwxr-xr-x 2 osboxes osboxes 4096 Feb 20 20:19 middleton.kris.1
osboxes@osboxes:~/Chegg/SHELL/test1$

Screen Shot: Note, you can ignore the line numbers present in screen shot and its added for better understanding.