Shell script to read and update a csv file

Question

I require some help in reading and updating a csv file using Shell script. I have written the below code to read the csv file and it works fine.

#!/bin/sh
#This script is to read the excel data
IFS=","
echo "Starting to read csv"
i=1
while read f1 f2
do
    test $i -eq 1 && ((i=i+1)) && continue
    echo "tenantID is :$f1"
    echo "status is   :$f2"

#The below command will update the schema with data

java -Xmx512m -XX:MaxPermSize=128m -jar biz.jar -install -readers=seed -          delegator=default#$f1

done < TenantId.csv

echo "end of file "

The above code is working fine. I.e it reads the csv file and passes the tenantID to the java arg. Once the java processing is done, I would like to update the status(f2) with some values. Also in the above code,blank lines are also getting executed.I would like to know how to process only the lines where data is present. Please let me know how to acheive the same.

Thanks in Advance

Guru · Accepted Answer · 2012-11-27 05:53:55Z

1

while read f1 f2
do
    test $i -eq 1 && ((i=i+1)) && continue
    [ -z "$f1" ] && continue
    echo "tenantID is :$f1"
    echo "status is   :$f2"

    #The below command will update the schema with data

    java -Xmx512m -XX:MaxPermSize=128m -jar biz.jar -install -readers=seed -          delegator=default#$f1

    echo $f1, XXX >> TenantIdOut.csv
done < TenantId.csv

Added 2 lines of code:

If the f1 is null, continue - This is to skip blank lines.
Write the record f1 and new status to a new file , and outside the loop you can rename the input file with this new file.

answered Nov 27, 2012 at 5:53

Guru

17.1k2 gold badges37 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

vr3w3c9 Over a year ago

Hi Guru, Thanks a lot for the information. In the second line, I would like to update the same TenantID.csv file & dont want to write to a different file.Also I want to update only the status(f2) of the row the system is currently processing.

Guru Over a year ago

Being inside the while loop, you cannot update the input file.. You can write to a temporary file, and after the while loop , you can rename your temp file with the input file.

Collectives™ on Stack Overflow

Shell script to read and update a csv file

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related