bash shell array output range to csv

Question

Is there an easier way to do the below? I am reading in a large cvs file and want to only display ranges on the index per line and output back into a csv format.

while  IFS=$',' read -r -a myArray
do
    echo ${myArray[44]},${myArray[45]},${myArray[46]},${myArray[47]},${myArray[48]},${myArray[65]},${myArray[66]},${myArray[67]}
done < $SHEET

chepner · Accepted Answer · 2013-06-18 16:40:57Z

4

You can use the substring operator with array parameter expansion:

while IFS=, read -r -a myArray
do
    ( IFS=,; echo "${myArray[*]:44:5},${myArray[*]:65:3}" )
done

answered Jun 18, 2013 at 16:40

chepner

538k77 gold badges594 silver badges746 bronze badges

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

Comments

jaypal singh · Accepted Answer · 2013-06-18 16:48:28Z

2

awk 'BEGIN{FS=OFS=","}{print $44, $45, $46, $47, $48, $65, $66, $67}' "$SHEET"

We set the Input Field Separator (FS) and Output Field Separator (OFS) to , so that output will be in csv format.

answered Jun 18, 2013 at 16:48

jaypal singh

77.6k24 gold badges108 silver badges147 bronze badges

Comments

anubhava · Accepted Answer · 2013-06-18 16:41:45Z

0

Looks like this is tailor-made job of awk. Use this awk command:

awk -F"," '{printf("%s,%s,%s,%s,%s,%s,%s,%s\n", 
            $44, $45, $46, $47, $48, $65, $66, $67)}' $SHEET

answered Jun 18, 2013 at 16:41

anubhava

790k67 gold badges603 silver badges671 bronze badges

Collectives™ on Stack Overflow

bash shell array output range to csv

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related