Convert CSV to array in Bash

Question

I have a CSV with each row 2 IPs. I want to combine 2 IPs separated by *** and populate in an array. I tried the code below, but I only get the last row.

#!/bin/bash

INPUT="IPPairs.csv"
array=()

while IFS="," read var1 var2 ; do
        echo $var1 $var2
        pairString="$var1***$var2"
        array+=($pairString)
done < $INPUT

echo "${array[@]}"

Work's fine for me. Are your ip addresses in IPPairs.csv comma delimited? Consider tossing some double quotes in there array+=("$pairString") for example. But with straight IP addresses, you should be fine. If there are domain names in there with backslashes you may want to use read -r to avoid mangling — JNevill
– JNevill, Commented May 6, 2019 at 13:08

Benjamin W. · Accepted Answer · 2019-05-06 14:53:49Z

1

Unless your input file contains something other than , as the delimiter, your code should work. You could make it shorter, though (requires Bash 4.0 or newer):

mapfile -t array < IPPairs.csv
array=("${array[@]/,/***}")

The first command reads the file into an array, the second command replaces , with *** in each array element.

answered May 6, 2019 at 14:53

Benjamin W.

54k19 gold badges135 silver badges136 bronze badges

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

Collectives™ on Stack Overflow

Convert CSV to array in Bash

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related