UNIX for Advanced & Expert Users

Hi,

I have a text file with multiple lines, each having data in the below format <DOB>,<ADDRESS>

I have to write a script which reads each line in the text file in loop, assign the values to these variables and do some further processing in it.

Using the following code prints the values but I need them in variables.Also, it reads only first line of the file.
cat filename | paste -d"," - - - | awk 'BEGIN{FS=","}{print "DOB="$1" ADDRESS="$2" }'
Am I wrong in my approach?

post the sample input file

The sample file will be a text/csv file with datas as

C:/My Documents/Data,20
D:/My photos,30


I need a way to read the values of the folder path and age of files in different variables from different lines in a loop.

Code:

for i in `cat filename`
do
 file_path=`echo  $i | cut -d"," -f1`
 age=`echo $i | cut -d"," -f2`
 
 echo $file_path
 echo $age 
done

Its working, Thank you!

one more way

Code:

while read line ; do
path=`echo $line | awk -F',' '{print $1}'`
age=`echo $line | awk -F',' '{print $2}'`
echo $path 
echo $age
done < filename

Which saves some processes since there are no pipelines. Just tell the shell the Input Field Separator is the character of the field separator in the file and it automatically will use that to parse each line:

Code:

#!/bin/ksh

file="inputfile.txt"

while IFS=',' read path age
do
  print "[$path] [$age]"
done < $file

exit 0

Output:

Code:

$ a
[C:/My Documents/Data] [20]
[D:/My photos] [30]
$